GRANT ALL ON data_db.* TO [EMAIL PROTECTED] identified by 'password'
Few things to remember.
- Not a good idea to give access to root from remote clients
- Other information about GRANT can be obtained by searching GRANT on mysql.com
HIH
Regards
Aman Raheja AGF Technologies http://www.agftech.com
[EMAIL PROTECTED] wrote:
Hi i have just installed the mysql_client and i am trying to remotely connect to the database of the other pc so i gave the following command mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED] mysqlshow: Host 'akroneiro' is not allowed to connect to this M
What i msut do in order to gain access to the db? Hwo i can create users ? Is there any easy way for that?
__________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree
--
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]