Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mysqld problems

Status
Not open for further replies.

Pintonite

Programmer
Jul 29, 2003
2
US
This is what I am getting

------------------------------------------------------------------------
154-229-58-66:/var/lib/mysql # mysqladmin shutdown -u root -p
Enter password:
154-229-58-66:/var/lib/mysql # mysqladmin ping -u root -p
Enter password:
mysqld is alive
--------------------------------------------------------------------

how can it still be alive after I told it to shut down?


I am also getting this

----------------------------------------------------------------------
154-229-58-66:/var/lib/mysql # mysqld
030729 14:18:54 Can't start server: Bind on TCP/IP port: Address already in use
030729 14:18:54 Do you already have another mysqld server running on port: 3306 ?
030729 14:18:54 Aborting

030729 14:18:54 mysqld: Shutdown Complete
-------------------------------------------------------------------------

How can I shut it down when I can't shut it down. I'm also trying to use PHP to access mysql and it's giving me this error

--------------------------------------------------------------------------
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/me/ on line 7
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
-------------------------------------------------------------------------

I checked /tmp for mysql.sock and it is in there but at 0 bytes. It is also in /var/lib/mysql/ directory at 0 bytes. Any suggestions????? this is really frustrating.

Thanks in advance for any help
 
Nevermind,
I fixed it. I just made a symbolic link from /var/fdsaf/mysql.sock to /tmp/mysql.sock. obviously removing the one in /tmp first. although I'm still a little wierded at the fact that I can't shut down mysqld.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top