phpmyAdmin , ask for a login and password. Where to take it from? I’m new, please explain in more detail.
Answer 1, Authority 100%
Well, or sometimes even so
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';
$ CFG ['Servers'] [$ i] ['host'] = '127.0.0.1';
& 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: