[FIXED] Can't diagnose my MySQL root user problem

Issue

I have a problem with the MySQL root user in My MySQL setup, and I just can't for the life of me work out how to fix it. It seems that I have somehow messed up the root user, and my access to databases is now very erratic.

For reference, I'm using MAMP on OS X to provide the MySQL server. I'm not sure how much that matters though - I'd guess that whatever I've done will require a command-line fix to solve it.

I can start MySQL using MAMP as usual, and access databases using the 'standard' users I have created for my PHP apps. However, the root user, which I use in my MySQL GUI client, and also in phpMyAdmin, can only access the "information_schema" database, as well as two I have created manually, and presumably (and mistakenly) left permissions wide open for. My 15 or so other databases cannot be accessed my the root user. When I load up phpMyAdmin, the home screen says: "Create new database: No Privileges".

I certainly did at some stage change my root user's password using the MAMP dialog. But I don't remember if I did anything else which might have caused this problem. I've tried changing the password again, and there seems to be no change in the issue.

I've also tried resetting root password using the command line, including starting mysql manually with --skip-grant-tables then flushing privs, but again, nothing seems to fix the issue.

I've come to the end of my ideas, and would very much appreciate some step-by-step advice and diagnosis from one of the experts here!

Many thanks for your help.

Solution

Thats because MAMP and the command line mysql (and the mysql everything except MAMP) are different.

MAMP has its own built in mysql and you can't get to it via the command line, only the build in phpmyadmin.

this has been my experience, I have MAMP and use the other mysql for ruby on rails and other stuff.

Answered By - jerome stonebridge