AFP548 Changing the world one server at a time.

How do I activate mySQL on Mac OSX Server 10.2.2

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
  • November 15, 2002 at 5:49 pm #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

    November 15, 2002 at 11:19 pm #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.

    December 8, 2002 at 8:34 pm #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.

    December 9, 2002 at 11:04 pm #354853
    legacyb4
    Participant

    Had the same problem.

    Saw:

    • 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

    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.

    didde wrote:

    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.

    December 10, 2002 at 3:07 am #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.

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