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
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.
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!
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.)