PhpMyAdmin is a Database Administration tool, used for managing the MySQL & MariaDB databases, and it is available in the phpMyAdmin website for cost free as an open source software applications. It was originally written in the PHP scripting language, in order to work around more than one database and related servers. MySQL Account All students, student organizations, and instructors can request a MySQL database account. MySQL allows you to store, organize, and access information in a relational database. If you've set up a web server using a service other than Apache, you might be able to install phpMyAdmin by copying the phpMyAdmin folder into the service's root folder. The folder used will vary widely from service to service. Dec 16, 2017 First off, phpMyAdmin enables you to check the status of your MySQL or MariaDB server. To do this, jump to the Status tab in phpMyAdmin without selecting a specific database: Inside, you’ll find a summary of all the traffic your server has sent and received while it’s been running. The phpMyAdmin program is handy for performing maintenance operations on tables, backing up information, and editing things directly in the event that WordPress is not working. Occasionally, in the Support Forums, someone will post a SQL query of some benefit or other that can be run using phpMyAdmin.
Developer(s) | The phpMyAdmin Project |
---|---|
Initial release | September 9, 1998; 22 years ago |
Stable release | 5.1.0[1] / 2021-02-24[±] |
Repository | https://github.com/phpmyadmin/phpmyadmin |
Written in | PHP, JavaScript |
Operating system | Cross-platform |
Available in | 79[2] languages |
Type | Database management |
License | GNU General Public License 2 |
Website | www.phpmyadmin.net |
phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.[3]
History[edit]
Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-end to MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time.[4]
By that time, phpMyAdmin had already become one of the most popular PHP applications and MySQL administration tools, with a large community of users and contributors. In order to coordinate the growing number of patches, a group of three developers (Olivier Müller, Marc Delisle and Loïc Chapeaux)[5] registered The phpMyAdmin Project at SourceForge and took over the development in 2001.[6]
In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.[7] At the same time, the releases began [8] to be PGP-signed. Afterwards, issue tracking moved to GitHub[9] and the mailing lists migrated.[10] Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.
Features[edit]
Features provided by the program include:[11]
- Web interface
- MySQL and MariaDB database management
- Import data from CSV, JSON and SQL
- Export data to various formats: CSV, SQL, XML, JSON, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX, SQL, and others
- Administering multiple servers
- Creating PDF graphics of the database layout
- Creating complex queries using query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
- Network traffic to the SQL server
- Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* ( such as Sun* Solaris* , AIX) and others.
- Make complex SQL queries easier.
See also[edit]
References[edit]
- ^'phpMyAdmin 5.1.0 is released'. phpmyadmin.net. Retrieved 2021-02-24.
- ^'Translations'. phpMyAdmin. Retrieved 2019-03-09.
- ^'phpMyAdmin Review'. PCWorld. 2011-04-20. Retrieved 2017-10-27.
- ^'phpMyAdmin - About'. phpMyAdmin. Retrieved 2013-03-03.
- ^Micral, Achille (12 September 2013). 'phpMyAdmin, 15 ans, toujours amoureux' [phpMyAdmin, 15 years old, still in love]. Romgame Fr. (in French). Archived from the original on 15 September 2013. Retrieved 12 May 2019.
Plus tard Olivier Müller, Marc Delisle et Loïc Chapeaux on déposé en 2001 phpMyAdmin tel que nous le connaissons sur SourceForge, et son développement ne s'est dès lors jamais arrété.
- ^Delisle, Marc (2010). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 359. ISBN978-1-84951-354-8.
- ^'phpMyAdmin website and downloads moved'. phpMyAdmin. 2 July 2015. Retrieved 21 June 2019.
- ^'Installation — phpMyAdmin 5.2.0-dev documentation'. docs.phpmyadmin.net. Retrieved 2021-03-19.
- ^'phpMyAdmin moves issue tracking to GitHub'. phpMyAdmin. 20 July 2015. Retrieved 21 June 2019.
- ^'phpMyAdmin mailing lists have been moved'. phpMyAdmin. 25 July 2015. Retrieved 21 June 2019.
- ^'phpMyAdmin'. phpMyAdmin. Archived from the original on 2013-02-16. Retrieved 2013-03-03.
External links[edit]
Wikimedia Commons has media related to phpMyAdmin. |
- Official website
Retrieved from 'https://en.wikipedia.org/w/index.php?title=PhpMyAdmin&oldid=1012987439'
Contents |
phpMyAdmin is a very popular MySQL management software package. To use it, you'll need to install and configure Apache, PHP, and the PHP MySQL (or mysqli) extension. See ApacheMySQLPHP for instructions.
Install phpMyAdmin from the Universe repository. See InstallingSoftware for detailed instructions on using repositories and package managers. (Note, however, that installation from a package manager often does not work).
From console:
- If you're using Ubuntu 7.10 (Gutsy) or later select Apache2 from the 'Configuring phpmyadmin' dialog box.
To set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf.
- If you are using Ubuntu 9.04 (Jaunty), there is no need to modify /etc/apache2/apache2.conf as the package installer already copied the file phpmyadmin.conf into /etc/apache2/conf.d directory. You can also skip the set up step and go directly to /phpmyadmin'>http://<hostname>/phpmyadmin and login with the user and password you set up during install.
Once phpMyAdmin is installed point your browser to http://localhost/phpmyadmin to start using it. You should be able to login using any users you've setup in MySQL. If no users have been setup, use admin with no password to login.
Should you get a 404 'Not Found' error when you point your browser to the location of phpMyAdmin (such as: http://localhost/phpmyadmin) the issue is likely caused by not checking the 'Apache 2' selection during installation. To redo the installation run the following:
Then select Apache 2 for the webserver you wish to configure.
If this does not work, then you can do the following to include the phpMyAdmin-shipped Apache configuration into Apache:
- Since Ubuntu 13.10 (Saucy Salamander), Apache no longer loads configuration files from the /etc/apache2/conf.d directory. Instead, they are placed in the /etc/apache2/conf-available directory which is managed with the a2enconf command. Therefore, if you need to manually include the phpMyAdmin-shipped Apache configuration file, you must run the following:
You may install phpmyadmin from source. This method circumvents the package manager and you will need to install updates yourself. This is not recommended for a production web server. Also, you'll need to have Subversion installed to download the source.
127.0.0.1 Localhost Phpmyadmin
To install it from source, open the console and cd to the www directory using:
Then download it using svn by writing:
Then cd to phpMyAdmin:
Phpmyadmin For Postgresql
Create the directory config:
Lastly, chmod it:
![Mysql admin web Mysql admin web](/uploads/1/1/2/1/112190211/133244004.png)
![Phpmyadmin Phpmyadmin](/uploads/1/1/2/1/112190211/678046257.jpg)
Navigate to http://localhost/phpmyadmin/scripts/setup.php in your browser and follow the instructions.
Note: This guide has been tested on Ubuntu 6.06 (Dapper), Ubuntu 7.10 (Gutsy), and Ubuntu 8.04 (Hardy).
CategorySoftware