Sample Header Ad - 728x90

Recover lost MySQL password

0 votes
1 answer
663 views
I hate to ask a stupid question like forgetting the password, but this one is really hard to get back. Tried all the methods I can find online, and none is working. Even deleting the database requires my password, which means if I don't get my password back somehow, or reset, I am basically done with using it for my life. I am using Mac OS 10.10.2 Here is what i have tried: Tried to stop it first, using a script from the oracle site: kill cat /mysql-data-directory/host_name.pid ...getting no such directory error. I terminated MySQL manually from system preferences, and did the following: Everyone is saying to use: mysqld_safe --skip-grant-tables ...but it is not working here. No mysqld_safe command even exists when I punched it into cmd. Then I digged into the directory files, and used: sudo ./usr/local/mysql/bin/mysqld_safe --skip-grant-tables & After i did, it still asked for my password! Then I tried to remove sudo: ./usr/local/mysql/bin mysqld_safe --skip-grant-tables it becomes: fan$ ./mysqld_safe --skip-grant-tables ./mysqld_safe: line 522: /usr/local/mysql/data/mysqld_safe.pid: Permission denied awk: i/o error occurred while closing /dev/stdout input record number 8, file source line number 1 160204 00:21:13 mysqld_safe Logging to '/usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err'. touch: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err: Permission denied chmod: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err: Permission denied 160204 00:21:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data ./mysqld_safe: line 130: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err: Permission denied rm: /tmp/mysql.sock: Permission denied rm: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.pid: Permission denied rm: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.pid.shutdown: Permission denied Please help to save my life with this mess! I really really don't understand why Oracle wants to give me a so sophisticated password in the beginning instead of asking me to set one! I jotted down the password it gave me, which was a combination (&*,AaFz0). I have updated my termination procedures, and it is not working at all. I have used http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html to try to solve the problem. I am getting the same thing,the big chunk of nonsense above. Here is what I got: /usr/local/mysql/data/mysqld_safe.pid: Permission denied awk: i/o error occurred while closing /dev/stdout input record number 1, file source line number 1 160204 01:11:50 mysqld_safe Logging to '/usr/local/mysql/data/Fans-MacBook-Pro.local.err'. touch: /usr/local/mysql/data/Fans-MacBook-Pro.local.err: Permission denied
Asked by user3431800
Feb 4, 2016, 05:24 AM
Last activity: Feb 4, 2016, 12:52 PM