Page 1 of 1

Can I Configure MySQL from remote computer?

Posted: Fri Apr 16, 2004 4:49 am
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

Posted: Fri Apr 16, 2004 4:51 am
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.

Posted: Fri Apr 16, 2004 4:56 am
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!

Posted: Fri Apr 16, 2004 6:30 am
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.)

Posted: Fri Apr 16, 2004 10:06 am
by yosuke_
Ok, thank you so much! ! :wink: