Dear Ganesh,
if you can connect to the MySQL server with mysql, you can create new
users with the GRANT command.
> Is it possible for me to access a database on a remote machine by
giving
> the IP address of the remote machine as the host???
For such a user, a GRANT statement would look like this:
GRANT ALL ON *.* TO "remote_user"@"ip_of_machine_that_connects"
IDENTIFIED BY "some_password"
This will grant all privileges on all databases and tables. The connect
will go via TCP/IP, so it's not all too safe, and you may want to
restrict access rights like this:
GRANT select,insert,update ON some_db.* TO ... (like above)
This will grant access only to all tables in some_db, and only select,
insert and update statements will be allowed.
For a local user (i. e. client and server are on the same machine) the
connect will typically be via Unix domain socket or Windows NT named
pipe, which is pretty safe. A typical grant statement would go like
this:
GRANT ALL ON *.* to "local_user"@"localhost" IDENTIFIED BY
"some_password"
Check the manual for details: http://www.mysql.com/doc/G/R/GRANT.html
Hope it helps.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Ganesh Krishnan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 8:45 AM
Subject: Accessing the MySQL on a remote machine!!
> Hi,
> Is it possible for me to access a database on a remote machine by
giving
> the IP address of the remote machine as the host??? If it possible,
can I
> access a database of the root user by giving the password set for the
root
> user???
>
> How do I add a new user to MySQL?? I tried by giving
> mysqladmin -u my_name -h localhost password my_password
> I got an Error Message saying "Access Denied for my_name@localhost"
>
> Any help will be highly appreciated!!
>
> Regards,
> Ganesh
>
> Ganesh Krishnan
> iCOPE Technologies Pvt. Ltd.
> 111/112, 3rd Cross,1st Main, 7th Block
> Koramangala, Bangalore - 560 095
> Phone : 5716909, 5716939, 5715213
> Fax : 5716908
>
> Visit us at www.icope.com
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
