Page 1 of 1

Password for MySQL

Posted: Sun Sep 25, 2005 11:56 am
by spyderwoman
I am prompted for a root password upon my attempt to open mysql. I have not set a password and neither my windows password nor null work. where did this password come from and how do i find out what it is?
Thanks

Posted: Sun Sep 25, 2005 12:11 pm
by feyd
it is and was set during installation, normally. Since you haven't created any tables, you may be able to simple reinstall over the existing installation giving it a new password.. although you may need to do an uninstall and remove the data files it leaves afterward in it's database files folder..

Posted: Sun Sep 25, 2005 12:17 pm
by spyderwoman
Before I saw your post I created a password following these steps that I found on mysql.com, however i still cannot get in using the new password that I assigned:

Log on to your system as Administrator.

Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:

Start Menu -> Control Panel -> Administrative Tools -> Services

Then find the MySQL service in the list, and stop it.

If your server is not running as a service, you may need to use the Task Manager to force it to stop.

Create a text file and place the following command within it on a single line:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

Save the file with any name. For this example the file will be C:\mysql-init.txt.

Open a console window to get to the DOS command prompt:

Start Menu -> Run -> cmd

We are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly.

At the DOS command prompt, execute this command:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

The contents of the file named by the --init-file option are executed at server startup, changing the root password. After the server has started successfully, you should delete C:\mysql-init.txt.

Users of MySQL 4.1 and higher who install MySQL using the MySQL Installation Wizard may need to specify a --defaults-file option:

C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe
--defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
--init-file=C:\mysql-init.txt

The appropriate --defaults-file setting can be found using the Services Manager:

Start Menu -> Control Panel -> Administrative Tools -> Services

Find the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the --defaults-file setting.

Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use.

You should be able to connect using the new password.

Posted: Sun Sep 25, 2005 12:59 pm
by spyderwoman
I uninstalled and reinstalled mysql. I set the password and still received the same error that access was denied.

Posted: Sun Sep 25, 2005 1:16 pm
by feyd
did you delete the database folders? There are data files that are left behind by an uninstall