MySQL Forums
Forum List  »  Newbie

remote access and privilages
Posted by: Bucz Buczsky
Date: January 19, 2009 11:52AM

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?

Options: ReplyQuote


Subject
Written By
Posted
remote access and privilages
January 19, 2009 11:52AM
January 20, 2009 10:52PM


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.