Greetings,
This is how the entry looks like in the mysql.user table. So basically,
root has all the global privileges.
============
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+------------------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| myhost.edu | root | 443dfb6b3a231d1e | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
Y |
+------------------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.00 sec)
==========
I did the following grant as user 'root' and got the error:
mysql> grant all on *.* to 'someuser'@"%" identified by 'secret';
ERROR 1045 (00000): Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Any idea what I did wrong?
Bing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
