Cannot start MySQL. Please help..

[redfroc]

Hi..

I have configure Apache and PHP successfully.
Then I try to configure MySQL. I have install it as Windows service and run it.
But when I type 'mysql' it says 'Access denied for user ODBC@localhost'.
Where exactly should I fix it?

Thank you so much for help.

Best regards.

[ConnorB]

Not enough information.

[guelphdad]

yes it is enough information. It is telling you that you don't have access for that user.

are you starting from a command prompt/shell? or are you using a GUI to start mysql?

Did you create a regular user when you installed mysql or only the root user? you should create a user and not rely on the root user. to test if the root user can connect, by default you only need to name the root user but no password.

[redfroc]

I install and run it from command prompt only, not by any GUI.

These are commands I have done:

- mysqld-nt --console
- mysqladmin -u root shutdown
- mysqld-nt --install
- net start mysql

then when I type 'mysql' it says the error message.
what is command I should use to make it clear?

Thank you very much.

[guelphdad]

you can have mysql start as a service if that would be easier for you (I personally find that it is).

when you get to the point that you need to connect to the mysql client, instead of doing this:

mysql

do this:

mysql -uroot

and of course it would help if you answered whether or not you installed a regular user and whether or not you included a password for your root user.

[redfroc]

Yes, I run mysql -uroot and success. Thank you..
I've attached the error message when I type mysql.

What is command to add user so I don't need to add -uroot parameter?

Thank you..

[guelphdad]

GRANT syntax from the manual.

[CFMaBiSmAd]

If you are using Windows, I seriously recommend that you obtain the Windows Essentials .msi version of mysql to install and configure the instance of the mysql server. Also, the mysql administrator (part of the GUI tool box) should be used to create users and databases.

[redfroc]

All right. I'll try to.
Thank you so much for all of helps.

I realy realy appreciate it.
Thank you..

Best regards.