[Jansar]

I cannot use mysql, because of the following error message "Can't connect to local MySQL server through socket '/tmp/mysql.sock'" and for some reason I know no way to remedy that. Would anyone know how to get around this? Thanks.

I use Mac OS X Server 10.2.3

[bluedog]

That error is likely because the mysql server isn't actually running.

It seems like the application to 'start' mysql with OSXServer needs some tweaking of its settings to get started.

If I remember correctly, the tables may not be properly populated. You can find the log file to give you a clue as to what is happening.

Open Terminal and look at your log files. It is located in /var/mysql

Then look for the file named with an ending '.err'

Type 'tail [filename].err" and it should list the last 10 lines of the log for you to see. Perhaps this can get you started in the right direction.

If you get an error like the following, it is likely your tables and permissions are not set for the database:

"/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)"


Good luck.

[kymikai]

try running /usr/local/bin/safe_mysqld, that did it for me.

[bluedog]

Originally posted by kymikai:
try running /usr/local/bin/safe_mysqld, that did it for me.

That will work "UNTIL RESTART" when the mysql daemon won't be restarted after the computer is turned off and back on again.

It seems like the OSX Server installation of mysql isn't as elegant as the filesharing and other features of installed applications.