random MySQL database connection fail...
Our connection to database has completely failed and our host support are pointing at our connection script which was working fine this morning and we haven't made any changes!
"Access denied for user 'OURUSERNAME'@'OURIPADDRESS' (using password: YES)"
We created a new user, updated our connection script and then received the following error:
"No database selected"
This is our connection script:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_njMySQL = "OURIPADDRESS";
$database_njMySQL = "OURDATABASENAME";
$username_njMySQL = "OURUSERNAME";
$password_njMySQL = "OURPASSWORD";
$njMySQL = mysql_pconnect($hostname_njMySQL, $username_njMySQL, $password_njMySQL) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_set_charset('utf8',$njMySQL);
?>
Has anyone come across this before? We have everything hosted on a VPS with cPanel access.
Appreciate it, thank you.
NJ