Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 10-13-2006, 12:48 PM   #1
Registered: Jul 2005
Location: Greece
Distribution: Mandrake 10.1 , Ubuntu 5.1
Posts: 59

Rep: Reputation: 15
Question Can't make MySQL start, strange message prompting

I have downloaded the latest MySQL version (mysql-standard-5.0.26-linux-i686.tar.gz) and tried to install it in a Mandrakelinux 10.1 PC.
I had the tarball decompressed in /usr/local/mysql and executed the following commands:

#scripts/mysql_install_db --user=billy
#bin/mysqld_safe --user=billy

Of which the second one prompted:

Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/
061013 20:12:42 mysqld ended

Although I changed the folder's owner from root to billy, here's what happened whenever I try to start MySQL:

# /usr/local/mysql/bin/mysqladmin start
This one prompts:

#/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
What do I have to do to start it?
Old 10-13-2006, 01:12 PM   #2
Registered: Dec 2005
Location: Edmonton
Distribution: BLFS, Gentoo
Posts: 353

Rep: Reputation: 32
Whats this user "billy" ? Did you create a new user "billy" to run mysql or are you trying to run it with your own account.

Normally, a seperate user and group should be created for mysql. The data folder and the folder where the logfiles/pid are stored must also be owned by this uname:groupname pair.

Locate where the mysqld.log file is (or whatever it is named in your case) and check the contents as, this will tell you what is ging wrong. Also, check the system log.


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
What is this Strange Error message? sbleecker Linux - Software 1 01-12-2006 01:00 AM
What is this Strange Error message? sbleecker Linux - Newbie 3 01-11-2006 10:17 AM
strange message kapa SUSE / openSUSE 1 03-10-2005 03:09 AM
Postfix, SASL with MySQL prompting for username and password acecomp Linux - Software 2 02-16-2005 02:04 PM
How To make MySql and Apache start at boot time? umeshz Red Hat 1 05-18-2004 01:00 PM > Forums > Linux Forums > Linux - Software

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