Shulou(Shulou.com)06/02 Report--

Editor to share with you the export error report mysqldump: [Warning] Using a password on the command line interface can be insecure in mysql. How to do, I believe most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

Execute the following mysql export command to report an error:

Mysqldump-h localhost-uroot-p123456-d xmall > / usr/local/1101xamll.sql

Error message: mysqldump: [Warning] Using a password on the command line interface can be insecure.

1. Modify / etc/my.conf

Add the following at the end of the file:

[client] host=localhostuser=rootpassword=123456

2. Execute command export:

Mysqldump-- defaults-extra-file=/etc/my.cnf-d xmall > / usr/local/1101xamll.sql above are all the contents of the article "Export error mysqldump in mysql: [Warning] Using a password on the command line interface can be insecure." Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.