From: Michael Dykman Date: November 15 2011 9:26pm Subject: Re: MySQL install on OS X Lion does not create root account List-Archive: http://lists.mysql.com/mysql/226312 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 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). =A0 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, us= ing > the instructions by Rob Allen at > (http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/) > . > > I also followed various instructions in the MySQL documentation for > resetting lost passwords. But the results persuaded me that the problem i= s > something else: =A0the installer does not create a root account or a mysq= l > 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 coul= d > then perform other activities. > > Does anybody have any idea what is going on here or what I could be doing > wrong? > > > > > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.