Home Forums OS X Server and Client Discussion Questions and Answers How do I activate mySQL on Mac OSX Server 10.2.2

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #354773
    Stompor
    Participant

    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

    #354774
    Cabbage
    Participant

    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.

    #354849
    didde
    Participant

    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.

    #354853
    legacyb4
    Participant

    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]

    #354854
    legacyb4
    Participant

    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.

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

Comments are closed