MySQL Forums :: Newbie :: remote access and privilages


Advanced Search

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 Bucz Buczsky 01/19/2009 11:52AM
Re: remote access and privilages Chris Morgan 01/20/2009 12:48PM
Re: remote access and privilages Rick James 01/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.