MySQL Forums
Forum List  »  Newbie

remote connection to MySQL database as administrator
Posted by: hana
Date: July 10, 2005 06:46AM

What is the best practice for connecting to MySQL database remotely with administrator privileges? Do I need to install MySQL components into the remote computer if I wanted to do administrative tasks such as what MySQL Administrator allows for root account to do?

What I tried to access the database stored in a server from my remote PC is that I installed MySQL database in my remote PC and put the server's IP address as its host and root as its user using MySQL Administrator, but the connection failed. I tried the same way using DOS. The connection failed again.

Also is it more recommended to create a new user account with administrative privileges and use that account to remotely access the database, rather than using the root account?

Please help! Thanks so much.

Options: ReplyQuote


Subject
Written By
Posted
remote connection to MySQL database as administrator
July 10, 2005 06:46AM


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.