Hey everybody,

I'm trying to install MySQL 5.0.2-alpha on my Red Hat Enterprise Verison 3 machine. Once I downloaded my source files I ran ./configure , then make and then make install with no errors.

My problem is:

When I try to run the following command:

/usr/local/mysql/bin/mysqld_safe &

I get the following:

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050218 13:43:47 mysqld ended


[1]+ Done /usr/local/mysql/bin/mysqld_safe



After that I try to run this command:

/usr/local/mysql/bin//mysqladmin version

and get the following:

/usr/local/mysql/bin//mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


I do not have a /tmp/mysql.sock file.

I also do not have a /usr/local/mysql/var directory either.

Does anyone have any ideas?

Thanks in advance for your help!

Hello ETSUSnake,

I have EXACTLY the same problem... Unfortunately i am still in search of a solution.

Since no one else has posted on this thread I assume you are still looking for a solution yourself.

If you find one before I do, can you email me chris 'at' gateway.net.au

Likewise if i find the solution in the meantime i will be sure to post it here.

Cheers and good luck.

Just going to let you know I finally got MySQL working on my server.

My problem was with permissions and I didn't have my configuration file right.

Here are some things to look at:

1) Check out your configuration file

cat /etc/my.conf

This tells you some useful information about where you files are stored.

2) Check out your error log file

cat /var/log/mysqld.log

This is where mine is stored

If your error log is as big as mine was you may want to remove it by

rm /var/log/mysqld.log

It will be recreated once you restart MySQL

3 ) Make sure you've created the group and user

groupadd mysql
useradd -g mysql mysql


4) Make sure that you've set the right permissions

chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var (See Note on this one)
chown -R mysql /usr/local/mysql

Note:

This was one of my problems that I was having.
My MySQL var directory was in my /var/ so I did used
chown -R mysql /var/

5) Check and make sure that MySQL is running

ps -a

if it is then go ahead and kill it by using

kill -9 (enter the PID Number from the above command)

do another ps -a to see if there is any MySQL things running. You can also just reboot the box if you want to so that you know that MySQL will not be running.



6) Finally start MySQL

/usr/local/mysql/bin/mysqld_safe --user=mysql &

then make sure it's working by checking the version information

/usr/local/mysql/bin/mysqladmin version