Mysql修改密码Warning: single quotes were not trimmed line client, as you might have expected.
来源:互联网 发布:香港淘宝怎么注册 编辑:程序博客网 时间:2024/05/22 00:16
一、问题
今天修改mysql数据库密码的时候,使用了误导写法
# mysqladmin -uroot -p passowrd 'test'出现以下提示:
Warning: single quotes were not trimmed line client, as you might have expected.
言外之意就是修改密码的时候使用了单引号。
然后登录的时候却使用test密码登录,一直登不上,因为实际密码应该是有英文单引号的'test'。
个人比较好奇的是,为什么使用英文双引号就OK!!!
二、解决办法
使用标准写法
今天修改mysql数据库密码的时候,使用了误导写法
# mysqladmin -uroot -p passowrd 'test'出现以下提示:
Warning: single quotes were not trimmed line client, as you might have expected.
言外之意就是修改密码的时候使用了单引号。
然后登录的时候却使用test密码登录,一直登不上,因为实际密码应该是有英文单引号的'test'。
个人比较好奇的是,为什么使用英文双引号就OK!!!
二、解决办法
使用标准写法
# mysqladmin -uroot -p passowrd root
PS:上面的误导写法只存在于Windows下,Linux下没发现这种问题,密码用单双引号引起都可以。
阅读全文
0 0
- Mysql修改密码Warning: single quotes were not trimmed line client, as you might have expected.
- Fix "\\computer is not accessible. You might not have permission to use this network resource”
- I might as well have them
- You might not need jQuery
- mysql command line client输入密码一闪而过
- mysql command line client 密码忘记
- git push updates were rejected because the remote contain works that you do not have
- You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (
- [magento]Warning: Your Magento folder does not have sufficient write permissions. If you wish to pro
- mysql忘记密码后commod line client进不去的问题
- 550 5.7.1 Client does not have permissions to send as this sender
- nagios 监控出现It appears as though you do not have permission
- nagios监控失败报错It appears as though you do not have..
- You were not doing so wrong.
- nagios It appears as though you do not have permission to view information you requested...的解决
- It appears as though you do not have permission to view information for any of the hosts you request
- MySQL Command Line Client
- MySQL Command Line Client
- 缓存穿透和缓存雪崩
- Springboot Web应用中服务器配置参数ServerProperties的加载
- find命令、 文件名后缀2.23-2.26
- 12.dubbo回声测试、上下文信息、隐式参数
- day06_debug+泛型+枚举+静态导入+自动装拆箱
- Mysql修改密码Warning: single quotes were not trimmed line client, as you might have expected.
- 使用Sublime Text 开发Python如何配置环境(windows 7)
- Tensorflow的GPU配置:ubuntu16.04+375.26驱动+cuda8.0+cudnn5
- Vijos P1688 病毒传递
- 10. Regular Expression Matching
- H5页面定时器
- LINUX 系统备份和恢复(通过虚拟机试验)
- Gradle学习(六)——多项目构建
- 【Linux】【Windows】32/64,文件系统,磁盘分区,X86/ARM