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,

I'm also new to linux and MySQL. I say new I've been playing with both few quite some time never able to get down to solid work due to various things like life etc. I use Fedora Core 3 and MySQL 5.0.9 beta, and the thing that occured to me is that you might have a quick look at whether or not your system has started MySQL, try the following.

From the Applications menu select:

  System Settings> Server Settings> Services

You need your root password to access this.

Then look to see if mysql is one of the available services, make sure the box is ticked, if it is not do so and then also try starting the service, exit from Service Configuration. Then give it another go, you never know it might help it certainly worked for me.

You might also try the following to start:

  mysql -u root

Good luck!

Jeremy

I'm still getting an error when I'm using:

-bash-2.05b$ mysql -u root

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

-bash-2.05b$


Please a little help. Thanks.

I bet mysql isn't running does the following bring anything back?
You can start mysql by doing as root (on most linux distros):
Look out for any errors and try the ps ax again - you should see mysql chugging along. if not you probably have a config problem. You'll need to locate a file called my.cnf (most likely in /etc/mysql or somewhere). As root do:

This could take a while. Post your my.cnf and someone will probably be able to figure out any config errors.

Cheers,
Charlie

--
Don't Stand on your head - you'll get footprints in your hair
                                           http://charlieharvey.org.uk
                                              http://charlieharvey.com