All password with '$' inside (phpmyadmin) won't work [UTF-8 problem]

Question

i set up a dedicaced server with a tutorial.

I set in PHP :

mbstring.language=UTF-8 
mbstring.internal_encoding=UTF-8 
mbstring.http_input=UTF-8 
mbstring.http_output=UTF-8 
mbstring.detect_order=auto

But each time there is a $ in the password (i have one for the root of mysql + other script) the password won't work.

For example, I just removed the $ in the password for a script, and it worked.

When i connect @root on mysql via phpmyadmin : don't work When i connect @root via PHP : works

What can i do for this problem please ?

PS: my password works when i connect mysql via the console

Tristan · Answer 1 · 2010-05-24 13:52:30Z

up vote 1 down vote accepted

Ok, problem found, only happens on firefox. I clean up all cache + cookies. Problem solved.

Weird. But solved. Thanks all ;)

answered May 24 '10 at 13:52

feedback

MrShunz · Answer 2 · 2010-05-24 12:47:55Z

up vote 0 down vote

$ in PHP has a special meaning, you should escape it if used in double quotes (") strings. Or you should use single quoted (') strings:

"Pa$$word"

won't work, while

"Pa\$\$word"

and

'Pa$$word'

will work.

answered May 24 '10 at 12:47

MrShunz
1,33947

	but i can't escape the password in the interface of PHPMYADMIN when he ask me my password. How can i fix that ? – Tristan May 24 '10 at 12:55
	@Tristan does it works when you connect via console? as in "mysql -u root -p" ? – MrShunz May 24 '10 at 13:02
	yes it works, i've just tested – Tristan May 24 '10 at 13:06
	#1045 - Acc�s refus� pour l'utilisateur: 'root'@'@localhost' (using password: No) IT's what phpmyadmin outputs. ("accès refusé : means access denied) – Tristan May 24 '10 at 13:11
	@Tristan seems a problem with the configuration of phpmyadmin, as it says "using password: No". Try go back to the setup page and check the authentication options. – MrShunz May 24 '10 at 13:16

feedback

risyasin · Answer 3 · 2010-05-24 13:48:28Z

In your php configuration, set to vice versa of magic-quotes-runtime variable. here is more info: http://www.php.net/manual/en/info.configuration.php#ini.magic-quotes-runtime. Phpmyadmin will able to support for passwords contains $. & also use recent versions of PMA.

3 Answers