MySQL Forums
Forum List  »  Install & Repo

Re: How can I connect to remote MySQL server ?
Posted by: Wells Wang
Date: August 14, 2004 03:51AM

you can update user table of mysql database to allow machine B to connect it.

for example:

mysql -u root -p

mysql> connect mysql;
mysql> update user set host='B',password=password('yyyyy') where host='xxx' and user='aaaaa';
mysql> flush privileges

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.