Problem With Database Name - Syntax Error Or Access Violation

Yii 1.1 General Discussion
1

I have some problems with my database connection.

The information I got from my hoster to access the database are something like that:

[b]localhost

db123

user123

pw123[/b]

If I login to PhpMyAdmin I can add more databases in this account.

I added a database named:

appdb123


select count(1) from users;

results:


CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db123.users' doesn't exist. The SQL statement executed was: select count(1) from users;

and


select count(1) from appdb123.users;

results


CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'user123'@'localhost' for table 'users'. The SQL statement executed was: select count(1) from appdb123.users;

Any ideas?

Thank you!

2 

grant all privileges on appdb123.* to 'user123'@'localhost' identified by 'pw123';

flush privileges;

maybe you’ve created db under another user