Koozali.org: home of the SME Server

More Mysql help...

Arkman

More Mysql help...
« on: November 11, 2001, 05:18:36 AM »
Hello,
 I'm having some problems with mysql on SME 5.0. Whenever I try and run mysql from the command line I get the following error:

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

 When I look at /var/log/mysqld.log I see:

 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist

 And then mysqld shutsdown. Not really sure where to go form here. Any help is greatly appreciated.

 Before I get flamed...I've searched through the forums already and I've noticed that other people have had this problem, but I don't see any info on how to fix it.

Thanks,

Arkman

Figured it out!
« Reply #1 on: November 11, 2001, 08:44:32 AM »
You know when it is late at night and you are frustrated and not thinking straight. Well?

I had erased the mysql access tables (on purpose), but when I went to run mysql_install_db to recreate the access tables I was logged in as root. Dumb! Logging n as root and then su mysql and recreate the access tables with mysql_install_db fixed the problem.

Now it's tme for bed.