Can't connect to local MySQL server through socket
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
|