Advanced features of phpmyadmin

Posted by Bounceweb in Computer Advice, Software, The Internet, Web Hosting, Web Hosting Tips

1 Star2 Stars (1 votes, average: 0.00 out of 5)

Advanced features of phpmyadmin

As you may accept realized, the PHP accent revolves about the axial affair of practicality. PHP is about providing the programmer with the all-important accoutrement to get the job done in a quick and able fashion. Five important characteristics making in PHP’s :
1. Familiarity
2. Simplicity
3. Efficiency
4. Security
5. Flexibility

Installing PhpMyAdmin Advanced Features

To install the advanced features of phpMyAdmin you have to create a special control database that PMA uses to store bookmarks and relationships etc… PMA comes with a script called create_tables.sql that include the relevant sql statements to set these tables up. Gradually, when you install phpMyAdmin directly from source, this create_tables.sql script can be found in the scripts sub-folder.
Instructions
Firstly, unzip and run the create_tables.sql file:
cd /usr/share/doc/phpmyadmin/examples
sudo gunzip create_tables_mysql_4_1_2+.sql.gz
mysql -u root -p < create_tables_mysql_4_1_2+.sql
Then setup a user/password for phpMyAdmin to use:
mysql -u root -p -e ‘GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO ‘pma’@’localhost’ IDENTIFIED BY “password”‘
Then edit the config file, and uncomment the extra features options for your chosen server, and add the individual / password you setup in the previous step. If you haven’t edited this enter before you may requirement to also uncomment the rest of the server definition.
sudo vim /etc/phpmyadmin/config.inc.php
Setting up foreign keys in phpMyAdmin?
InnoDB allows you to add a fresh foreign key constraint to a table by using ALTER TABLE:
ALTER TABLE tbl_name
ADD [CONSTRAINT [symbol]] FOREIGN KEY
[index_name] (index_col_name, …)
REFERENCES tbl_name (index_col_name,…)
[ON DELETE reference_option]
[ON UPDATE reference_option]
On the other hand, if MyISAM has main advantages over InnoDB in your context, why would you need to create foreign key constraints at all. You can handle this on the model level of your application.
Create a sample database using your PMA, into this database run the following SQL query:
CREATE TABLE `profiles` (
`id` int(11) NOT NULL auto_increment,
`content` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`profile_id` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Hopefully this helps you with a short intro to the Advanced Features of PHPmyAdmin

All of BounceWeb’s PHP Hosting Plans include PHPmyAdmin

Be Sociable, Share!

Leave a Reply

You must be logged in to post a comment.