Hi,

I bought Beginning MySQL, Beginning PHP5 and I'm eager to start building dynamic websites, but I can't get MySQL to work on my Fedora Core 4 system.

I get the following messages:

[root@c-280be253 bin]# mysqladmin versions
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@c-280be253 bin]#


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

[root@c-280be253 bin]# mysqld_safe &
[1] 21511
[root@c-280be253 bin]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050719 00:08:53 mysqld ended

My my.cnf look like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld]
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I can't locate the mysql.sock and I can't start mysql? What to do???

Regards
//Vito Salieri

Hi Vito,

(this is the second attempt at a reply)

I am also new to linux and MySQL, I say new I've been playing around with both for some time but not able to set aside enough time to make solid progress. I use Fedora Core 3 and MySQL 5.0.9 beta. However, one thing that occured to me that might be worth trying is the following.

From the applications menu select:

  System Settings>Server Settings>Services

You will need your root password to access this.

Then check to see if mysql is one of the available services, if so make sure the box is ticked, if not do so. Then try starting the service, quit. Then try accessing MySQL from the terminal again. You might also try by using:

  mysql -u root

This certainly worked for me. If however, you don't find the service mysql I suspect that it's not properly installed.

Good luck!

Jeremy

check that the file /var/lib/mysql/mysql.sock actually exists ... you should *see* it in the file system. also, if you downloaded and instaleld mysqld yourself it might be somewhere else, like /usr/local/var for example. If the file's there, try shutting down the server and if the file hangs around, rm it and restart the server. Also make sure that the user who mysql is running as has write permission to that directory.

If none of the above helps you, check out the message file ... probably /var/log/message, or /var/adm/message (i dont use fedora, but it's usually around there somewhere). mysqld is probably logging a more verbose/descriptive error message there..


Regards
Meredith Shaebanyan