Estou usando Mysql 5.1 com windows 7 …
Estou com esse erro abaixo :
Error Nr. 1045
Access denied for user ?root?@'localhost? (Using password: NO)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installations is still needed to connect to the server. In this case please select skin now and re-run the Configuration Wizard from the start menu.
E Encontrei na internet uma solução :
A solução:
-
pare o serviço do MySQL, se o mesmo estiver rodando
-
abra o prompt de comando (cmd)
-
execute o seguinte comando, sem fechar o cmd: mysqld --skip-grant-tables --user=root
Mai ao digitar a linha 3 me da o seguinte erro :
[Warning] 'default-character-set] is deprecated and wil be removed in a future release.Please use ‘–character-set-server’ instead.
Alguém pode me ajudar …
abs