OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: mysql_client

From: Egor Egorov (egor.egorovensita.net)
Date: Fri Nov 14 2003 - 03:18:16 CST


Alaios <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

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
 / /|_/ / // /\ \/ /_/ / /__ Egor.Egorovensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
       <___/ www.mysql.com

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