LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 01-23-2008, 09:37 AM   #1
juancha
LQ Newbie
 
Registered: Feb 2006
Posts: 17

Rep: Reputation: 0
Cannot access mySQL


Hi

I'm very much a beginner but very keen to learn as much as I can about running a Linux based web server....so much so I'm renting out my own vps and trying to teach myself.

I know that php is already installed but I've come up against my first obstacle with accessing mySQL. At the command line I type in mysql -u etc etc. and I get the following error message.

"can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)"

Can someone please tell me what this means and what the cause and remedy is. (could it be that mySQL is not installed..here is the help page for setting up php and mySQL provided by the company I rent the vps from http://www.memset.com/support/index.php?page=PHP, I mention it on the off chance it may provide info that's specific to this server.

Please bear in mind I'm a beginner so if any answers are in simple terms.....ie. please be gentle with me ;-)
 
Old 01-23-2008, 09:46 AM   #2
philwynk
Member
 
Registered: Sep 2007
Posts: 84

Rep: Reputation: 15
I ran into something similar when I first installed mysql. It turns out you really need TWO packages to make mysql run, mysql-client and mysql-server. I suspect you only have mysql-client.

Logged in as root, try "yum install mysql-server" and see if that doesn't improve things.
 
Old 01-23-2008, 10:04 AM   #3
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 670Reputation: 670Reputation: 670Reputation: 670Reputation: 670Reputation: 670
You may also get that message if the mysql server is installed but not running.
 
  


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 - can't access mysql database as root yogaboy Linux - Software 5 12-28-2006 07:58 AM
How access MySQL by MySQL Administrator? treotan Linux - Newbie 5 12-04-2004 11:17 PM
Access to Mysql munna_502 Linux - Software 2 04-20-2004 04:51 PM
from access to mysql ? abd_bela Programming 1 02-12-2004 08:57 AM
mysql and access mychl Programming 2 06-11-2003 07:00 PM


All times are GMT -5. The time now is 09:26 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