help me get started

[wblue]

OKAY, MYSQL is running as a service on my XP machine. Can someone tell me in plain english how to connect to it. If I see 'access denied' one more time, I just may have to scream.

 

[sleipnir214]

What are you using to connect to MySQL?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[wblue]

I'm trying to use a command line

 

[sleipnir214]

How are you invoking the command-line app? What command-line parameters are you using? What is the exact text of the error message?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[wblue]

I am using the admin acct in XP.
I am using the Windows command line interface (command.com)

'mysql is running as a service on the localhost.
If I type 'shell> mysql' I get 'access is denied'

 

[sleipnir214]

You're logged in as admin on the XP box. This will have nothing to do with MySQL permissions, as MySQL has its own independent permission system.

Again, I need to see the exact text of the error message, not a paraphrase.

On my MySQL installation if I don't use a password when I attempt to use the mysql app, I get an error like:

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

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[wblue]

'access is denied'
that's it- that's all...I'm not paraphrasing.
If I'm supposed to use a password, then what password?

The manual's tutorial gives this:
shell> mysql -h host -u user -p
Enter password: ********

so I've typed stuff like

shell> mysql -localhost -administrator

on the command line, and I always get 'access denied'
I'm not stupid and I want to learn this stuff, but how do I take the first step of accessing the server?
Maybe it's just my syntax, I just don't know....if I could just get some plain english instructions.

To a command line novice 'shell> mysql -h host -u user -p
Enter password: ********

is befuddling.

The fact that I get 'access denied' tells me I am at least knocking on a door and need to type the correct command.

 

[sleipnir214]

By default, MySQL's administrative user is "root", which unless you've changed it has no password.

So:

mysql -u root

should get you in.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Correction. That should have read:

mysql --user=root



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!