MySQL configuration and management
Nov.10, 2008 in
Database
How to set up the MySQL root password?
In the MySQL command prompt space, execute: update user set Password=PASSWORD(’new-password’) where user=’root’;
Then: flush privileges;
Now, quit;
Try to log in: mysql
Oh! You can’t log in as done before. It is a normal situation. In order to log in again to the MySQL database server, excute:
mysql -u root -p
Then, enter [...]
