View Single Post
  #5   (View Single Post)  
Old 9th December 2008
Mantazz Mantazz is offline
Shell Scout
 
Join Date: Oct 2008
Posts: 90
Default

Quote:
Originally Posted by phoenix View Post
If this is a fresh install, you may also have to initialise the internal database and tables. The rc.d script is supposed to do this automatically, but sometimes it doesn't. Try running the following:
# /usr/local/bin/mysql_install_db
And then running the rc.d script.

If that doesn't work, check /var/log/messages and the mysql logs in /var/db/mysql.

I ran the mysql_install_db command, and it ran without incident. I then tried to start mysql and it did nothing in particular. "mysqladmin ping" still returns the error
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
/var/log/messages is useless for mysql, at least this installation of it. /var/db/mysql has a log file that appears almost hopeless.

Would it be at all useful to try uninstalling and reinstalling through ports, or do I have to muck through this by hand? It seems like there could be multiple missing things that are important to mysql, as the following lines from the /var/db/mysql log file indicate:
Code:
081209 12:09:03 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081209 12:09:03 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
081209 12:08:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
081209 12:04:22 [ERROR] Can't start server : Bind on unix socket: Address already in use
081209 12:04:22 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
Reply With Quote