|
SQL Drill Add-in -
FAQ
|
|
Sunday, 05 July 2009 04:33 |
|
If you are only able to connect to local MySQL connections and not able to connect to remote ones, you need to make sure the user account you are using has been granted privileges to be able to connect remotely to MySQL.
If your MySQL installation is maintained by a hosting company - you will typically have an option in your control panel to enable remote access to your databases within the database area of your control panel.
If you are able to connect to the database server via SSH, you could connect and use a SQL statement similar to the following to enable remote connections:
GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
SQL Drill Support

|