Don't use 'root' ... create a new user, and make sure you GRANT the proper
privs (i.e.:
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY
'password';
GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'password'
WITH GRANT OPTION;
- Original Messag
I am not sure if I understand your issue, but if the
tables have been updated in the local computer is
because you did not connect to the server. With
mysqlimport you can specify the host (-h), the user
name and password.
I think that you should use something like:
mysqlimport -hMYSERVER -pMYUSE
