LinuxQuestions.org
Help answer threads with 0 replies.
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 08-03-2006, 04:11 AM   #1
Niceman2005
Member
 
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330

Rep: Reputation: 30
mysql cannot start...........


Dear friends,

I have installed MySQL
MySQL-client-standard-4.1.14-0.rhel4.i386.rpm
MySQL-devel-standard-4.1.14-0.rhel4.i386.rpm
MySQL-server-standard-4.1.14-0.rhel4.i386.rpm
MySQL-shared-standard-4.1.14-0.rhel4.i386.rpm

but i don't know why everytime i start mysql is says
"MySQL Pid could not be found!
MySQL start failed


If i use the default mysql 3.23 it works ok to start, but if i install the MySQL above it doesn't work....always come out with this error.
I have tried everything,format everything and do over again.
There is now MySql pid file in /var/lib/mysql....

actually i have asked this question long time ago but couldnt find the answer to solve the problem....has anyone got any new encounter to solve it?..pls help me...i am really stuck..

thanks for taking time reading my thread..

Regards
Y
 
Old 08-03-2006, 05:06 AM   #2
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
Did you start the mysql server? (mysqld, mysql_safe, etc)?
"mysql" only starts the client. It will need a running server to work.
The PID file contains the process ID of the running MySql server, probably. So, no PID file means no running server in most cases.
 
Old 08-04-2006, 08:05 PM   #3
Niceman2005
Member
 
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330

Original Poster
Rep: Reputation: 30
Hi Timmeke,

thanks for your reply.
I found mysqld in /usr/sbin but when i attempt to start it, it gives me, I still can't start mysql service.

I tried the following commands:
1) /usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/sy_shipping1.shinyang.com.my.pid
060805 09:01:49 mysqld ended


And the error file doesn't say much, simply as below:
060805 08:49:31 mysqld started
060805 08:49:31 mysqld ended

060805 08:53:39 mysqld started
060805 08:53:39 mysqld ended

060805 08:55:24 mysqld started
060805 08:55:24 mysqld ended

060805 08:57:39 mysqld started
060805 08:57:39 mysqld ended

If i do service mysql restart, it still give me the same error:
service mysql restart
MySQL PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

there is still no mysql.sock file in /var/lib/mysql, i have got mysql user and group created, changed permission for mysql folder to be owned by mysql user and group.

I have searched through mysql forum, a few people faced the same problem but the thread ended where it started.

.....any more help..? pls help...thanks for taking time reading my cries...

Regards
Y
 
Old 08-04-2006, 08:24 PM   #4
isuck@linux
Member
 
Registered: Jun 2006
Distribution: messed up debian
Posts: 250

Rep: Reputation: 30
maybe you need to check in what folder mysql is writing the pid and make sure the mysql user can write to that folder.
 
Old 08-05-2006, 09:03 AM   #5
Niceman2005
Member
 
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330

Original Poster
Rep: Reputation: 30
hi friends,

finally i have got it working...i don't know what exactly i did to make it work.

I think is one of these:
- I followed the instruction here: http://www.vias.org/linux-knowhow/lnag_09_06.html, i think after i did that i have got the mysql.sock file created in /var/lib/mysql folder.
I am not exactly sure if it was the /usr/bin/mysql_install_db command that created the mysql.sock file, but anyway, after i got that mysql.sock file in there, things were great.
I tried to start it, initially it has a problem, i checked the error file, it was about the innode table thingi, once i clear that error, it starts ok.

Maybe it was because i didn't create mysql user...thats why i couldn't start...but ia m not sure the exact problem. so if anyone have the same problem, maybe you can try the website stated above. the instruction might help. hopefully...

thanks for helping guys!

Regards
Y
 
Old 08-05-2006, 10:39 AM   #6
isuck@linux
Member
 
Registered: Jun 2006
Distribution: messed up debian
Posts: 250

Rep: Reputation: 30
Just make sure that you secure your server of that is already secured if you are not behind a firewall, while the server is running port 3306 is opened to connections.
 
Old 08-06-2006, 08:51 PM   #7
Niceman2005
Member
 
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330

Original Poster
Rep: Reputation: 30
All right. thanks friend!
 
  


Reply


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
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
I can't start Mysql angelfire Red Hat 3 07-27-2006 10:55 PM
MySQL - Timeout error occurred trying to start MySQL Daemon. stuartornum Linux - Software 3 02-26-2006 12:54 PM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 06:12 PM
start mysql Eddie9 Linux - General 3 06-06-2002 08:00 AM

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

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