phpMyAdmin my drop database button dissapeeared - GoFuckYourself.com

Juicy D. Links · 03-20-2004, 10:56 AM

It tells me this shit

$cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below.
If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb'].

If you are setting up a multi-user phpMyAdmin installation, you will need to create a new database and setup special privileges, so, as superuser:

create a new database for phpMyAdmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';
do not give any other user rights on this database.
enter the database name in $cfg['Servers'][$i]['pmadb']

Someone explain that so a simpleton like myself can comprehend

infecto · 03-20-2004, 11:20 AM

What are you trying to do juicy? Those seem like the instructions to me.

Steve · 03-20-2004, 12:18 PM

looks like the user you created wasn't granted permission to drop the table

Juicy D. Links · 03-20-2004, 12:22 PM

Quote:

Originally posted by Steve
looks like the user you created wasn't granted permission to drop the table

yeah i think i fucked something up I am gonna mess around with it

03-20-2004, 10:56 AM	#1
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	phpMyAdmin my drop database button dissapeeared It tells me this shit $cfg['Servers'][$i]['pmadb'] string Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below. If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. If you are setting up a multi-user phpMyAdmin installation, you will need to create a new database and setup special privileges, so, as superuser: create a new database for phpMyAdmin: CREATE DATABASE phpmyadmin; Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser): GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost'; do not give any other user rights on this database. enter the database name in $cfg['Servers'][$i]['pmadb'] Someone explain that so a simpleton like myself can comprehend

03-20-2004, 11:20 AM	#2
infecto Confirmed User Join Date: May 2003 Posts: 1,697	What are you trying to do juicy? Those seem like the instructions to me.

03-20-2004, 12:18 PM	#3
Steve Confirmed User Join Date: Feb 2001 Location: USA Posts: 6,894	looks like the user you created wasn't granted permission to drop the table