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, [...]