Access issues for MySQL database on OS X

[Martine Osias]

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

''@localhost

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.