Category: phpmyadmin

phpMyAdmin – Databases ”; Previous Next Start the Apache Server and open /localhost/phpmyadmin phpmyadmin in web browser to open the phpMyAdmin interface. As we have configured a database MySQL during Environment Setup, we”ve root user with password as root@123. Once phpMyAdmin opens up, you need to enter same credential to login to database. Dashboard Once logged in, you can see the following sections on the phpMyAdmin page loaded. The left section shows the databases available, it shows system as well user created databases. On the right side, dashboard shows a tabbed interface to do all the database administration operations as shown below. Databases Click on Database Tab, to see the list of databases with more details. We can create database, iterate databases and do other operations here. Click on any listed database to see the list of tables with more details. Tabs changes as per the context. Now tabs will shows as per the database. Tables Now in the schema browser, click on any table, right side section will load the table details as shown with updated tabbed interface to do various operations on that table as shown below − Double clicking on any cell, makes it editable, where you can edit and save data. Pressing esc key, will not save data. Once you move out of editing cell, it will show the update query and status of operation as shown below − You can verify the update statement as well as show below − UPDATE `employees` SET `AGE` = ”28” WHERE `employees`.`ID` = 1; Now click on Structure tab, it will show the table structural details as shown below − Print Page Previous Next Advertisements ”;

phpMyAdmin – Charsets ”; Previous Next phpMyAdmin Charsets tab displays all the charsets and collations which are supported by MySQL server. You cannot edit anything here. It is a readonly information. Print Page Previous Next Advertisements ”;

phpMyAdmin – Binary Logs ”; Previous Next phpMyAdmin Binary Logs tabs helps in checking the log history. It shows a glimpse of whatever we”ve done using phpMyAdmin. Let”s select any binary logs file and click on Go button, It will display the logs history of that log file. Here, you can check which activities has been carried out by phpMyAdmin behind the scene. Print Page Previous Next Advertisements ”;

Discuss phpMyAdmin ”; Previous Next phpMyAdmin is one the most popular, free and open source administration tool which can manage MySQL and MariaDB. It is licensed under GNU GPLv2. It has a web based interface and can be used on any platform easily. It is available in 79 languages. It is PHP based and is provided by almost all the Web hosting solution providers who supports WAMP/LAMP development stack. Print Page Previous Next Advertisements ”;

phpMyAdmin – Replication ”; Previous Next phpMyAdmin Replication tab handles the database replication. Marking one database as master database and other as slave databases is made easy using this feature. Master Replication − This section shows the master status and connected slaves status. We can add slave replication user as well using this section. Slave Replication − This section allows to add a slave using username, password, host and port details. Print Page Previous Next Advertisements ”;

phpMyAdmin – Useful Resources ”; Previous Next The following resources contain additional information on phpMyAdmin. Please use them to get more in-depth knowledge on this. Useful Links on phpMyAdmin phpMyAdmin − Wikipedia Reference for phpMyAdmin. phpMyAdmin Home Page − Official Website of phpMyAdmin. Useful Books on phpMyAdmin To enlist your site on this page, please drop an email to [email protected] Print Page Previous Next Advertisements ”;

phpMyAdmin vs MySQL WorkBench ”; Previous Next MySQL WorkBench is part of MySQL database and it provides a full featured administrative interface to execute SQL queries and MySQL management where as phpMyAdmin is a web based tool to administer the MySQL database. Following are the some of the key differences in both interfaces. Supported Versions − phpMyAdmin supports MySQL 5.5 onwards whereas MySQL Workbench can support any version of MySQL database. Graphical Interface phpMyAdmin provides an easy to understand graphical interface to run SQL commands and do SQL operations and makes it quite easy to use as compared to MySQL workbench which is quite complex for beginners. Script Interface phpMyAdmin provides script interface to run PHP scripts to connect to databases and do customized operations. MySQL workbench has no such option. Web Based phpMyAdmin is web based and may be slow and depends upon web browser heavily where as MySQL workbench is a specilized software to work with databases. Code Highlight phpMyAdmin does not have smart code highlight capabilities or auto-complete functionalities whereas MySQL workbench provides code highlighting and auto-complete features. Pricing phpMyAdmin is completely free to use. It is open source and is provided by almost all hosting service providers whereas MySQL Workbench has a community based version which is free and open source. There are other commercial versions for enterprises which are subscription based. These commercial versions have enterprise level features and support. Print Page Previous Next Advertisements ”;

phpMyAdmin – Features ”; Previous Next Following is some of the key features of phpMyAdmin. User friendly Web Interface − phpMyAdmin UI is quite intuitive and easy to use. Most of Database Operations are supported − phpMyAdmin supports most of the MySQL/MariaDB features as listed below − Browse databases, tables, view, fields and indexes. Create/Copy/Drop/Rename databases, tables, view, fields and indexes. Server maintenance, database/tables configuration proposal. Execute, Edit and bookmark SQL statements, batch queries. Manage user accounts and privilleges. Manage stored procedures and triggers. Import Data − Data can be imported from from CSV and SQL files. Export Data − Data can be exported to various formats like CSV, SQL, XML, PDF, ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, LATEX and others Multiserver support − phpMyAdmin can be used to administrater multiple servers together. Graphics Support − phpMyAdmin can show graphics of database layout in various formats. Query-by-example − phpMyAdmin Query-by-example (QBE) can be used to create complex queries. Search − phpMyAdmin allows to searching globally in a database or a subset of database. Transformation − phpMyAdmin can help in transforming stored data into any format using a set of built-in functions, for example displaying BLOB-data as image or download-link. Print Page Previous Next Advertisements ”;

phpMyAdmin – Plugins ”; Previous Next phpMyAdmin Plugins tab displays all the plugins which are presently installed in MySQL server. It contains information like their version and description. Plugins are broadly categorized in six categories − AUDIT AUTHENTICATION DAEMON FTPPARSER INFORMATION SCHEMA STORAGE ENGINE If you click on any of the category, it will scroll to the related list of plugins. Print Page Previous Next Advertisements ”;

phpMyAdmin – Exports ”; Previous Next phpMyAdmin provides an intuitive user interface to export database(s). Click on Go button and phpMyAdmin will generate SQL required to create databases/tables and other relevant entities. Instead of SQL, user can choose other popular options as well like csv, json, yaml etc. Now select the custom option and phpMyAdmin will show lots of options like Databases − A list of databases to be selected. User can select multiple databases. Output − Options to save output to a file with customization options like name, charset, compression. It also provides options to skip large tables, rename exported databases/tables/columns and so on. Format Specific Options − Options to display/hide comments, enclose export in a transaction, export views as tables, export metadata and database selection for compatabilities and so. Object Creation Options − Options to add drop database/tables etc if exists, auto increment id, add create view, add create trigger statements, using backquotes to enclose table and column names etc. Data Creation Options − Options to truncate table before insert delayed statements and insert ignore statements. Options to choose format while preparing sql for insert data, set the maximum length of created query, dump timestamp columns in UTC etc. Print Page Previous Next Advertisements ”;