MySQL

[jcrangel]

Ola pessoal!! graça e paz a todos...

eu baixei o mysql no site mysql.com e instalei na minha maquina... no final da instalação o programa me pediu pra configurar uma instancia do mysql, configurei o fui notificado de que a configuração tinha sido efetuada com sucesso... porém ao tentar me conectar à instancia apareceu o seguinte erro:

error 1045

Access denied for user root@localhost

já tentei desabilitar o firewall do sistema operacional, já tentei alterar os niveis de segurança, estou logado com permissao de administrador do sistema...

não sei o que se passa..

alguem poderia me ajudar??

[RoBiN]

Provavelmente você está errando a senha ou está sem permissões... tente resetar a senha de root:

To Reset the Root Password:

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

Find the MySQL service in the list, stop it

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

Start Menu -> Run -> cmd

Assuming you installed MySQL to C:\mysql. If not make adjustments accordingly.

C:\> C:\mysql\bin\mysqld-nt --skip-grant-tables

This starts the server in a special mode that does not check the grant tables to control access.

Keeping the first console window open, open a second window

Execute the following

C:\> C:\mysql\bin\mysqladmin -u root
flush-privileges password "ENTERNEWPASSWORD"
C:\> C:\mysql\bin\mysqladmin -root -p shutdown

The second command will prompt you to enter the new password for access. Enter the password that you assigned in the first command.

Stop the MySQL server, then restart it in the 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 whateer command you normally use.

You should now be able to connect using the new password.

http://www.mysqlfreaks.com/errors/55.php