Allstar
12-13-2002, 10:27 PM
Hey Guys,
Question.
I was playing around with one of my databases the other day. All I did was increase the character size of one of the tables and change the data in the field to a javascript link, instead of the text that was there.
It seems to work when I tested it. However the next day, there are several tables where the browse, select, and empty options are no longer highlighted.
This error appears at the bottom of phpMyadmin.
----
Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.
----
So I did and...
----
PMA Database ... not OK[ Documentation ]
General relation features Disabled
----
Clicking on documentation leads to..
----
$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 will need to create a new db.
To use this functionality as superuser create a new database:
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']
----
I am lost here guys. Any of you good with Mysql? I am still a newbie as I have only needed to create databses never really messing with anything else.
I just was wondering what I did and/or does it matter. Everything seems to work still. It's just that it said I had an error. Also, all my databases have this error.
Any idea? No hurry.
Thanks
Allstar
Anyone?
Question.
I was playing around with one of my databases the other day. All I did was increase the character size of one of the tables and change the data in the field to a javascript link, instead of the text that was there.
It seems to work when I tested it. However the next day, there are several tables where the browse, select, and empty options are no longer highlighted.
This error appears at the bottom of phpMyadmin.
----
Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.
----
So I did and...
----
PMA Database ... not OK[ Documentation ]
General relation features Disabled
----
Clicking on documentation leads to..
----
$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 will need to create a new db.
To use this functionality as superuser create a new database:
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']
----
I am lost here guys. Any of you good with Mysql? I am still a newbie as I have only needed to create databses never really messing with anything else.
I just was wondering what I did and/or does it matter. Everything seems to work still. It's just that it said I had an error. Also, all my databases have this error.
Any idea? No hurry.
Thanks
Allstar
Anyone?