From: aman raheja (amanmysqlnetscape.net)
Date: Wed Nov 19 2003 - 11:26:16 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 root% 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

alaiosyahoo.com 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 rootkatapiesi
>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 ShopNetscape!
http://shopnow.netscape.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]