User login

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

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.