MySQL Forums
Forum List  »  Install & Repo

Re: How can I connect to remote MySQL server ?
Posted by: phireakminh
Date: July 31, 2005 06:38AM

Yeas, you just create a user like that
Example
===================
PC1(MySQL Server)
===================
***************************MySQL***************************

/* Login to mysql by root */

C:\mysql\bin\mysql -u root -p

/* greate a user name "root" and pass "pass" that have all privileges AND can remote from any where */

>grant all privileges on *.* to root@ identified by "pass";


***************************Firewall**************************

If you don't well about firewall, you just TURN IT OFF!

=============
PC2(Clien)
=============
Download MyODBC 3.51 and install

Ok i know you can use "Data Sources (ODBC)"

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.