MySQL5.6 Using a password on the command line interface can be insecure解决方法;
来源:互联网 发布:华为总是停用移动数据 编辑:程序博客网 时间:2024/06/06 22:39
1.最近把MySQL从5.5升到5.6以后,mysqldump居然不好用了,提示:
代码如下
复制代码
[root@qttc ~]# /usr/local/mysql/bin/mysqldump -uroot -proot db > bak.sql
Warning: Using a password on the command line interface can be insecure.
翻译过来是:在命令行界面上使用密码可以是不安全的;
这让人有点郁闷,5.5用的1直都很爽,到5.6居然说命令行方式写密码不安全?那密码写哪呢?
在官网文档找到了缘由,大家可以点击这里看看:
1.官方网址:http://dev.mysql.com/doc/refman/5.1/en/password-security-user.html
MySQL users shoulduse the following guidelines to keep passwords secure.
When you run a client program to connect to the MySQL server, it is inadvisableto specify your password in a way that exposes it to discovery by other users.The methods you can use to specify your password when you run client programsare listed here, along with an assessment of the risks of each method. Inshort, the safest methods are to have the client program prompt for thepassword or to specify the password in a properly protected option file.
翻译过来大意是在命令行下如果要使用密码可以在执行命令后的提示输入里输入密码,或者在指定的安全文件内指定密码;那安全文件时哪个呢?文档对此给出了答案:
Store your passwordin an option file. For example, on Unix, you can list your password in the[client] section of the .my.cnf file in your home directory:
可以在my.cnf内指定,于是打开我的my.cnf,在[mysqldump]下增加:
代码如下
复制代码
user=root
password=root
文中说的在[client]下面加也可以,但那样就所有块的操作都能共享了,所以生产环境上为了安全还是尽量分开;保存退出再dump就ok了;
代码如下
复制代码
[root@qttc ~]# /usr/local/mysql/bin/mysqldump db > bak.sql
[root@qttc ~]#
MySQL 5.6 警告信息 command line interface can be insecure 修复
在命令行输入密码,就会提示这些安全警告信息;
Warning: Using apassword on the command line interface can be insecure.
注:mysql -u root -pPASSWORD 或 mysqldump -u root -pPASSWORD 都会输出这样的警告信息.
1.针对mysql:
mysql -u root -pPASSWORD改成mysql -u root -p 在输入密码即可.
2.mysqldump就比较麻烦了,通常都写在scripts脚本中;
解决方法:
对于mysqldump 要如何避免出现(Warning:Using a password on the command line interface can be insecure.) 警告信息呢?
vim /etc/mysql/my.cnf
[mysqldump]
user=your_backup_user_name
password=your_backup_password
修改完配置文件后, 只需要执行mysqldump 脚本就可以了;备份脚本中不需要涉及用户名密码相关信息;
- MySQL5.6 Using a password on the command line interface can be insecure解决方法;
- mysql5.0 Using a password on the command line interface can be insecure.最简单的解决办法
- Warning: Using a password on the command line interface can be insecure .ERROR 1045 (28000): Access
- cmd命令行下 Warning: Using a password on the command line interface can be insecure.
- Warning: Using a password on the command line interface can be insecure.
- mysqldump Warning: Using a password on the command line interface can be insecure.
- MySQL 解决数据导出问题:Using a password on the command line interface can be insecure.
- Error: mysql error: mysql: [Warning] Using a password on the command line interface can be insecure
- zabbix Warning: Using a password on the command line interface can be insecure
- zabbix监控mysql之Warning: Using a password on the command line interface can be insecure.
- Warning: Using a password on the command line interface can be insecure
- mysql 备份报错mysqldump: [Warning] Using a password on the command line interface can be insecure.
- 解决MySQL5.6出现"Using a password on the command line interface..."
- MySQL5.6出现”Using a password on the command line interface…”解决办法
- MySQL5.6 Using a password on the command line inte
- Mysql Warning :Using a password on the command line...
- MySQL 5.6 警告信息 command line interface can be insecure 修复
- This warning can be disabled by using the command line flag -Dcom.android.build.gradle.overridePath
- java_笔记-10
- 添加到UIView上的UIButton点击没反应 UITest时源文件找不到解决方案
- 排序之Java的Sort函数
- 【数据结构与算法分析】1.3 用printOut函数输出任意实数
- 什么是版本控制系统(VCS)?
- MySQL5.6 Using a password on the command line interface can be insecure解决方法;
- JS高级
- 软件测试面试题
- const的用法,特别是用在函数后面
- 论java类中的构造方法
- 使用Adapter提供的convertView优化Listview
- 软件测试的对象
- 机器学习
- hdu5536 Chip Factory (暴力+优化)