LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 01-18-2004, 09:37 PM   #1
krussell
Member
 
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, 01:58 AM   #2
hw-tph
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.

Håkan
 
Old 01-19-2004, 10:24 AM   #3
Mimicafe
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

Mimi
 
  


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 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 05:46 PM
Trying to start Mysql server number11 Linux - Newbie 3 06-06-2005 01:59 PM
MySQL server doesn't want to start AJ_Cantos Linux - Software 7 11-29-2004 04:24 PM
Mysql server will not start using OS Suse 8.1 steverino Linux - Software 3 03-06-2003 03:00 AM
Proplems start MySQL server... Simon W Linux - General 1 03-09-2002 04:32 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

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