Define a user like this:
GRANT ALL ON *.* TO 'myuser'@'localhost' IDENTIFIED BY 'super$ecret';
Then try a PHP script like this:
<?php
mysqli_connect("localhost", "myuser", "super$ecret");
?>
What happens and why? How could you avoid it?
And for glory, what single line could you add that would prevent the error, without making any changes to the mysqli_connect line?
$ecret = ‘$ecret’;
Comment by Justin Swanhart — October 1, 2012 @ 12:59 pm
Which is why I quote PHP strings with single quotes, not double quotes.
Comment by Shlomi Noach — October 2, 2012 @ 12:35 am