List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:November 15 2011 9:26pm
Subject:Re: MySQL install on OS X Lion does not create root account
View as plain text  
You showed us a link which explains how you uninstalled MySQL.
Perhaps you could tell us how you installed it?  IT would certainly
shed some light on the subject.  If you are using a pre-built package
for OS/X, the issue is likely with the package.  If you are installing
from source, there is an initialization step you may have missed.

 - michael dykman

On Tue, Nov 15, 2011 at 4:21 PM, Martin Mueller
<martinmueller@stripped> wrote:
> 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
> wrong?

 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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