Forum Moderators: travelin cat
details...using Jaguar. Downloaded and installed MySQL 4.0.1 from MySQL (per the instructions on [url]www.entropy.ch[/url]. ).
...btw, I've done the removal and install about 3 times now....
When I cd to /usr/local/mysql and sudo ./bin/mysqld_safe & I get:
[1] 1802
[Marks-Computer:/usr/local/mysql] mark% touch: /Users/mark/mysql/data/Marks-Computer.local..err: No such file or directory
chown: /Users/mark/mysql/data/Marks-Computer.local..err: No such file or directory
Starting mysqld daemon with databases from /Users/mark/mysql/data
./bin/mysqld_safe: /Users/mark/mysql/data/Marks-Computer.local..err: No such file or directory
./bin/mysqld_safe: /Users/mark/mysql/data/Marks-Computer.local..err: No such file or directory
tee: /Users/mark/mysql/data/Marks-Computer.local..err: No such file or directory
030813 15:14:07 mysqld ended
tee: /Users/mark/mysql/data/Marks-Computer.local..err: No such file or directory
-------------------------
Unfortunately, I am unable to access the /data directory because I get "Permission denied". So, I can't check the .err log file.
Any suggestions are appreciated.
The data should be created within the /usr/local/mysql tree since, afaik, since jaguar has a user "mysql" created by default. After installing the bin package you should cd into the mysql dir and create the data dir - use this commands to do this:
#first run the uninstall script#
#then install the bin mysql package again - then:#
cd /usr/local/mysql
sudo chown -R mysql data/
You should be prompted to type the admin password!
If you run the uninstall script DO NOT stop it. It may take a while to delete all mysql related files; be patient! Also, if you installed the startup package for mysql, you might want to check if mysql is running when you run the uninstall script. MySQL should not run, when you uninstall!
I can't think of any other reasons than the above described that could cause problems. I installed the entrophy version more than seven times now under Jaguar at different machines and it allways worked at the first try.
I have had good luck with Server Logistics' installer. I don't know if the one you have been trying to install will conflict with the install of theirs, but if you uninstall the old one, I would assume it would be okay.
http*://www.serverlogistics.com/mysql.php
If you have admin privileges, I think this should work, but I don't have a Mac w/MySQL in front of my at the moment:
cd /usr/local/mysql
sudo cat ./data/*.err
(enter your administrator PW when prompted)
You could also change the permissions on the directory, but that's more likely to cause headaches down the road.
cd /usr/local/mysql
sudo ls ./data
(Read the name of your logfile)
sudo tail ./data/[Your-Computer-Name].local..err
