Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New to MySQL - using 5.0.11 beta to learn

Status
Not open for further replies.

gbl

MIS
Sep 6, 2001
262
CA
Hi,
I've just started using MYSQL so these questions are rather basic but important.
I have only one computer to test this on. Is it possible to have a client on the same computer as the server (Kind of like MS SQL server)?
I installed MySQL when logged on to my computer (which is running Windows 2000 server) as the local administrator. I went into a command prompt and entered the following command:

mysqlshow (within the bin subdirectory)

and received this message

MYSQLSHOW:Access denied for user 'ODBC'@' localhost' <using password: NO>

So the big question is can I access the server on the same machine on which it is installed, and if so, what do I have to do? create new users? Any help is appreciated. Thank you.
 
ODBC is the default user for MySQL running on windows.
In order to use a client program you should specify a user (and a password, if the user has one). for example:

mysqlshow --user=root

use mysqlshow --help for more information
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top