Reset Mysql workbench root password
KKKK
I messed up something and I try creating a local server in the mysql workbench but an error message show up every time I test the connection.
I tried uninstalling the mysql workbench and installing again but the for user "root" is unknown. It did not tell anything about the root password during the installation process and I tried various password like empty string, my mac password etc but none of them works, I try researching in stackoverflow but I still cannot solve it.
Ankit Agrawal
For MAC user / OSX user
Try the command FLUSH PRIVILEGES when you log into the MySQL terminal. If that doesn't work, try the following set of commands while in the MySQL terminal
$ mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
Change out NEWPASSWORD with whatever password you want. Should be all set!
Update: As of MySQL 5.7, the password field has been renamed authentication_string. When changing the password, use the following query to change the password. All other commands remain the same:
mysql> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to get the count of particular values in a column using pandas
- Next: Page redirects when clicked anywhere in a <div>
Related
Related Related
- 1
Reset MySQL root password using ALTER USER statement after install on Mac
- 2
How to reset the forgotten MySQL root password?
- 3
How to reset mysql password
- 4
reset/change mysql root password
- 5
Strange type of password in mysql workbench
- 6
failed to reset root password for gitlab
- 7
Reset MySQL root password not working
- 8
How to reset password for root in arangodb?
- 9
Unable to reset MySQL root password, tried everthing
- 10
Unable to reset MySQL root password, tried everthing
- 11
WAMP - Reset Root password on mysql
- 12
unable to reset root password of mysql
- 13
Problem with mysql root password
- 14
MySql root password reset
- 15
Can't start MySQL to reset root password
- 16
Trying to reset forgotten MySql Root Password
- 17
Can't reset MySQL (MariaDB) root password
- 18
How do I reset my root password for MySQL on Mac OS X Yosemite?
- 19
How do I reset mysql's root password?
- 20
Change MySql root password
- 21
Strange type of password in mysql workbench
- 22
failed to reset root password for gitlab
- 23
setting a mysql root password
- 24
Is there a way to retrieve a root mysql password (no reset)
- 25
Reset Root Password for MySQL via Package Configuration
- 26
Reset MySQL root password not working
- 27
Reset root password for Ubuntu 16.04 - recovery mode asks for root password
- 28
Resetting MySQL root password
- 29
unable to reset mysql 'root' password
Comments