Access issues for MySQL database on OS X
Posted by: Martine Osias
Date: June 12, 2017 04:47PM

When I upgraded from OS X Mavericks to OS X Yosemite the MySQL user database seem to have been changed. I have now only one user administrator@localhost. This is the login Mac user. There is no root user in the database. If I do this query:

>SELECT current_user();

I get


So I am logged on to MySQL as blank. Blank has no privileges to create a root user or to grant privileges.

Given this, how do I re-create a root user in the database. I would have to give privileges to blank but cannot while logged on as blank. Alternatively, I should log on as administrator. But I did not create this user in the database and do not know the password.

The database folder has the data from before the migration. All I want to do is extract a file with the database content in the form of a query that I could load somewhere else.

Being able to re-create the root user would get me on the right path.

Thanks for your help. Point me to the right forum if necessary.

Options: ReplyQuote

Written By
Access issues for MySQL database on OS X
June 12, 2017 04:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.