PDA

View Full Version : MySql error?


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?