Re: How to grant access from a remote client ?

[Cliff Bryant]

I too, am having a similar problem. Please see the listing below.


[cbryant@nc02 ~]$ mysql -u admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1136 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW GRANTS;
+-------------------------------------------------------------------------------------+
| Grants for admin@localhost |
+-------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD '42' |
| GRANT ALL PRIVILEGES ON `mysql`.* TO 'admin'@'localhost' WITH GRANT OPTION |
+-------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SHOW DATABASES;
+--------------+
| Database |
+--------------+
| carpool |
| mysql |
| sesame_store |
+--------------+
4 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
mysql> GRANT ALL PRIVILEGES ON waveset.* TO 'admin'@'localhost' WITH GRANT OPTION;
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'waveset'
mysql> CREATE DATABASE waveset;
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'waveset'