I need help with server, I hope this is the correct place to post...

Markorak · #1 02-10-2006, 05:13 PM

Ok, I am creating a server, and I have looked all around the fourms, and cannot locate any information on how to fix this... I have looked at a few guides and found one that I was interested in and when I got to a certain point, I stopped. When I tried to get back in, I get an error.

This is right after the c:\mysql\bin> mysql -u root mysql, this is what it says:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

If anyone can help me that would be great. As I said in the title, I hope that this is in the correct place.

wize_one · #2 02-10-2006, 05:15 PM

mysql -u root -p

and use the password you chose durring mysql setup

Markorak · #3 02-10-2006, 05:40 PM

I never chose one.... Like, with the winmysqladmin? or?

And how would I even place it into mysql?
like

mysq -u root mysql -p? idk

I am a noob with stuff like this, better at other computer things with like programming and such just not command prompt commands

wize_one · #4 02-10-2006, 07:27 PM

when you installed mysql(or started winmysqladmin) it asked for a password.

mysql -u root -p<enter>
it will prompt for password

sesmar · #5 02-11-2006, 05:11 AM

If you did not enter a password for the root account or you are not sure if you did or not you can always just try:

mysql -u root <enter>

If you do not have a root password this will log you into the server as the root user.

Markorak · #6 02-11-2006, 05:50 AM

I get errors for both of them...

hmmm

C:\mysql\bin>mysql -u root mysql -p<enter>
The syntax of the command is incorrect.
C:\mysql\bin>mysql -u root <enter>
The syntax of the command is incorrect.

Markorak · #7 02-11-2006, 05:52 AM

Wait, I figured it out...
all I have to do is:

c:\mysql\bin> mysql -u root -p...

that is the correct syntax... Thanks anyways for all of your guy's help.