phpMyAdmin is a LAMP application created specifically for administration MySQL servers. Written in PHP and accessible via a web browser, phpMyAdmin provides a graphical interface for database administration tasks.
Installation
Before installing phpMyAdmin you will need access to MySQL database on the same computer where you install phpMyAdmin, or on remote computer, available online. See the MySQL section for details. To install in the terminal, enter:
Sudo apt-get install phpmyadmin
When prompted, select which web server will be configured for phpMyAdmin. This section is intended to be used as web server Apache2.
Sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin sudo /etc/init.d/apache2 reload
In your browser, go to http:// localhost/phpmyadmin. On the login page, enter root as the username, or another user if you configured one, and the MySQL password for that user.
If in the previous step, when you go to the address http:// localhost/phpmyadmin, the server gives an error 404 - Not found, check the file location phpmyadmin.conf. In case of ubuntu 12.04: if the file is missing at the address /etc/apache2/conf.d/phpmyadmin.conf and at the same time exists at the address /etc/phpmyadmin/apache.conf, then move the file and restart the server: sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf sudo /etc/init.d/apache2 restart
After that, try logging in through your browser again.
Settings
The phpMyAdmin configuration files are located in /etc/phpmyadmin. The main settings file is /etc/phpmyadmin/config.inc.php. This file contains configuration options that apply to phpMyAdmin globally.
To use phpMyAdmin to manage MySQL on another server, set up the following entry in /etc/phpmyadmin/config.inc.php:
$cfg["Servers"][$i]["host"] = "db_server";
Replace db_server to the current IP address remote server databases. Also make sure that the computer with phpMyAdmin has access rights to the remote database.
After setup, log out of phpMyAdmin and log in again and you will have access to the new server.
The config.header.inc.php and config.footer.inc.php files are used to add header and footer HTML for phpMyAdmin.
Setting up phpmyadmin (this article)
08/16/2010 Tigrusha
and you also need to remember root for those who don’t know how to find 2 files config.inc and config.inc.php in the phpMyAdmin folders and find /* Authentication type and info */
$cfg["Servers"][$i]["auth_type"] = "config";
$cfg["Servers"][$i]["user"] = "root";
$cfg["Servers"][$i]["password"] = "";
$cfg["Servers"][$i]["AllowNoPassword"] = true;
and minya eat on your crawler current first in the base, don’t forget
01/09/2011 serdjuzz
please tell me:
when I type in the browser (Chrome and IE they write:
The web page at http://localhost/phpmyadmin may be temporarily unavailable or may have been permanently moved to a new location.
Additional information about this error
The original error message is shown below
Error 101 (net::ERR_CONNECTION_RESET): Unknown error.
What's wrong?
Thank you
01/09/2011 serdjuzz
it's always like this)))
ask and you will figure it out)))
thank you, your help is mature = I’m being stupid
01/20/2011 Alexey
Thanks for this tutorial! Everything is very detailed and well written. The only thing I couldn’t do was to allow phpMyadmin to log in from the Internet (it works locally). When typing http://sitename/phpmyadmin in the browser, it gives an error:
New XAMPP security concept:
Access to the requested object is only available from the local network.
This setting can be configured in the file "httpd-xampp.conf".
I see that I need to dig in the "httpd-xampp.conf" file, but I don't know what to fix.
Admin, can you help me? Thanks in advance.
01/21/2011 admin
Alexey, in the article “Configuring and protecting Apache under Windows” I touched on this topic.
Let's look at the very end of the article.
I quote
===============
IN latest versions xampp access to administrative scripts is only possible with local entry, external access is closed, phpmyadmin is also only available locally.
If you want to open external access for phpmyadmin or other standard scripts, look at the file again
There is a similar design here
.....
This construction prohibits access from outside, of course the ban itself is inside this construction, but if you need to open external access for example for phpmyadmin, then simply remove it from this list.
==============
That is, from the line
remove phpmyadmin
03/14/2011 Andrey
When I register http://localhost/phpmyadmin/, I get the error The connection could not be established for the user specified in the controluser directive, using the parameters defined in the configuration file config.inc.php. Help please!
03/15/2011 admin
Andrey, we're talking about about the user pma.
The login or password for pma is incorrect.
In the settings file you need to specify a login password for it if you changed it.
$cfg["Servers"][$i]["controluser"] = "pma";
$cfg["Servers"][$i]["controlpass"] = "";
05/26/2011 Dmitry
After all the settings, phpAdmin stopped opening altogether. Doesn't respond to button presses on the panel. After entering in command line in the local area it gives an error 403 and “access denied”. From the outside there is also an error. Where to dig? Everything is set up strictly according to your instructions.
05/27/2011 Admin
Dmitry, most likely they did something in the server settings.
403 is most likely a request sent to a directory that does not have an index file and file listing is prohibited in the server settings.
It seems to me that somewhere in the Apache settings the wrong path to phpmyadmin was written.
05/27/2011 Dmitry
In general, I rechecked everything again and found out this thing. If in the file
/xampp/apache/conf/extra/httpd-xampp.conf
.....
That's it... phpmyadmin becomes unavailable at all. Neither from the locale, nor from outside. IN hosts file everything is spelled out that you need. the paths are all correct.
True, it gave another error:
In the php.ini file, if I specified the directory D:/xampp/, it gave an error. It turned out that you need to register D:\xampp\. In this file, half of the paths are written with slashes in one direction or the other. Maybe build 1.7.4 is not properly tested?
05/30/2011 admin
Dmitry, there’s a strange situation with slashes.
There really is such a problem, slashes in different directions.
For some this causes problems, for some it does not.
For some, slashes work in one direction, for others in the other.
And for many, all slashes work.
Why such nonsense with these slashes, I can’t understand
08/10/2011 Oleg
I installed it, made protection, configured php, mysql, phpmyadmin, I don’t need anything else yet, so this appeared
Access forbidden!
You don"t have permission to access the requested directory. There is either no index document or the directory is read-protected.
If you think this is a server error, please contact the webmaster.
Error 403
localhost
10.08.2011 23:38:10
Apache
I can log into phpmyadmin, but I don’t know what to do. help please.
08/11/2011 Oleg
And I forgot to add that everything worked until I restarted Apache
08/22/2011 Victor
Oleg, in the settings there is a ban on reading a directory without an index file or somewhere else there is a ban.
But you have to look at everything in place, it’s so difficult to say why access to the directory is denied.
09/21/2011 maxim
changed the password to root and the login method set cookies
Now when I log into the admin panel it gives an error
Error
MySQL said: Documentation
#1130 - Host "localhost" is not allowed to connect to this MySQL server
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
02.09.2012 Anton
Hello! I encountered the same problem as Dmitry
"If in the file
/xampp/apache/conf/extra/httpd-xampp.conf
remove the phpmyadmin parameter from the line
.....
That's it... phpmyadmin becomes unavailable at all. Neither from the locale, nor from outside. Everything you need is written down in the hosts file. the paths are all correct."
please tell me what to do and what and how to fix it so that everything works
01/15/2013 zenon
great article, thanks
02/20/2013 Gannibal
Please tell me how to correctly remove those that are highlighted with arrows on the screen.
Http://radikal.ru/F/s45.radikal.ru/i108/1302/a0/2868efa2d6f6.jpg.html
02/10/2014 Crooked article
After setting the password, there is no access to the admin panel. It’s 10 times easier to move the hamrr folder to another directory while NOT using phpmyadmin. And no one in life will find her.
07/26/2016 Evgeniy
A typical absolutely useless article, written by someone unknown and for what purpose!
"Go to the Privileges tab..." But there is NO SUCH TAB in PHPmyadmin!!! NO AND THAT'S ALL! Why the hell write such articles???
That's why I started looking for materials because this stupid program, in principle, does not contain anything similar to access settings in the interface. And the author of this “article” did not help at all.
When creating a new website project, a webmaster has to solve many problems regarding the content to be posted, its display, ensuring easy navigation through sections, etc. At the same time, making changes is complicated by the need to correlate them with databases located on the hosting server. This entails a significant waste of time and effort. In order to minimize costs and facilitate changes, many specialists use the http://localhost/Tools/phpMyAdmin tool, which allows them to simulate server space on a PC. As an example we can consider shell software Denver and one of additional tools PhpMyAdmin.
So, Denver is a program that allows you to create a local server directly on your computer, and localhost/Tools/phpMyAdmin is one of the tools (a set of special PHP scripts) used to provide access to databases located on this server. With their help, you can manage and make changes to the site project databases, without the need to study special teams MySQL.
Benefits of technology
The use of such technology allows you to obtain a number of advantages:
Once the site project is ready, it can be transferred from local server to a real one, and start fully using the site.
As for the PhpMyAdmin tool itself, its use eliminates the need to learn MySQL commands and makes the process of making changes to databases simple and accessible even for users with limited programming knowledge.
How to log in and use localhost/Tools/phpMyAdmin
To use the database tool, simply go to http://localhost/Tools/phpMyAdmin.
This will open the tool's interface, which allows you to create, modify, and delete new tables in databases using intuitive commands. These tables will be used to directly place the site content. The tool's interface is quite simple and clear, all important elements are labeled, so it will be easy to understand even for a beginner.
Why doesn't http://localhost/Tools/phpMyAdmin open?
When creating your first serious web project, sooner or later you will be faced with working on databases, and MySQL technology in particular. Database server MySQL data Great for small and developing projects at an early stage of development due to the ease of working with it. The phpMyAdmin system makes the work even easier, which provides the user with access and a graphical interface for working with the database, managing tables, creating backup copies and many others useful functions. Of course, this speeds up the workflow and frees up developers’ time for more useful things.
How to login to phpMyAdmin on Denwer?
The most popular one for Windows is called Denwer, and as you might have guessed, it includes phpMyAdmin. But there is one problem that users encounter all the time: in phpMyAdmin how to log into the admin panel?
If you use "Denver", then for quick login In the admin panel of the phpMyAdmin control system, you can add a special link to your browser bookmarks: http://localhost/Tools/phpMyAdmin.
But soon you will have to upload the site to real hosting, and if you plan to implement your development to the end, study the following questions in advance: how to work with the phpMyAdmin interface? How to log into the administrative control panel?
Instructions for logging into ISP Manager and CPanel
If your remote web hosting uses the ISPmanager control panel, then log in using the links in the example below:
If the CPanel panel is installed, then questions about phpMyAdmin, how to log into the host will not create problems. Use the following link: https: //your_site.com:2083/3rdparty/php My Admin/ - you will need to remove the spaces.
Instead of the words “your site.com”, use the domain of your resource, purchased and attached to the hosting in advance. If you do not own the required domain on at the moment, you can authorize by IP address, in which case in phpMyAdmin you will know exactly how to enter.
If you use some unpopular control panel or don’t know whether it exists at all, try adding the name of the control panel after the slash in the address of your site, or specify this word as a subdomain - this combination is used by some hosters.
To connect to phpMyAdmin you can use the already created database u1234567_default(Where u1234567— your hosting login), which is automatically created when you order hosting. Access details for this database are given in the article.
Attention Database u1234567_default is created only when ordering tariff plans from “Host-0” and higher. If you ordered tariff plan“Host-Lite”, and then upgraded it to a higher one, this database is not created. You need to create the database yourself according to the instructions:
I can't login to phpMyAdmin
To log into phpMyAdmin you need to use database user login and password. Do not confuse the database user login and password with the hosting service login and password (u1234567).
If the database password is not suitable, you can change it to a new one using the instructions:
How to create, delete or modify a table in the phpMyAdmin database?
Attention! Editing the database may cause your site to not work correctly. Before making changes, create a backup of your site or contact the developers.
How to add new table to the database?
