LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 02-18-2005, 01:52 PM   #1
ETSUSnake
LQ Newbie
 
Registered: Feb 2005
Location: Virginia
Distribution: Red Hat Enterprise ES Lnux Version 3
Posts: 15

Rep: Reputation: 0
Exclamation Problem installing MySQL 5.0.2-alpha on Red Hat Enterprise ES V3


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!
 
Old 03-08-2005, 12:20 AM   #2
equinoxblue
LQ Newbie
 
Registered: Mar 2005
Posts: 1

Rep: Reputation: 0
OMG!! I have the same problem

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.
 
Old 03-08-2005, 11:24 AM   #3
ETSUSnake
LQ Newbie
 
Registered: Feb 2005
Location: Virginia
Distribution: Red Hat Enterprise ES Lnux Version 3
Posts: 15

Original Poster
Rep: Reputation: 0
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

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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Installing Red Hat Enterprise 4 yogeshsr11 Linux - Newbie 4 06-27-2005 04:36 PM
installing MySQL on a remote Red Hat 9 Machine. shelldinesh Linux - Software 0 10-06-2004 01:01 PM
Installing DB2 v.7.2 on Red Hat Enterprise Linux 3 agentjfp Linux - Software 2 06-04-2004 06:26 AM
installing red hat enterprise 2.1AS db001 Linux - Newbie 1 05-13-2004 07:52 PM
Anyone have Winamp3 Alpha working on RED HAT 7.2?? skoal Linux - General 4 12-10-2001 08:13 PM


All times are GMT -5. The time now is 11:54 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration