Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 05-04-2005, 11:13 PM   #1
Registered: Sep 2004
Location: Colorado, USA
Distribution: CentOS 5
Posts: 144

Rep: Reputation: 15
mysql start problems

I just installed apache, php, and mysql using the following site:
but every time I try to start mysql I get this:

bash-3.00# mysqld_safe --user=mysql &
[1] 2518
bash-3.00# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/
050504 22:10:51  mysqld ended

[1]+  Done                    mysqld_safe --user=mysql
bash-3.00# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
Old 05-04-2005, 11:36 PM   #2
Registered: Oct 2003
Location: San Deigo, CA
Distribution: FC3, Win2k Server, XP Pro & 2003 Server
Posts: 198

Rep: Reputation: 30
sql must run as a service, make sure it has the correct permissions
Old 05-04-2005, 11:37 PM   #3
Registered: Sep 2004
Location: Colorado, USA
Distribution: CentOS 5
Posts: 144

Original Poster
Rep: Reputation: 15
how do I do that?
Old 05-05-2005, 01:20 AM   #4
Senior Member
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,508

Rep: Reputation: 100Reputation: 100
Do you have a source or binary MySQL package?

Here's how I installed and configured my MySQL (4.0.16):

1. Install according to BINARY_INSTALL.TXT
2. Do chown -R mysql.mysql /var/lib/mysql
3. Go to /var/run
4. mkdir mysqld
5. chown -R mysql.mysql mysqld
6. Start the server - mysqld_safe --user=mysql & in the /usr/local/mysql/bin/
7. Type in mysql -u root mysql
8. At mysql> prompt type
set password for root@localhost=password('arendia');


[root@StefanLinux rylan]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for root@localhost=password('password');

This assumes that you have a binary MySQL install.


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
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-07-2008 11:48 PM
mysql start problems. compu73rg33k Linux - Software 7 02-27-2005 08:49 PM
MySQL install and start problems tommytomato Fedora 4 09-07-2004 05:20 AM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 06:12 PM
MySQL server start up problems spectrumver1 Linux - Software 2 12-09-2003 07:56 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 07:33 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration