MySql connectivity lost

Anon

Recently my ISP decided to swap over their systems. Since then my Php to MySql database connectivity fails to work.

This trivial script

<?php
$db_name = "novaz3ro";
$connect = mysql_connect('localhost','novaz3ro','password removed');
print '@1 ' . $connect . '<br>';
$db = mysql_select_db($db_name,$connect);
print '@2 ' . mysql_error() . '<br>';
?>

Generates these messages:

Resource id #1
Access denied for user: 'novaz3ro@localhost' to database 'novaz3ro'

What could my ISP have done to allow me to connect to a database but then disallow to select that very database ?

Oh yes, the small print in my ISP contract states I am not allowed to say negative things about them. I think that support calls open for more then 250 hours and nobody answering the phone is great customer service.

Any bright sparks out there ?

Anon

If you can connect, but not run queries, I would suspect that the permissions for your user aren't setup properly. Maybe they didn't grant you any perms on the appropriate tables, or they didn't grant you enough perms on the table in question.

Anon

Agree it must be related to the GRANTS for example from their phpMyAdmin interface 'SHOW GRANTS FOR 'myid' returns 'Access denied for user: 'myid@' to database 'mysql'.

Note I wrote from the phpMyadmin interface which allows me to connect, setup tables, select, insert,delete i.e. all the things I used to do. My observation from the phpMyAdmin is that all is OK.

Stepping through it does this make sense:
1. I can connect to my control panel using my normal site id and password.
2. I can access phpMyAdmin and do all data manipulation things I need to do trough that application.
3. phpMyAdmin shows me as myid@.
4. mySql technical manual page 190 states the error message to be related to incorrect password.
4. Given that system id/password combinations may differ from mySQL id/password my ISP has kindly set me up with a different system and MySql passwords but the same ids. They have also kindly forgotton to tell me what pasword they did set up. In short technical terms 'I am stuffed' until they start talking again.