When entering phpmyAdmin
, ask for a login and password. Where to take it from? I’m new, please explain in more detail.
Answer 1, Authority 100%
Login: root
Password: root
or:
Login: MySQL
Password: MySQL
Well, or sometimes even so
Login: root
Empty password
In general, PhpmyAdmin asks access to your database.
Accordingly, the username and password must be specified for the used database user.
Or standard i indicated above.
if it gives an error
2002 Cannot Log In To The MySQL Server
Edit the file phpmyadmin / config.inc.php , replacing this line:
$ cfg ['servers'] [$ i] ['host'] = 'localhost';
on this:
$ CFG ['Servers'] [$ i] ['host'] = '127.0.0.1';
Full Listing
& lt;? php
$ CFG ['blowfish_secret'] = 'BA17C1EC07D65003'; // Use Here A Value of Your Choice
$ i = 0; $ i ++;
$ CFG ['Servers'] [$ i] ['auth_type'] = 'Cookie';
$ CFG ['Servers'] [$ i] ['Host'] = '127.0.0.1';
$ CFG ['Servers'] [$ i] ['port'] = '3307'; // MySql Port.
? & gt;
You may have edited MySQL configuration file so that it starts on another port. In this case, the new port must be specified in the phpMyAdmin configuration file (see the last line of the listing above).
In addition, the configuration file itself config.inc.php must lie in the root folder phpMyAdmin.
Before the start of PhpMyadmin MySQL must already be launched. Check if the corresponding process is in the task manager.
Check if the user has, on behalf of which you try to log in, relevant rights.
If all of the above did not help, mysql himself mowed crookedly. Try to reinstall it.
Answer 2, Authority 33%
In Ubuntu, we do this:
$ cd / etc / mysql /
$ sudo vim debian.cnf
And here is the answer:
Automatically Generated for Debian Scripts. Do Not Touch!
[client]
Host = Localhost.
User = Debian-Sys-Maint // This is a user
password = utjaxfyqfsyssjoz // is a password
socket = /var/run/mysqld/mysqld.sock< ;br>
[mysql_upgrade]
Host = Localhost.
User = Debian-Sys-Maint // This is a user
password = utjaxfyqfsyssjoz // is a password
socket = /var/run/mysqld/mysqld.sock
Answer 3, Authority 8%
This thing has helped me in the settings:
Login: root.
Empty password
Thank you