LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-20-2008, 09:13 PM   #1
pppaaarrrkkk
Member
 
Registered: Jun 2005
Location: Aylesbury UK
Distribution: Red Hat enterprise linux 6
Posts: 101

Rep: Reputation: 15
MySQL doesn't work


Hello Linuxquestions people.


I've got MySQL on Fedora 6. Doesn't work. (f**@~~### etc..etc..)

If I type

$ mysqladmin ping

it says :

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost qqq]#


Any ideas please ?
 
Old 02-20-2008, 09:21 PM   #2
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
Did you start mysql?

service mysqld start from the command line

If already started, does /var/lib/mysql/mysql.sock' exist?

Last edited by billymayday; 02-20-2008 at 09:22 PM.
 
Old 02-20-2008, 09:38 PM   #3
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,889

Rep: Reputation: 351Reputation: 351Reputation: 351Reputation: 351
Here is a quickstart guide to MySQL. Pass over the introduction, installation, and configuration to get to Getting Started. The information there may prove helpful. There is even a default root password that I didn't know about until I read this.
http://www.spikesource.com/docs/cs_1...tartguide.html
 
Old 02-20-2008, 11:09 PM   #4
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 671Reputation: 671Reputation: 671Reputation: 671Reputation: 671Reputation: 671
Older versions of mysql packages supplies the mysql manual. On the most recent, you need to download it yourself. Make sure to read the section about securing the database. You may want to drop a test table. Also change the root user settings.

On Fedora 6 you can probably use chkconfig to start the database the first time and set it up so that it starts automatically in runlevels 3 & 5 the next time you reboot.
 
Old 02-21-2008, 12:40 AM   #5
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
No - you still need to start the service as I said above. Chkconfig will start it on boot (ie you really need to do both - start for this session and chkconfig for future sessions)
 
  


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
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
Deleted the mysql db files from /var/lib/mysql and reinstalling doesn't work! Frostblade Linux - Software 1 05-24-2006 10:16 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 does not work karthic Linux - Enterprise 4 04-08-2005 05:21 PM


All times are GMT -5. The time now is 01:54 PM.

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