Hello.


> If I try to run mysqlshow, I see:

>

>   C:\Documents and Settings\Chris>mysqlshow sql

>   mysqlshow: Access denied for user 'ODBC'@'localhost' (using

password: NO)





ODBC is default username that is used on Windows. Create a new user

account and use it to connect to the MySQL server:

  http://dev.mysql.com/doc/mysql/en/Adding_users.html



If mysql command line client works, it is rather MySQL Keeper program.

Check if you have specified the correct connection parameters for it.







[EMAIL PROTECTED] wrote:

> I've just installed MySQL v5.0.15 on my 'Windows XP system and most ways

> I want to connect to it fail. I don't see what I'm doing wrong. I've

> searched the manual, the web, and the forums without seeing anything

> that clearly addressed my problem. Help, please!

> 

> If I navigate through Programs / MySQL / MySQL Server v5.0 / MySQL

> Command Line Client, I'm prompted for a password and when I enter the

> password, I am connected and can work fine.

> 

> If I try to run mysqlshow, I see:

> 

>   C:\Documents and Settings\Chris>mysqlshow sql

>   mysqlshow: Access denied for user 'ODBC'@'localhost' (using password: NO)

> 

> If I run the command interpreter (cmd) and type "mysql -uroot -pmypwd",

> it works now but I swear it didn't 10 minutes ago. Arg.

> 

> My real problem is that I've used MySQLKeeper with MySQL v4 and have

> backups created with it that I want to restore into MySQL v5.0 and when

> I try to connect with MySQLKeeper, I get:

> 

>   CONNECT

>   Result: Connection error

> 

> Now, it may be that MySQL Keeper is trying to connect via ODBC and

> that's why it's failing but I didn't think that's how it connected, it's

> an MySQL-specific tool, why would it use ODBC? And shouldn't mysqlshow

> work "out of the box"? How could I have installed MySQL to screw up

> mysqlshow?

> 

> Thanks for any pointers.

> 

>                                                 Chris

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to