Unable to open mysql database on Mysql Query Browser but i can login to same database with same credentials from command line Linux. Getting mysql error 1045 access denied.
Asked
Active
Viewed 1,663 times
0
-
use mySql workbench. Query Browser has been discontinued – Lelio Faieta Jan 05 '17 at 13:50
1 Answers
1
If you actually have set a root password and you've just lost/forgotten it:
- Stop MySQL
- Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables
Now, open a new terminal window and run the MySQL client:
mysql -u root
Reset the root password manually with this MySQL command:
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';If you are using MySQL 5.7 (check using mysql --version in the Terminal) then the command is:
UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root';
Flush the privileges with this MySQL command:
FLUSH PRIVILEGES;
From http://www.tech-faq.com/reset-mysql-password.shtml
(Maybe this isn't what you need, Abs, but I figure it could be useful for people stumbling across this question in the future) and here : [question]: https://stackoverflow.com/a/489502
Community
- 1
- 1
Shady Khalifa
- 177
- 4
- 7
-
Password is not the issue m entering correct password and i m also able to login via command line on linux. – Vivekrao Bhosale Jan 05 '17 at 14:01
-
check if you can reset your password , and can you kill process mysql and relaunch it again ! – Shady Khalifa Jan 05 '17 at 14:03