Re: mysql_client
IN order to access a database say with a name data_db you have to grant permissions to a remote user by doing the following on the server 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]
Re: mysql_client
Alaios [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 This error is described at: http://www.mysql.com/doc/en/Access_denied.html What i msut do in order to gain access to the db? Hwo i can create users ? Is there any easy way for that? You should add entry to the 'user' table using GRANT statement: http://www.mysql.com/doc/en/GRANT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_client
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]