MySQL Forums
Forum List  »  Router & Proxy

why i can not create other user use mysql-proxy
Posted by: h ch
Date: November 25, 2009 08:29PM

# mysql -uroot -p12345 -h172.16.1.111 -P4040
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.0.77-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant all on *.* to 'test1'@'172.16.1.111' identified by '12345';
ERROR 1045 (28000): Access denied for user 'root'@'172.16.1.111' (using password: YES)
mysql> show grants;
+------------------------------------------------------------------------------------------------+
| Grants for root@172.16.1.111 |
+------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.16.1.111' IDENTIFIED BY PASSWORD '2e782c85379a326e' |
+------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
why i can not create other user use mysql-proxy
4082
November 25, 2009 08:29PM


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.