Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the load data infile ERROR 1045 problem in the database". In the daily operation, I believe many people have doubts about how to solve the load data infile ERROR 1045 problem in the database. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the load data infile ERROR 1045 problem in the database". Next, please follow the editor to study!

When a non-root user imports data from the mysql server deployment machine through the load data infile command

Error report: ERROR 1045 (28000): Access denied for user 'xxx'@'xxx' (using password: YES)

Possible reason: this is generally because non-root users do not have FILE Privilege. You can check the permissions of current login users through show grants, and you can also view the permissions of a user through select mysql.user. In general, normal user does not have FILE permissions.

Solution:

Command plus local parameter, using load data local infile 'filename' into table xxx.xxx to guide data

At this point, the study on "how to solve the load data infile ERROR 1045 problem in the database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.