I just started using mysqli:
$mysqli = new mysqli("localhost", $dbuser, $dbpass, $dbname);
When I try an insert, I get the error:
Access denied for user 'dredington'@'localhost' (using password: NO)
I'm sure I can figure out what I'm doing wrong, but this appears to be a common problem:
So who is 'dredington'? Where did this come from?
To clarify: this is not a technical help question - I was writing the query wrong and have fixed it. But 'dredington' is nowhere in my code. Just wondering where it originates in the history of MySQL?
The manual says that the default user, if you haven't set $dbuser, will be the value of ini_get("mysqli.default_user"), so 'dredington' was presumably set by your web hosting company in their php.ini file.
This will try to open with the username and password that you supply. The value of dbuser will be used as the username and dbpass as password. You need to set these two values.