Hot answers tagged

7

In MySQL 5.7, the password field in mysql.user table field was removed, now the field name is authentication_string. First choose the database: mysql> use mysql; And then show the tables: mysql> show tables; You will find the user table, and see its fields: mysql> describe user; You will realize there is no field named password, the ...


2

I found the problem, I've used tzselect to select my timezone, however, /etc/sysconfig/clock was with ZONE=America/New_York, causing a little mistake on system and apps that consuming system date/time info. To fix it, and keep bios clock synchonized with system's clock, did these steps: sudo vim /etc/sysconfig/clock ZONE="America/Sao_Paulo" UTC=true ARC=...


1

I discovered that this version of MySQL 5.7.x on ubuntu 16.04 is compiled using editline library not readline - Im pretty sure thats the problem.


1

Those threads serve different purposes. There is a main thread that starts and waits until shutdown, there are several background threads in Innodb and Aria, and so on. Attach gdb and do thread apply all bt to see what they are doing - most likely they are sitting there doing nothing waiting for for some event to happen.


1

mysqladmin -u user-name password -p "oldpassword" "newpass" if you can login then try this "" wont work try '' single quote update user set password=PASSWORD("newpass") where User='ENTER-USER-NAME-HERE';


1

First run: aptitude -f install Then create mysql.list file : nano /etc/apt/sources.list.d/mysql.list add the following lines: deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 deb-src http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 Update and install mysql 5.6: apt-get update apt-get install mysql-server-5.6


1

I Solved the problem myself , the mistake was that i was not running it as adminstrator sudo mysql-workbench worked perfectly for me !



Only top voted, non community-wiki answers of a minimum length are eligible