LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 04-29-2008, 08:42 AM   #1
JimOrJoe
LQ Newbie
 
Registered: Dec 2007
Posts: 24

Rep: Reputation: 15
mysql server does not start properly


Hi, Gurus:
I ran "mysqld_safe &" to start mysql server on linux, however mysql did
not start up properly and this is the infomation I got from the console:
"nohup: ignoring input and redirecting stderr to stdout"
"starting mysql daemon with databases from /usr/local/mysql/data"
Then it went stuck.
Could anyone please tell my why and help out?
Thanks in advance
JimOrJoe

Last edited by JimOrJoe; 04-29-2008 at 08:43 AM.
 
Old 04-29-2008, 11:29 AM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
How do you mean stuck ?

My experience:
If you manually start it, it looks stuck but pressing <enter> will get you back to the command line.

You can always check if it's running using the ps command in another console.

PS: From my memory, the lines that are displayed sound right.
 
Old 04-29-2008, 08:38 PM   #3
JimOrJoe
LQ Newbie
 
Registered: Dec 2007
Posts: 24

Original Poster
Rep: Reputation: 15
Wim Sturkenboom :

Thanks for replying. I followed your advice and realized how dum my question was.
I tried to hit the enter key and used ps -e to check all the running processes.
The results are exactly as you described.

However I had a further difficulty:
The client end of myslq server is on a window os, when i tried to connect to the
server using the linux machine's ip address and port
number 3306, an error message pops:

cannot connect to specified instance
mysql error number 2003
Cannot connect to MYSQL server on '192.168.1.102' (10065)

Do you know why this is happening? I have newly installed the
mysql server and not created a db instance yet. I only intended
to login and create one. How could the error message prompt me
that "cannot connect to the specified instance"?

Thanks
JimOrJoe

Last edited by JimOrJoe; 04-29-2008 at 08:41 PM.
 
Old 04-29-2008, 08:46 PM   #4
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
Probably the firewall on the server. Have you allowed traffic on prot 3306?

Last edited by billymayday; 04-29-2008 at 09:01 PM.
 
Old 04-30-2008, 12:43 AM   #5
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
I would indeed check the possible firewall issues at both the Windows site and the Linux site. Easiest to check is by first trying to connect on the server itself with the command below (I assume the mysql client is installed on the Linux machine)
Code:
mysql -u root
Further you can look at http://dev.mysql.com/doc/refman/5.0/...ss-denied.html
 
Old 04-30-2008, 11:28 AM   #6
JimOrJoe
LQ Newbie
 
Registered: Dec 2007
Posts: 24

Original Poster
Rep: Reputation: 15
BillMayDay & Wim Sturkenboom:
Thanks for your help, I checked the firewall of my linux server, and
added 3306 to the allowed port list and tried to login, bang it worked like magic.
Thanks and Cheers a lot
JimOrJoe

Last edited by JimOrJoe; 04-30-2008 at 11:31 AM.
 
  


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
can't start mysql server vito_huang Linux - Server 1 03-10-2007 08:36 AM
mysql server does not start up prasanta Linux - Newbie 2 01-05-2006 02:07 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
How to start properly MySQL in SuSE 8.1? wvelasquez Linux - Software 1 01-07-2003 06:34 PM

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

All times are GMT -5. The time now is 12:53 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration