LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
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 03-20-2003, 09:40 PM   #1
jasoncngo
LQ Newbie
 
Registered: Mar 2003
Location: Melbourne, Australia
Distribution: Red Hat 8.0
Posts: 6

Rep: Reputation: 0
Unhappy help! MySql installation error


error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'

Hi guys/gals,

I need help with my installation of MySQL and php. I have installed MySql using tar.

i tried to run mysql server by typying [root@JERSER]# mysqladmin create mrbs

i am trying to create a database but I get this error message

[root@JERSER]# error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'

I have searched for hours. I want a simple solution. I bet it something I havent done correctly.
 
Old 03-20-2003, 10:47 PM   #2
born4linux
Senior Member
 
Registered: Sep 2002
Location: Philippines
Distribution: Slackware, RHEL&variants, AIX, SuSE
Posts: 1,127

Rep: Reputation: 49
run this as root:

/sbin/service mysqld status

if it is not running, run:

/sbin/service mysqld start

Then, to make it run when ur system starts:

/sbin/chkconfig --level 345 mysqld on

'man chkconfig' for details.
 
Old 03-23-2003, 07:10 PM   #3
jasoncngo
LQ Newbie
 
Registered: Mar 2003
Location: Melbourne, Australia
Distribution: Red Hat 8.0
Posts: 6

Original Poster
Rep: Reputation: 0
thanks

Thanks for your help it worked

Now I got to this error Error 1045: Acess denied for user 'root@localhost' (Using password: YES)

I has to enter the password to start the MySql server ?

How do I do this ?

thanks man
 
Old 03-24-2003, 05:57 AM   #4
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,591

Rep: Reputation: 145Reputation: 145
usually u have to be root to start the server but no password.
/path/2/mysql/bin/safe_mysqld -u root &

to login to mysql client:
/path/2/mysql/bin/mysql -u root -p
this will ask u for a password if u have already set that
if u dont have a pssswd yet leave the -p option out
but u should set a passwd for root in the long run
cheers, jens

Last edited by j-ray; 03-24-2003 at 05:59 AM.
 
  


Reply



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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 02:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
mysql installation error (make install error) jolly_good2000 Linux - Software 1 11-14-2002 04:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:41 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
Open Source Consulting | Domain Registration