Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When I installed MySQL server in Windows, there was an option "Allow root connection from remote machine". I checked that option and I had no probs when using it. I installed MySQL server in Ubuntu 9.04 using apt-get install. I can connect to the sql server from the same machine but when I try to connect from a virtual machine, it doesn't work. My guess is that I should allow root connection from remote machine. How to do that?

share|improve this question
    
I think you mean MySQL? –  squillman Nov 14 '09 at 4:52
    
yep. MySql. sorry, my bad. Updated now. :) –  Senthil Kumar Nov 14 '09 at 5:06

1 Answer 1

It's done a little differently in mysql. Take a look at the explanation here, it's not bad:

http://www.ntchosting.com/mysql/grant.html

the long, detailed version can be found here:

http://dev.mysql.com/doc/refman/5.1/en/grant.html

Another viable option if you don't wish to learn the full syntax is to install phpmyadmin - it can be a handy tool to have around, and it does somewhat simplify mysql privledges. It's in the apt repository on ubuntu - be warned though that it is a web based application, and does require a web server to be installed to use it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.