Active3 years, 9 months ago
I've just installed MySQL through MySQL Package Installer. After the installation, this message:
- However, if you have set the password for root and forget or unable to recall the password, then you will need to reset the root password for MySQL. MySQL Reference Manual has detail steps on how to reset password for root which are as below.
- Aug 10, 2009 Laura wrote: 'These forums must be pretty useless if nobody has posted an answer in over four years.' But I found a solution that worked for me at.
How Do I Reset My Root Password on MySQL on a Mac? Ask Question 3. Here is the procedure to reset password of root user. 1) Stop mysql (Kill mysql process or run following command). MySQL Post-Installation on a Mac OSX Snow Leopard. Using Plesk to setup MySQL.
Then I've tried to log using Sequel Pro to127.0.0.1 / root / #<;Ay.
and this is the result:
and this is the result from MySQL WorkBench
So I've tried
1)
2)
3)
4)
5)
Nuñito de la Calzada
Nuñito de la CalzadaNuñito de la Calzada1,70718 gold badges81 silver badges160 bronze badges
2 Answers
Nuñito de la CalzadaNuñito de la CalzadaMysql Password Reset
1,70718 gold badges81 silver badges160 bronze badges
Mysql Reference Manual Reset Password Mac Pro
Find out which user the mysql server is running as using ps au | grep mysqld
. sudo
to said user and run update user set password=PASSWORD('NEW_PASSWORD_HERE') where User=user()
. Hope that helps.
Mysql Reference Manual Reset Password Machine
hd126k3 gold badges59 silver badges71 bronze badges