If you have lost the MySQL root password, or just don’t remember it, don’t worry, follow the step by step for you to retrieve it
- Stop the MySQL service if it is running “/etc/init.d/mysql stop”
- Up the Server “skiping” the layer responsible for checking the user privileges mysqld_safe-skip-grant-tables , remembering , when you start the server with this option, it will accept any user to connect to database MySQL database with full access to all the databases, then to inhibit other people from connecting to the server during the maintenance period, I suggest you use the following command to start the server mysqld_safe – skip-grant-tables – skip-networking. In this case the server not accept connections over TCP/IP
- Connect to server with the command mysql -u anything
- Enter update mysql.user set Password=PASSWORD(‘new-password’) WHERE User=’root’
- Stop the server whit the command mysqladmin -u qualquer_coisa shutdown and start again with without skiping commands mysqld_safe