LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 10-19-2003, 07:05 PM   #1
GuntherDW
LQ Newbie
 
Registered: Oct 2003
Distribution: Slackware 9.0
Posts: 11

Rep: Reputation: 0
mysql error?


Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /web/0ups/mysql_connect.php on line 3

and in the err file

031020 0:56:59 /usr/local/mysql/3.23.57/libexec/mysqld: Can't create/write to file '/home/mysql/data/GuntherDW.pid' (Errcode: 13)
031020 0:56:59 /usr/local/mysql/3.23.57/libexec/mysqld: Table 'mysql.host' doesn't exist
031020 0:56:59 /usr/local/mysql/3.23.57/libexec/mysqld: Error on delete of '/home/mysql/data/GuntherDW.pid' (Errcode: 2)
031020 00:56:59 mysqld ended

what is wrong? i did this lamp tut

lamps.efactory.de/e-lamps-2-0.shtml
 
Old 10-22-2003, 06:35 AM   #2
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
It looks like the permissions are not set right. The data directory has to have the user and group set to the mysql user, on redhat I just use:

chown mysql.mysql /usr/local/mysql/data -R

That is saying that the data directory for mysql is at /usr/local/mysql
 
  


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
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 04:28 PM

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

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