Hi there,
Problem:
i’m using phpMyAdmin 4.3.11. In its GUI there is a tab Users and some below there is a link Add user. Ok, so far so good. I inserted the name, host and password (not md5 or any other Function right there) and gave him the same rights as the user root with no password (ALL PRIVILIGES). Then -to control- there is a new row in mysql.users.
But when I try to connect in the php-script (surely restartet mysql with xampp-control-GUI) with [php]$DB = new mysqli(“localhost”, “public_user”, “public_pwd”,"");
if ($DB->connect_errno) {
echo “<p style=“color:red;”>Failed to connect to MySQL: " . $DB->connect_error.”
return 0;
}
[/php]
the Website in ff shows [tt]Failed to connect to MySQL: Access denied for user ‘public_user’@‘localhost’ (using password: YES)[/tt]??!
Did i forget something in phpMyAdmin, are there more Entries needed than just the one line in table mysql.users?