MySQL Forums
Forum List  »  Other Migration

Re: Grant Tables issues with Windows.
Posted by: Leo Gil
Date: August 06, 2004 03:13PM

Marcello,

You don't have the permissions configured on your database. The user from which you are executing the mysqlshow doesn't have the permissions to see the databases.
Try executing the mysqlshow using your root (or database owner) account, for example, mysqlshow -u <username> -p.

Also, the best configuration you could have would be that no user can execute any mysql commands unless they are part of a dba group.

This is what happens executing the command at on one of my servers (Sorry, I only have Solaris and Linux servers with mysql):

#/usr/local/mysql/bin/mysqlshow
/usr/local/mysql/bin/mysqlshow: Access denied for user: 'leo@localhost' (Using password: NO)

I don't have the privileges to access the database as leo

#/usr/local/mysql/bin/mysqlshow -u root -p
Enter password:
+---------------------+
| Databases |
+---------------------+
| global |
| team |
| mysql |
| test |
+---------------------+

Good luck

Leo

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Grant Tables issues with Windows.
2437
August 06, 2004 03:13PM


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.