Problem installing MySQL 5.0.2-alpha on Red Hat Enterprise ES V3
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:
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
+ Done /usr/local/mysql/bin/mysqld_safe
After that I try to run this command:
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! :)
OMG!! I have the same problem
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.:)
I finally got it working
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
This tells you some useful information about where you files are stored.
2) Check out your error log file
This is where mine is stored
If your error log is as big as mine was you may want to remove it by
It will be recreated once you restart MySQL
3 ) Make sure you've created the group and user
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
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
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
|All times are GMT -5. The time now is 06:46 PM.|