Setting up mysql permissions on phpmyadmin version 2.3.2

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
User avatar
noguru
Forum Commoner
Posts: 61
Joined: Thu Jun 06, 2002 4:03 am
Location: Just north of the City Of Gold, Land of Milk and Honey

Setting up mysql permissions on phpmyadmin version 2.3.2

Post by noguru »

Hi

We are migrating to a new server and I need to set up the permissions for phpmyadmin on this server. On the old server (using phpMyAdmin 2.1.0) there is a sessionlogin.php page where you have to login in order to get access to the various mysql databases. Once logged-in the index.php page is loaded. Your permissions are then verified against the mysql system database’s db and user tables. On this newer version of phpMyAdmin 2.3.2 (as installed by our server administrator) no sessionlogin.php and session.inc.php exist. At the moment I got full access to all databases when requesting the index.php page. I had to hardcode the root password in the config.inc.php page. I have tried to modify the pages here and there to accommodate a sessionlogin.php page, but without luck. Where am I supposed to specify the root password? Is phpMyAdmin installed incorrectly? What are the exact “idiot” steps to follow when setting up these permissions?
bozo
Forum Newbie
Posts: 2
Joined: Fri Dec 06, 2002 4:24 am

Post by bozo »

Click here:
http://www.mysql.com/doc/en/GRANT.html

Also read the documentation.html file that comes with phpmyadmin.
Post Reply