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
Boa Marcelo, quem nunca instalou um banco MySql e não se ferrou por não lembrar mais a senha. 🙂
Valeu pelas dicas.
Abraço.
Tava precisando de algo parecido estes dias, só que era pra Postgres. Felizmente já resolvi (não posto a solução aqui pq tah em outra máquina).
Abraço
valeu 😉
Faço das palavras do Cristian as minhas!!
Faço das palavras suas e do Cristian as minhas
That’s an excellent nugget! I think resetting the root password of MySQL can be done automatically from the cPanel interface when you change the password of your hosting account.
Yes, but if you do a hands free installation you don’t have cPanel.
Feel free to visit regularly
you can recover it with the debian-sys-maint user
http://www.devmedia.com.br/forum/recuperar-senha-root-do-mysql-5-6-no-windows-server-2008-r2/455621