How do I activate mySQL on Mac OSX Server 10.2.2

[Stompor]

I am having problems trying to install phpMyAdmin per the article
https://www.afp548.com/Articles/Jaguar/phpmyadmin.html

When I type in mysql -uroot in the terminal I get
ERROR 2002: Can’t connect to local MySQL through socket ‘/tmp/mysql.sock’

What do I need to do?
Thanks for helping a unix newbe

[Cabbage]

I’m having the same problem!
MySQL Manager worked fine on a G4 I setup on Wed. I just got an XServe today and MySQL Manager isn’t working. I’m getting the .sock error also. I got the same thing in 10.1.X.

[didde]

Sounds like you don’t have the permissions set correctly for MySQL.

Try chowning /var/mysql/* and /var/mysql/mysql/ (I think) to the user mysql..

That should fix it. If not, the err log in /var/mysql is usually pretty good at telling you what went wrong.

Good luck.

[legacyb4]

Had the same problem.

Saw:
[list:64c3f067b7]
021210 08:00:38 mysqld started
021210 8:00:38 /usr/libexec/mysqld: Table ‘mysql.host’ doesn’t exist
021210 08:00:38 mysqld ended
[/list:u:64c3f067b7]
in the log but haven’t had time to getting around to fixing it yet.

Strange that the “Install” button didn’t completely install everything needed!

Cheers.

[quote:64c3f067b7=”didde”]Sounds like you don’t have the permissions set correctly for MySQL.

Try chowning /var/mysql/* and /var/mysql/mysql/ (I think) to the user mysql..

That should fix it. If not, the err log in /var/mysql is usually pretty good at telling you what went wrong.

Good luck.[/quote:64c3f067b7]

[legacyb4]

MySQL is suddently working for me after checking and following a few of the tips I saw on Apple Discussions.

What did it for me:

– Making sure your machine hostname is matching a proper DNS entry in /etc/hostconfig (will require a reboot if you have to change it).

– Adding the machine’s domain name into the Optional Search Domain field under Networking.

– Running “sudo chown -R mysql /var/mysql *”

– Running “sudo safe_mysqld” (shoudl really use the full start server with mysql user, but this was a quick and dirty to make sure the server started)

Once I was able to get the MySQL server up and running, using the MySQL manager app seemed to work for starting and stopping the server.

A bit convoluted and I really wish Apple did make it as simple as a single-click.

Good luck.

[Author]

Posts