up vote 1 down vote favorite
share [g+] share [fb]

i am using Linux Red Hat 5.

I have installed zend server and mysql server.

I am trying to change default mysql port to another. Let's say 512, but mysql server cannot restarted again.

It prompted me with the error message below: Starting MySQL...The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).

Please help me to solve this.

Thanks.

link|improve this question
try delete the pid file. – xdazz Feb 1 at 8:50
i have tried to delete it and restart mysql again. and i have got the same error message. – user1182245 Feb 1 at 9:23
feedback

migrated from stackoverflow.com Feb 1 at 13:46

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 1 down vote

You say that you are trying to change the MySQL port from 3306 to 512. If that is correct, then then problem is that all *nix (Linux, Solaris, AIX, etc) require you to run as root in order to bind to ports below 1024.

Try running it on port 3307 or something.

link|improve this answer
I have logined as root account. I have changed the port to 1433, then restart linux. I am still got the error Starting MySQL...The server quit without updating PID file (/var/lib/mysql/localhost.MySQL.pid). – user1182245 Feb 2 at 2:33
Please post your my.cnf. Is there anything else in the error log? – Aaron Brown Feb 2 at 14:10
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.