List:General Discussion« Previous MessageNext Message »
From:Martin Mueller Date:November 15 2011 9:21pm
Subject:MySQL install on OS X Lion does not create root account
View as plain text  
I have been struggling with installing MySQL 5.5.17 on a Mac running OS
10.7. My machine had 5.5.15 on it.

I keep getting user denied access messages (Error 1045).   I thought at
first it was a matter of a password not being flushed from a previous
installation and went through repeated install and uninstall routines, using
the instructions by Rob Allen at
<about:blank> .

I also followed various instructions in the MySQL documentation for
resetting lost passwords. But the results persuaded me that the problem is
something else:  the installer does not create a root account or a mysql
account in the user table. Thus the update command for resetting the root
password executes correctly but update 0 rows. And logging in with the
skip-grants-table lets you address some queries to the mysql user table.

"Select count(user) from user" returns 0, as does "select user, password
from user." So it appears that the installation routine (from the disk
image) does not populate the user table with accounts from which you could
then perform other activities.

Does anybody have any idea what is going on here or what I could be doing


MySQL install on OS X Lion does not create root accountMartin Mueller15 Nov
  • Re: MySQL install on OS X Lion does not create root accountMichael Dykman15 Nov