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!

safe_mysqld --user=mysql &

Status
Not open for further replies.

WillieHier

IS-IT--Management
Nov 4, 2003
4
DE
hi,
i found in my /etc/init.d/boot.local the safe_mysqld --user=mysql & entry. I asume that the user mysql in the /etc/passwd is used to start the database. But when i want to shutdown the database with the command mysqladmin --shutdown i've got the error message mysqladmin connect to server at 'localhost' failed error: 'access denied for user: 'root@localhost' (using password=NO)'. The user mysql has no shell so i cant login with that user account. What am i doing wrong to shutdown the database and how is the start procedure. I was changing the passwd for mysql but i dont know if it starts at this moment.
Thanks
 
mysqladmin uses the same permissions tables as mysql the client.
I suspect your error message is referring to the mysql root user and password not your unix/linux root user - try

mysqladmin -u root -p shutdown

this will prompt for the mysql root users password
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top