Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)

[Linda Ruiz]

Here's what I found, the post is entitled:
Re: Server Instance Configuration Wizard problem
The url is:
http://forums.mysql.com/read.php?11,58696,70362

I didn't do everything he suggested, as I couldn't get the MySQLInstanceConfig to do anything but produce the dreaded error 1045. I run ZOneAlarm so here is what I did.

1. Did not uninstall Mysql (5.0.21 installed).
2. Ran MySQLConfiguration, let it produce error 1045.
3a. Zone Alarm prompted me. I chose Allow and remember for both mysqld-nt and the MySQLConfig.
3b. Opened up ZoneAlarm client, made sure those two programs (mysqld-nt.exe and for MYSQLINSTANCECONFIG) were set to allow (checked) for all four trusted/internet - access/server.
4. Clicked retry. Let error 1045 appear again, left the MySQLConfig window open.
5. Flipped to explorer, navigated to mysql directory and opened my.ini to edit it.
6. Added these lines at the bottom (following [mysqld] section).
# from http://forums.mysql.com/read.php?11,58696,70362
max_allowed_packet = 1M
skip-grant-tables
# table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
Saved my changes.
7. Opened another command prompt window:
8. Issued these two commands:
net stop mysql
net start mysql
9. Flipped back to MySQLConfig, clicked Retry, it worked.
10. Flipped back to ZOneAlarm client, changed MYSQLINSTANCECONFIG to remove checks from Internet for Access/Server.
11. Ran mysql -u root -p mysql
12. Ran the fixit script with full path:
\. c:\mypath\mysql5.0\scripts\mysql_fix_privilege_tables.sql
ignored the error messages.

Hope that helps,
Linda :)



Edited 1 time(s). Last edit at 05/15/2006 09:09PM by Linda Ruiz.