i have a database i backed from another server using mysqldump
the database is called pbx
so, i created pbx database on the new server, then restored the backup file into pbx
this is where i gets confusing, the username an password are also pbx (not my idea).
so i created the user 'pbx' then used
grant all privileges on pbx.* to pbx@'%' identified by 'pbx';
this i thought granted user rights for a specific user on a specific db.
then when i try
"Select * from pbx;"
ERROR 1146 (42S02): Table 'pbx.pbx' doesn't exist
i just want to see if the backup is complete etc....