I just purchased the [u]Beginning MySQL</u> book. As per usual with these type of things, I'm struggling to get through the installation portion of the book due to the normal unforeseen circumstance that prevents me from getting past chapter 1.
I have downloaded both the client and server versions of MySQL, copied them to my /tmp directory (in Linux), and even during installation it gave me a message stating that it could not run the server program.
When I attempt to run it, this is what I get:
[root@localhost tmp]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
In the "Testing your Linux Installation" portion of the chapter that you are directed to after installation, you are asked to run this command.
When I do this I get pretty much the same response:
[root@localhost tmp]# /usr/bin/mysqladmin version
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Any help would be greatly appreciated. I'm am still pretty new to Linux which doesn't help, but as for now it's all I've got to work with.