I installed the MacOS X package, 'mysql-standard-4.0.18'. It seemed to be working. I started 'mysqld_safe'. Nothing happened but the prompt no longer appeared. As per the instructions, I hit control-z and it said the process was suspended, so I figured that was good. I then ran 'mysql' and it started a process which gave me prompts. I went in and out of that a few times.
But the documentation told me to assign a password to the root account. It told me to enter the following two lines.
/usr/local/mysql/bin/mysqladmin -u root password "newpwd" /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password "newpwd"
I entered the first one. Where it says "newpwd", I entered my desired password, but not within quotations. Still, it made no complaint.
I entered the second one (again using my desired password in place of "newpwd" but not using quotations), but it failed.
After that, nothing worked. I restarted, but now when I tried to start mysqld_safe it always immediately said that it ended.
Finally I used 'rm' to kill both mysql (the link) and 'mysql-standard-4.0.18-apple-darwin6.8-powerpc/' (the directory). I ran the installer. It would not offer to 'install', only to 'upgrade'. I told it to 'upgrade', which it did without complaint, but it made no difference.I restarted. No difference. Reinstalled. No difference.
I tried 'ps -U mysql'. Nothing was running.
I tried '/usr/local/mysql/bin/mysqld_safe --skip-grant-tables'. It says:
chown: mysql: Invalid argument Starting mysqld daemon with databases from /usr/local/mysql/data 040405 08:08:03 mysqld ended
I tried running 'sudo scripts/mysql_install_db' to reset the grant tables. That seemed to work fine. It just made no difference.
I even deleted and recreated the mysql user identity.
I found an old shell script by Marc Liyanage, called "remove-old-mysql.sh". It said it couldn't find the installation record so I reviewed it. It looks for a receipt in /Library/Receipts. I found a directory for mySQL there, so killed that. After that, the installer now was willing to 'install' as opposed to 'upgrade'. It installed the files just fine, but after that it said it was running a 'script', and shortly after that it said it failed. I restarted and tried again with the same result.
I had thought that the script it was supposed to run was the 'mysql_install_db' script which I had run without problem (or effect) as described above.
The installer has no 'uninstall'.
In short, my attempt to assign a password to the mysql root user broke it. Then I killed the directory, and finally the Receipt and even recreated the mysql user identity, but can't either reinstall or get it working.
Help!
-- Sincerely, Kevin Jaques (at home)
Use [EMAIL PROTECTED] for work related messages
"Send lawyers, guns and money! Dad get me out of this!" - Warren Zevon
