PDA

View Full Version : Stupid problems with MySQL




brap
May 30, 2005, 02:39 PM
Right, so finally getting around to doing some dev work after exam silly season, and since Tiger was a fresh install for me, I need to reinstall MySQL. It's been fine in the past, but now I seem to have broken the intstaller somehow.

After running the latest darwin 7.9 build (MySQL 4.1) installer, the prefpane reports "Server running" all the time. Except it's not. So, I gave mysql user write privileges to /tmp/, and voila! mysqld starts.

Except it's not really. To start, mysqld performs tests to ensure it has write access to /usr/local/[..]/data - but when I run mysql_secure_installation, I get:
touch: .my.cnf.5739: Permission denied
touch: .mysql.5739: Permission denied
chmod: .my.cnf.5739: No such file or directory
chmod: .mysql.5739: No such file or directory. Therefore, I assume I have no write permissions to wherever it's putting those temp files.

Except I do. It's very confusing.

I've tried rm -rf [mysql folder]
rm /tmp/mysql.sockand reinstalling, but the same problems keep coming back.

Are these the only files I need to get rid of, or am I missing something? Yes, I have tried the entropy.ch uninstall shell script, to no avail...



superbovine
Jun 2, 2005, 11:12 PM
Right, so finally getting around to doing some dev work after exam silly season, and since Tiger was a fresh install for me, I need to reinstall MySQL. It's been fine in the past, but now I seem to have broken the intstaller somehow.

After running the latest darwin 7.9 build (MySQL 4.1) installer, the prefpane reports "Server running" all the time. Except it's not. So, I gave mysql user write privileges to /tmp/, and voila! mysqld starts.

Except it's not really. To start, mysqld performs tests to ensure it has write access to /usr/local/[..]/data - but when I run mysql_secure_installation, I get:
touch: .my.cnf.5739: Permission denied
touch: .mysql.5739: Permission denied
chmod: .my.cnf.5739: No such file or directory
chmod: .mysql.5739: No such file or directory. Therefore, I assume I have no write permissions to wherever it's putting those temp files.

Except I do. It's very confusing.

I've tried rm -rf [mysql folder]
rm /tmp/mysql.sockand reinstalling, but the same problems keep coming back.

Are these the only files I need to get rid of, or am I missing something? Yes, I have tried the entropy.ch uninstall shell script, to no avail...

are you starting mysql with a 'sudo'?

brap
Jun 3, 2005, 12:48 AM
are you starting mysql with a 'sudo'?
I got it fixed, and yeah, a sudo was involved... heh. I never did a sudo mysql_secure_installation though, rather doing all the legwork from the mysql commandline :o
A hell of a lot of other messing around, too. Sigh. At least it's fixed, and was a crash-refresher course in the bowels of mysql.