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 Rhinorhino 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
Joined
Jul 29, 2003
Messages
2
Location
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