LinuxQuestions.org
Review your favorite Linux distribution.
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 11-20-2002, 05:25 PM   #1
Fenix
LQ Newbie
 
Registered: Nov 2002
Distribution: Redhat 8.0
Posts: 6

Rep: Reputation: 0
Clean Redhat 8.0 install, starting MySQL


ok, i just switched my dual AMD 1.6ghz server over to Redhat 8.0 from XP. I got apache and php working, but i cant seem to get MySQL working. I get this error:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

i chekced and that file isint there, any ideas where it is? any help would be great.

Thanks,
Kevin
 
Old 11-20-2002, 06:05 PM   #2
pagal
Member
 
Registered: Oct 2002
Distribution: Red Hat Phoebe!
Posts: 92

Rep: Reputation: 15
did you install the mysql during install?
if you did, have you made sure that the service is running?
 
Old 11-20-2002, 06:57 PM   #3
Fenix
LQ Newbie
 
Registered: Nov 2002
Distribution: Redhat 8.0
Posts: 6

Original Poster
Rep: Reputation: 0
Quote:
Originally posted by pagal
did you install the mysql during install?
if you did, have you made sure that the service is running?
yea i did a full install, all 4gb of it. i can run commands on mysql, like login and crap, but after it is done asking for the password and tries to connect i get that error.
 
Old 11-20-2002, 07:24 PM   #4
Fenix
LQ Newbie
 
Registered: Nov 2002
Distribution: Redhat 8.0
Posts: 6

Original Poster
Rep: Reputation: 0
starting to think running mysql for windows w/ wine would be easier...
 
Old 11-20-2002, 08:54 PM   #5
Fenix
LQ Newbie
 
Registered: Nov 2002
Distribution: Redhat 8.0
Posts: 6

Original Poster
Rep: Reputation: 0
Quote:
Originally posted by Fenix
starting to think running mysql for windows w/ wine would be easier...
can't get that to work either, lol.
 
Old 11-21-2002, 05:59 AM   #6
Cheechy
LQ Newbie
 
Registered: Nov 2002
Posts: 1

Rep: Reputation: 0
try typing mysqld -uroot then type mysql .. that's what works for me.
 
Old 11-26-2002, 01:46 AM   #7
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Rep: Reputation: 15
i have the same problem..
somehow when i do phpInfo()
i found out that the php does not include mysql..
 
Old 11-26-2002, 08:28 AM   #8
ccool
Member
 
Registered: Oct 2002
Location: Canada
Distribution: Slackware 10.1
Posts: 71

Rep: Reputation: 15
did you check if your mysql.sock is in /tmp ... sometimes it's there...

try "locate mysql.sock"

if it's there, there is an option that you can set while you do mysqld xxxx /var/mysql.sock

try the help or the man page to know how to specified the socket file...

it should work, or at least, give you a good hing
 
Old 11-30-2002, 02:14 AM   #9
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Rep: Reputation: 15
Have you fix it yet?
I got attack by cinik worm now..
i am thinking to upgrade the server to redhat 8 but i need the http server with mysql to work!

Last edited by vcheah; 02-17-2003 at 12:48 AM.
 
Old 11-30-2002, 02:36 PM   #10
skunkah
LQ Newbie
 
Registered: Nov 2002
Location: Amsterdam
Distribution: Redhat 8
Posts: 3

Rep: Reputation: 0
I have got the same problem. As soon as Redhat 8 came out I downloaded and installed it on one of my servers. I couldn't connect from any other host then localhost/localmachine to the mysql server .. using mysql client from shell is working (only when using root/trusted connection).
I've posted the problem on the forum of the biggest Dutch tech site with more then 75.000 registered members. It seemed that a lot of other people had the same problem as me and you.

I've not been workin on the problem a lot of time I have just down grade the server ... but trying again right now.
Isn't this a known bug?
 
Old 11-30-2002, 06:03 PM   #11
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Rep: Reputation: 15
One of the solution i know could be done is not installing the httpd server and mysql ... and then do a separate installation.
But this will make a lot of problem.. I did a search on the redhat they specificly telling redhat user that the httpd server is patch with postgresql . but .. i though mysql is better then postgresql.


So how?
 
Old 12-01-2002, 12:18 AM   #12
skunkah
LQ Newbie
 
Registered: Nov 2002
Location: Amsterdam
Distribution: Redhat 8
Posts: 3

Rep: Reputation: 0
I've added a 'host permission' to mysql or let's call it a trusted host for the client machine where I was/am connecting from.
And you know what happend .. acccess was granted.
So I think that there is actually a bug in the MySQL that was coming with RedHat 8 distro
 
Old 12-01-2002, 12:42 AM   #13
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Rep: Reputation: 15
can u explain more clear on that?
i dont get what you mean
 
Old 12-01-2002, 03:43 AM   #14
skunkah
LQ Newbie
 
Registered: Nov 2002
Location: Amsterdam
Distribution: Redhat 8
Posts: 3

Rep: Reputation: 0
Ok again ..
I've inserted a new record/row into the table 'host' in the 'mysql' database. This table defines the permissions you have when you connecting from specified host.
 
Old 12-01-2002, 08:45 AM   #15
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Rep: Reputation: 15
so that will be
INSERT INTO host SET('%' ,'%','Y','Y','Y','N','N','N','N','N','N')
 
  


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 starting mysql, new install Robin01 Linux - Newbie 6 08-29-2005 06:12 PM
Starting MySQL on fresh Slack install subnet_rx Slackware 7 06-26-2004 04:44 PM
Redhat Linux 9 does not boot after clean install MustardMan Red Hat 6 03-16-2004 05:04 PM
Mysql 4.0 No Longer Starting on RedHat 9 BaenSidhe Linux - Software 8 12-18-2003 11:12 PM
Redhat 8 or 9 clean install SB live never works Alinuxnoob Linux - General 1 09-09-2003 01:14 AM


All times are GMT -5. The time now is 07:27 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration