mysql on workstation

LoneWolf69 · 10-31-2011, 08:44 PM

I have a new machine and want to start using mysql. I try to connect and cannot get in. I have not logged in yet so I am trying to reset the password in a terminal with...
sudo /etc/init.d/mysql reset-password

and it returns...
sudo: /etc/init.d/mysql: command not found

What is wrong here?

Thank you in advance.

Keith

bryan641 · 10-31-2011, 09:54 PM

Keith,

The "mysql" in /etc/init.d is used to start the mysql daemon (and stop, reload and report the status of), not reset your password (or enter mysql commands or anything else).

Is the mysql daemon running?
Try '/etc/init.d/mysql status" to see.

If you need to reset your root mysql password, you'll need to stop the daemon, then run it stand-alone and issue an update command to reset the password. Instructions are here (assuming you've got mysql 5).

--Bryan

linuxwin2 · 11-01-2011, 03:29 AM

What's your distribution Fedora, ubuntu ...?
If you haven't /etc/init.d/mysql you must install mysql-server.

bryan641 · 11-03-2011, 06:28 PM

Quote:

Originally Posted by linuxwin2

What's your distribution Fedora, ubuntu ...?
If you haven't /etc/init.d/mysql you must install mysql-server.