Two things occur to me at this late hour:
- 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.
- 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.I found these instructions @ http://forums.mysql.com/read.php?35,9919,12139#msg-12139
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';
1 comment:
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
Post a Comment