2

I, by mistake messed up with mysql's only user and the situation is I can't create new user or give more privileges to existing one. Access denied is the error. Only visible db is info Schema So I decided to remove mysql from my MAC and install it again. For removing completely(including config data) I tried this post.

After installing again, I see my configuration is the same. And I have the same user who can't do anything and the only database visible to him is info schema. mysql database is not visible either.

How can I completely remove configuration including user privilege data of mysql from MAC ? Command like sudo rm -rf /var/db/receipts/com.mysql.* I am new on MAC, is there any command like we have for linux sudo apt-get remove --purge mysql-server mysql-client mysql-common.

1 Answer 1

1

You do not need to purge anything, you just need to follow these instructions to reset the administrator password. If you happened to delete the admin user, just create a new one on the init file:

create user root@localhost;
grant all privileges on *.* to root@localhost;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.