Sami Maisniemi writes:
>I think I am using root access, but should I create another user name for
>MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I
>view the user?
from the mysql program:
mysql> use mysql
mysql> select User,Host,Password,Select_priv from user;
which will show basic access capabilities for user/host/password
mysql select Host,Db,User,Table_Name,Table_priv from tables_priv;
will show similar information on a db/table basis for the host/user
combinations.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
