How to allow remote connections to MySQL.? I did the first step (i commented out the bind-address in my.cfg). Now everywhere i look it says i can setup a user to have access to one database (or do it more times for more databases). But how can i configure it so that my "root" account has full access to all databases on the server? Right now i can connect but i can authenticate (with MySQL workbench from windows).
P.S. The server is running on Ubuntu 9.1
Thanks! |