56,677
社区成员
发帖
与我相关
我的任务
分享mysqldump 语句出错(密码有字符 %)
写了一个自动备份数据的脚本。但是我的数据库密码有字符 %
mysqldump 语句就出错了。
mysqldump -uroot -p%120
请问有办法吗？
...全文
请发表友善的回复…
发表回复
懒得去死 2008-09-17
- 打赏
- 举报
Tell us your scripts content.
Here is my test.
[root@localhost david_yeung]# mysql -uadmin -p%ilove -S/tmp/mysql_3310.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 42
Server version: 5.0.45-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
Here is my test.
[root@localhost david_yeung]# mysql -uadmin -p%ilove -S/tmp/mysql_3310.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 42
Server version: 5.0.45-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
