MySQL Forums
Forum List  »  Install & Repo

default user
Posted by: Carlo Prestopino
Date: October 27, 2004 08:05AM

I all,
I've just installed Mysql on a WinXPprof SP2 machine and I have a problem with the default user with mysql client.

Once the server is started and I try to connect to it, the user used by the client is "@localhost". In fact, I'm experiencing the following behaviour:

With the command C:\mysql\bin>mysqlshow I can see only the database "Test"
and if I give the command C:\mysql\bin>mysqlshow mysql , the reply is "Access denied for user: "@localhost" to database "mysql"

With the command C:\mysql\bin>mysqlshow -u root I can see the databases "test" and "mysql" and the "mysqlshow mysql" command works properly.

As a result I have to specify each time that I'm the root...

Anybody can help?
Thanks

Options: ReplyQuote


Subject
Written By
Posted
default user
October 27, 2004 08:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.