As a rule, any site or service necessarily contains in its bowels a database. It is designed to store user data, product information, well, and, in general, everything that can be stored on your hard drive. At the stages of creating a dynamic site, you can’t do without a tool that could help you quickly manage databases, change data or configure tables. A kind of interactive assistant. This is exactly what the small localhost phpMyAdmin Tools program is for.
Description
localhost phpMyAdmin Tools is nothing more than a PHP add-in that requires an interpreter on the server. To use this tool, you only need a browser. To start, you need to type localhost / phpMyAdmin / Tools in the address bar.
Before logging in, phpMyAdmin will ask for a username and password. It had to be indicated at the installation stage of the program. The tool itself is a fairly convenient interface with a large number of settings and settings.
The control panel located at localhost / tools / phpmyadmin / index.php is divided into logical blocks that are intuitive to any user. On the left you can see the panel for convenient transition to the necessary database or table. In the same menu you can find an item to create a new database or table.
At the top there is a large menu that allows you to quickly switch to a particular setting and activate the special functionality of the localhost tool phpMyAdmin Tools.
The database section contains a list of the databases presented in the system. The SQL button opens a menu where you can manually specify the SQL query sent directly to the database. The Status menu item displays the current location of the databases. It contains information about their total volume, the amount of transmitted traffic and received and sent data. User accounts are also stored in this menu. It contains information about all participants in the system, their definition, addresses and passwords.
From here, you can give users privileges to access certain zones, the right to create or edit data, or even delete a specific person. Export and import are responsible for loading and unloading information. It is very convenient to use it when you need to manually update the catalog of a site or service. This menu also contains an item with settings that can be used to configure localhost phpMyAdmin Tools, databases, queries and other parameters.
Installation
This tool is a PHP script. Therefore, for its work you will need a software package. In particular, the Apache web server, the MySQL database and the PHP interpreter itself are required.
Each of them can be installed manually, or can be installed as a set, for example, for Windows there are good Denwer and OpenServer solutions. Manual installation will allow a more detailed study of each component and its settings. And installing the kit will save time.
A few tips before installing
To avoid errors during operation and installation, it is recommended to use the latest software versions. If the assembly is involved, then you need to check its components. If the components are installed separately, then you need to download the most current versions from official sites.
Ready hosting usually contains phpMyAdmin right away. But still its security, it is advisable to manually configure it via htaccess files. These are special Apache web server configuration files that can be used to configure the system for almost any need.
Do not forget about password security. It should be resistant to search and at the same time memorable. Recovering a password is much more difficult than spending time once creating a persistent and convenient one.
PhpMyAdmin on Ubuntu
To install the tool in the Ubuntu operating system, you need to type only one line in the terminal:
sudo apt-get install phpmyadmin
But a simple installation will not allow you to fully use the program, so you have to install a couple more elements:
sudo apt-get install php-mbstring php-gettext
The installation process itself is quite simple. The system will offer you to go through all the steps and fill in the necessary data. At the beginning, you will need to specify the web server used. In most cases, it will be Apache. Next, you need to configure the database. The system may ask for a password to enter MySQL. You can check the functionality of the tool by going to the browser at http //: localhost / phpmyadmin / tools.
Opportunities
The tool has a lot of interesting features and characteristics:
the ability to create and delete databases without entering commands manually;
work directly with tables, create them, copy, delete, rename or modify data;
maintain tables;
edit and add new fields individually;
execute SQL queries, including batch type;
Quickly add data using the built-in tool for importing text files in a table;
create and view the necessary dumps of all the tables presented in the database;
support for a large number of exported formats;
management and administration of several servers at the same time;
allow and prohibit users to perform certain actions or restrict their privileges;
the ability to display the scheme of the entire database in pdf format by graphics;
database search;
The product is localized in more than 50 languages worldwide.
Possible problems with phpMyAdmin
A tool can sometimes fail due to incorrect configuration or after a user missed something during the installation process. For example, the address http / localhost / tools / phpmyadmin does not open. This may indicate that the web server "does not see" the PHP interpreter. It is worth checking the main configuration file and restarting Apache.
Sometimes there may be a problem with authorization in the login panel. This may be due to an error in the name or password. To reset superuser data, you will need to manually switch to MySQL and use the commands to delete and recreate the user.
Very often there are problems with displaying text after importing a text document. This is most often associated with different encodings used in the database and file. It is worth checking their compliance with each other, and then importing them.
Finally
Since the tool is a PHP script, its modification and configuration can be changed manually with good skills in using this language.
However, without special knowledge, phpMyAdmin can be used very successfully. It has a simple interface, clear settings and good support on the Internet, due to its prevalence and popularity. So, if any problem occurs, finding the answer to the question will be quite simple.
The product in a visual form shows an alternative use of tools for working with the database. You no longer need to enter commands to control using the MySQL console manually, where if you make a mistake in one character, you could lose all the data in the worst case. PhpMyAdmin is actively developing and gaining more and more users, so its prospects are likely to be excellent.