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

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.

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

Probably the firewall on the server. Have you allowed traffic on prot 3306?

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)
Further you can look at http://dev.mysql.com/doc/refman/5.0/...ss-denied.html

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