[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Min permissions to run `mysqladmin version`


At 16:33 -0800 12/9/05, Scott Haneda wrote:
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?

No permissions are necessary, you just need an account that has no privileges.
The account needs only to be able to connect to the server.

For example, either of these statements will create the account:

CREATE USER 'vuser'@'remote-host' IDENTIFIED BY 'vpass';

GRANT USAGE ON *.* TO 'vuser'@'remote-host' IDENTIFIED BY 'vpass';

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.