Problem with MySQL after Fedora LAMP Install

[nate]

After upgrading to VPS 3, I chose the Fedora LAMP install, after the installation everything looks good, except when I try to run MySQL in any way, I get:

[root@rudedwarf mysql]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

And when I go to /var/lib/mysql/ there isnt anything there....

You can check out my phpinfo file here, if that helps:

www.eternalheroes.org/info.php

Thanks for any help you can give!

[pablasso]

i don't know about those default installations but maybe it just didn't created the mysql table, try to start it with '/etc/init.d/mysql start' and then follow the instructions when it complains

[freevps]

what shows in your mysql error log?

tail -f /var/lib/mysql/.... .er ??

[nate]

Originally Posted by freevps

what shows in your mysql error log?

tail -f /var/lib/mysql/.... .er ??

the folder is empty...there is no log file there

[nate]

Originally Posted by pablasso

i don't know about those default installations but maybe it just didn't created the mysql table, try to start it with '/etc/init.d/mysql start' and then follow the instructions when it complains

awesome, i got it:

[root@rudedwarf init.d]# ./mysqld start

that did it!

thanks guys for the help, much appreciated

[jasonaward]

Try the following:

---------------------
# DEBUG=10
# export DEBUG
# /etc/init.d/mysql start
---------------------

Post back the response if what it gives you isn't obvious.

[jasonaward]

Originally Posted by nate

[root@rudedwarf init.d]# ./mysqld start

mysqld instead of mysql within the /etc/init.d directory? Hmm. Something seems odd about that. Oh well, as long as it works.

[andrew@vpslink]

I think that the Fedora LAMP install doesn't have mysql turned on by default. You can check this by typing chkconfig --list on the command line. Look for the line that lists mysql to see if its turned on. If you want to have it turn on automatically you can enter chkconfig --level <level> mysqld on. Substituting <level> with the appropriate runlevel for your server.

[factorial]

This would have been helpful info for me - I just got Fedora LAMP installed on my OpenVZ server, and I get the same message OP got - but chkconfig does not exist.

[The Universes]

Originally Posted by factorial

This would have been helpful info for me - I just got Fedora LAMP installed on my OpenVZ server, and I get the same message OP got - but chkconfig does not exist.

Are you logged in as root?
Try using the full path: /sbin/chkconfig

Otherwise install it with yum

yum install chkconfig