MySql Security Setting issue – Error 1045

Posted: October 28, 2010 in Uncategorized

When you installed mysql first time all goes well but if due to some reason you need to uninstall then install mysql agian follwoing problem always occure at configuring it

Processing configuration…

 

/ Prepare configuration

/ Write configuration file (c:\Program … \my.ini)

/ Start service

x Apply Security settings

 

the last step (Apply security setting) always get fail. I also had the same problem  and it took so much time to me to solve the issue. on the internet you found lots of solution

related to properly uninstalling mysql like

 

-Unintsall by Add/Remove program(In windows XP)

- delete Mysql folder in program Files(c:progme Files etc) directory

-remove entry from registry(regedit)

- remove entry from system configration (msconfig)

- check by (Alt+ctr+del), that my sql service is runnign uder proccess, if it is then stop it.

- better to restar your system(optional)

- Now reisntall  and configure it agian.

 

If this solution works then its greate, otherwise i have another solution for your problem

 

for the 2nd solution you have to dlelete  some enrty from mysql tables to congfiure mysql easily.

so follow it as following

 

1 -stop if mysql service running(offcourse its running after installation), use (Alt+ctr+del) to stop form procsess

or use it http://dev.mysql.com/doc/refman/5.1/en/windows-start-service.html

 

2 -Open command promt (in windows Menu>Start>Run>CMD )

“C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe” –skip-grant-tables

3 – Let this window open , open another command promt

Menu>Start>Run>CMD

“C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe” -u root

4 -Set new password for root user (or your user that given it another name)

 

You’re now connect to MySQL, you have to modified the root account in the date of MySQL

 

mysql> use mysql;

mysql> UPDATE user SET password=PASSWORD(‘motdepasse’) WHERE user=”root”;

mysql> flush privileges;

mysql> exit;

 

5- Restart with MySQL Commant Line Client (mean restart the mysql service).

 

Thats all you have to do!!!

 

Leave your comments, if this solution works for you (offcourse it will work, as it work in my case) :D

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s