Mysql Tips 1#

If you having trouble using mysql 5++ load data option and having an error message when issues that command
1. “ERROR XXXX: The used command is not allowed with this MySQL version” or
2. Denied access when trying to import csv file into your database table.

You might try looking something –local-infile. The default setting for –local-infile was off. You had to enable it by include in you mysql command.

For Example : mysql –host=.. –port=.. –local-infile –password=..
Then it should works now!.

For the second problem it might because the client you try to access is not root. It might be the privileges problem. Add the –local-infile line to the mysql command when you try to excute the user.

For more information you can refer to here : Load Data Error
For Connection Access Denied : Access Denied

Advertisements

About Charles Ling
Web/Android/IPhone Developer. Very very interested in Web Architecture, Web Standard and and how to use Web to improve human social life and doing cool stuff.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: