Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 01-18-2004, 10:37 PM   #1
Registered: Jul 2003
Location: dhaka
Distribution: Slackware 11 (fixed), MEPIS
Posts: 241

Rep: Reputation: 30
How to start mysql server

hello everyone
i need some help on how to start mysql server. everytime i start it (after i start apache of course), it shows a message : cannot open mysql socket, permission denied, have you already opened another mysql socket etc etc"... ... i cannot do it. i need some help from anybody out there. thanks
Old 01-19-2004, 02:58 AM   #2
Senior Member
Registered: Sep 2003
Location: Sweden
Distribution: Debian
Posts: 3,032

Rep: Reputation: 58
Check your /etc/init.d/ directory. You probably have a script called mysql or mysqld in there if you have the MySQL server installed. Just execute that script with "start" as argument: /etc/init.d/mysqld start

I am not familiar with the inner workings of Slackware but like other distributions it provides some sort of means to add the scripts in /etc/init.d/ to the different runlevels so it's started and stopped automatically.

Old 01-19-2004, 11:24 AM   #3
LQ Newbie
Registered: Feb 2003
Posts: 19

Rep: Reputation: 0
First of all you need to understand that:
1. MySQL doesn't rely on Apache to run
2. Only the superuser "root" has permission to start any daemon, so you need to log on your linux machine as root.
3. You need to konfigure MySQL after installation before you can start.

Try to locate MySQL files on your system (most probably in /bin) - or run something like this: find / -name mysql_install_db

Note the directory where mysql_install_db is located (the directory should contain most files needed to run mysql) for future use.

Now let's say the result is /bin/mysql_install_db
The next thing you should do, is to try finding out whether or not MySQL is running. Use this command: /bin/mysqladmin -u root -p ping
You'll be asked to enter password for root. Enter root password for Mysql if you've already created, else leave it blank and press return. You should get a message saying: "mysqld is alive".
If MySQL is not alive, and If you've not run mysql_install_db after the installtion, then run: /bin/mysql_install_db
This will configure MySQL by creating the basic database neede to start.

Now, try starting imysqld as mentioned above by Hakan or by running:
/bin/safe_mysql &

That should get mysqld running.

Go ahead and create a root password for mysql by running:
/bin/mysqladmin -u root -p password
Enter a new password for root

Note: Mysql root is not the superuser on your linux machine.

Enjoy MySQL



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 On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I start mysql server? barrythai SUSE / openSUSE 4 04-05-2006 06:46 PM
Trying to start Mysql server number11 Linux - Newbie 3 06-06-2005 02:59 PM
MySQL server doesn't want to start AJ_Cantos Linux - Software 7 11-29-2004 05:24 PM
Mysql server will not start using OS Suse 8.1 steverino Linux - Software 3 03-06-2003 04:00 AM
Proplems start MySQL server... Simon W Linux - General 1 03-09-2002 05:32 PM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 05:45 PM.

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