Saturday, March 7, 2009

Late night thoughts and Connecting to MySql on a Remote Machine

I'm sitting here in the dark loading lots of production data into the project so I can get some realistic looking graphs for the demo of the project.

Two things occur to me at this late hour:

  1. This project while ridiculously large in scope, was a good idea. Even as I run the import script data on different sites, I'm discovering that as structured as the data is, there are still differences between the data formats and types on the legacy server. A central db and controller is long overdue.
  2. I should have written down the instructions for enabling a remote mysql client/user to connect to a mysql instance. Here they are for the next time:


Users need permission to connect to mysql on a remote linux machine. If they don't have it, trying to log in with MYSQL Admin or MYSQL Query Analyzer will fail with a 1045 error.

To fix this log into the shell on the mysql server and type this:

make sure you have granted access to your user: (run command line)
mysql> GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host_or_ip';
I found these instructions @ http://forums.mysql.com/read.php?35,9919,12139#msg-12139

1 comment:

Unknown said...

Your late night thoughts are very helpful for us. It help us like light in the dark. Thanks. Keep the spirit in the same manner and will share the blogs with us.
e signatures