Page 1 of 1

phpmyadmin cannot create a database

Posted: Wed Oct 18, 2006 6:01 am
by amir
I am running redhat ES3 all fully updated. I have installed the current phpmyadmin.

When I initially configured phpmyadmin to log in using config method as root I was able to create new databases.
I then configured the control user and used the supplied script to create the database and tables. Since then the create database link shows "No Priviledges" and so I cannot create a new database.
I have since changed the auth mode to cookie. How can I re-enable the creation of new databases?

Posted: Wed Oct 18, 2006 8:27 am
by neophyte
Sounds like a database user permissions problem. Does the user you are logged in with have create permssions? If you are on RHE3 you may want to consider downloading at least Mysql4.1x from the Mysql site and update. You're running 3.2xx .

Posted: Wed Oct 18, 2006 8:50 am
by amir
Yes I am logging in as the root user. I can go to the SQL tab and enter a sql command to create a new database and it works.