phpmyadmin cannot create a database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

phpmyadmin cannot create a database

Post 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?
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post 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 .
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Post 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.
Post Reply