i am about to recreate a big relational database in mysql, i hav been told about innodb, i started creating the tables in phpMyAdmin, everythings fine but theres no options for creating relations, it also says a small error,
Error The additional Features for working with linked Tables have been deactivated. To find out why click here.
i click there and then it says
PMA Database ... not OK[ Documentation ] General relation features Disabled
the documentation link takes me here
$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. See the Quick Install section in this document for a quick way of creating those tables. Also, if you are using a Windows server, read FAQ 1.23. 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']
i just need to get it sorted to start making relations
i do understand the documentation but before i do anything can somone give me some advice please, like what would u do, i am confused by the flatness of the interface of mysql lol.
Thanx alot guys