Grant access to your MySQL
One of the best tools i have ever used in my whole life for database management and design has to be Navicat. That application is just so useful and easy to get the hang of. So when i get a new server granting access is one of the first things i hit. How do i forget this every time, i have no idea. How it starts is i open up Aptana and start my application then start building, the next thing i do is open Navicat and try to connect and duhh! The server is refusing the connection from my IP! So i open up a terminal and login to the server then open mysql. Next i will grant access to all databases on my IP for my username and password. See below…
# Granting remote access to your mysql database
mysql> GRANT ALL ON * TO user@'192.168.1.1' IDENTIFIED BY 'PASSWORD';
Yes, replace “user” with your username and replace “192.168.1.1″ with your real IP and “PASSWORD” with a real one! Hope that helps save someone some time!
