Having trouble creating Databases

[Booma]

Hello,

I'm having trouble creating databases. Privileges prevents phpmyadmin from doing so, which makes sense, but I'm having using mysqladmin and mysql in the shell, where connecting to localhost as root ect but nothing seems to happen.

Can anyone offer any advice about how others create new databases?

Many thanks

[pete_1967]

mysql -u dbadmin -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database foo;
Query OK, 1 row affected (0.02 sec)

mysql> show databases;
+----------------------------------+
| Database                         |
+----------------------------------+
| information_schema               | 
| comicsite                        | 
| dc_web                           | 
| discoverycollectioncom_87544_db1 | 
| foo                              | 
| mysql                            | 
| postcard                         | 
+----------------------------------+
7 rows in set (0.02 sec)

mysql>

[Booma]

Thank you, that works, however I cannot see the databases in phpmyadmin, even after restarting the services.

What do you think?

Many thanks.

[neogranas]

What user are you using to log in to phpMyAdmin and what privileges does that user have in the mysql.users table?