|
pesty -> myphpadmin (7/14/2004 16:01:05)
|
Hi everyone,
I know myphpadmin isn't really a FP thing, but everyone here is so smart that I thought I would try here first[sm=angel.gif]
I'm trying to set up my database through ipowerweb. I'm getting this message:
quote:
Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.
PMA Database ... not OK[ Documentation ]
General relation features Disabled quote:
When I click the "click here" button: It take me to this section in phpmyadmin:
$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 db 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 databasename in $cfg['Servers'][$i]['pmadb']
A couple of question here:
Do I need to install anything?
Does it mean I need to create a separate database? The database I have now is called pets with one table in it. I need to add more tables, but it won't accept them.
Do I need to create a database called admin?
And I want my database to allow multiple users. Does this mean I need another database for that too?
Arrrrggghhhh!
Pesty
|
|
|
|
