Can I Configure MySQL from remote computer?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
yosuke_
Forum Commoner
Posts: 64
Joined: Tue Apr 13, 2004 12:29 pm

Can I Configure MySQL from remote computer?

Post by yosuke_ »

Hi!
I have a question. I have to make website with user registration/login picture uploading and so on. I know asp very good, but im new to MySQL. When I will finish that website i will send it to server admin, but this is my question. Server Admin will install MySQL on that computer, but I live in diferent country and that Admin dosnt know how to install DB and configure users etc.. After fresh MySQL installation, can I connect to that server via MySQL monitor (console) as root and add users and create that database and tables?? thank you
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Yes, you can. You just need to make sure your host is allowed to connect to mysql on the remote server by adding an appropriate entry in the Host column of the user table.
Then you can use mysql's -h switch to specify the host to connect to.
yosuke_
Forum Commoner
Posts: 64
Joined: Tue Apr 13, 2004 12:29 pm

Post by yosuke_ »

Thank you for fast reply!!
About that access! Does MySQL by default allow remote connections as root, or do that admin needs to set ...'root'@'%'....? thank you!
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

I don't think the default does allow that, it shouldn't anyway. You'll want your admin to take a look anyway to make sure it's all secure (ie no remote connections without a password etc..etc.)
yosuke_
Forum Commoner
Posts: 64
Joined: Tue Apr 13, 2004 12:29 pm

Post by yosuke_ »

Ok, thank you so much! ! :wink:
Post Reply