MySQL Instal Errors

[hembeck]

Hey all,
I'm trying to install the .pkg version of MySQL as found on Marc Liyanage's site, following the instructions that he laid out, but I'm hitting a snag at step 7, where I type in "sudo ./bin/safe_mysqld --user=mysql &" I get the following:

[localhost:/usr/local/mysql] fernando% Starting mysqld daemon with databases from /usr/local/mysql/data
020821 18:15:23  mysqld ended

And that's it...I wait and wait and wait to see if something happens, but nothing does.

The only clue I know to offer is this error that is reported following step 2, "sudo ./scripts/mysql_install_db":

:Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1062  Duplicate entry 'localhost-root' for key 1
ERROR: 1062  Duplicate entry 'localhost-root' for key 1
020821 18:14:06  ./bin/mysqld: Shutdown Complete

I've removed the installation using Marc's removal script ad have also deleted the MySQL user. (I've done this 3 times already, always with the same results that I've noted above.)

Please, any help!!
-Fernando

[uoba]

Hmm, I'm no expert but it seems to me that it maybe something to do with the default user database that gets installed with MySQL (the database is called mysql and contains the data of allowable users within MySQL)... is seems to prepare the tables for this database but halt because of something to do with the root user @localhost... duplicate entry? At a guess, maybe the uninstall didn't completely eradicate all the previous data, so when the package tries to create the user information, it finds an unmoveable duplicate.

Again this is a guestimate, rather than an expert talking, but, you can try to see if that data exist by doing the following (non-harmful ):

In the terminal type:

cd /usr/local/
ls

Can you see a directory called mysql? If so, then do:

cd mysql
ls

Now, can you see a directory called data? If so, then you can also cd into there and that is where you would find the mysql database data.

If this is the case, you could try deleting the data with:



sudo rm -r mysql

... but again, I would wait for confirmation from someone other than me, to tell you if I am right or not (if I'm wrong then sorry to take up your time )

[hembeck]

Thanks just the same, uoba. At least you're giving me a lead. I've posted all throughout the known Mac OS X community, and no one has said peep. I don't know if it's because I'm an obvious newbie or this is a real queer problem.

Thanks again. I'll give your suggestion a try.

-Fernando

[hembeck]

Uoba,

I gave it a shot and the mysql directory is gone, so the uninstall worked. I was hopeful with you're post. Now I'm back to being perplexed.

I think I may try the compile the source for mysql, rather than using the pkg installer.

-Fernando

[mntamago]

I do not know if this will be of any help, but ...

I was using the MySQL package from Marc Liyanage's site before I install OS X 10.2. Everything was going along fine...until I install 10.2 yesterday.

As I looked around to see what was up I notice that 10.2 had removed my MySQL user account from the "Accounts" in my System Settings panel (sorry if the names are incorrect here, but I am using a Japanese Mac and everything is in Japanese). However, the MySQL user information was still in the "Netinfo Manager". Only, the home and shell had been set to /dev/null.

This is not what they originally where, so I reset them ...
home /Users/mysql
shell /bin/tcsh

After doing this I downloaded Marc Liyanage's mysql-3.23.51-jaguar.pkg.tar.gz, and followed his instructions.

Everything seems to be back in working order now. :-)


....BTW....while this is not MySQL trouble, my TOMCAT set up also need fixing thanks to 10.2!

[uoba]

Yep, same problem here at home on my iMac... thnx for the info mntamago

[uoba]

Ah, the ironey of it all, I now have the same problem as you hembeck on my iMac at home... I'm having a look now (mntmago's suggestion doesn't help for this problem)

[uoba]

Okay, you need to check you .err files to see what your particular problem is, to do this type:

cd /usr/local/mysql/data/


Here you should see the error files (usually your localhost address suffixed with the .err. Then type:

pico errorfilename.err


... replacing the errorfilename with the fil ename of course

What's yours say?