remote access and privilages
Hello,
I want to make my mysql database accessable remotely. I am logging in as
root@localhost
without password. I want to grant privilages to remote host, but I can't
mysql> select user, host, password from user;
+------------------+-----------+-------------------------------------------+
| user | host | password |
+------------------+-----------+-------------------------------------------+
| root | localhost | |
| debian-sys-maint | localhost | *ADFB2FCA979470BX074761BC8A2F635XXX |
+------------------+-----------+-------------------------------------------+
mysql> show grants;
+---------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' |
+---------------------------------------------------+
When I try to add privilages to a remote host, I get:
mysql> grant all on *.* to root@'202.19.193.%';
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
What's goung on?
Subject
Written By
Posted
remote access and privilages
January 19, 2009 11:52AM
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.