Special characters in database password cause error 1045 using mysql via command line
mysql password with percent symbol not working in ssh
mysqldump: Got error: 1045: Access denied for user 'example'@'localhost' (using password: YES) when trying to connect
Here's the password:
8A%2CLrsvi69shN8ty
Internal Agaric communication:
If you use the *correct* password for root-- the mysql root password is not the same as the server root password -- it works.
Using the DB password does not work for me either. I swear it's because the % symbol is messing things up somehow.
mysqldump % error
Hunch confirmed:
http://www.thescripts.com/forum/thread141960.html
Your password may contain shell metacharacters, such as !#'"`&;
or even whitespace. This could cause problems in the first command
example, even if the password works when you enter it interactively at a
password prompt.The solution is that you may need to quote the password, and possibly
put backslashes in even if you quote it.
Or use the root password, or change the password, or get out of the blinking web development business...
mysql password with percent symbol not working in ssh
mysqldump: Got error: 1045: Access denied for user 'example'@'localhost' (using password: YES) when trying to connect
Here's the password:
8A%2CLrsvi69shN8ty
Internal Agaric communication:
If you use the *correct* password for root-- the mysql root password is not the same as the server root password -- it works.
Using the DB password does not work for me either. I swear it's because the % symbol is messing things up somehow.
mysqldump % error
Hunch confirmed:
http://www.thescripts.com/forum/thread141960.html
Your password may contain shell metacharacters, such as !#'"`&;
or even whitespace. This could cause problems in the first command
example, even if the password works when you enter it interactively at a
password prompt.The solution is that you may need to quote the password, and possibly
put backslashes in even if you quote it.
Or use the root password, or change the password, or get out of the blinking web development business...
Comments
It's the % in MySQL 5
We have successfully used ! in MySQL passwords with no trouble. In MySQL 5.0 the % specifically seems to be the problem.
Post new comment