When entering phpmyadmin
, ask for username and password. Where does it come from? I am new, please explain in more detail.
3 answers
Login: root
Password: root
Or:
Login: mysql
Password: mysql
Well, or sometimes even so
Login: root
Password is empty
In general, phpMyAdmin asks for access to your database.
Accordingly, the login and password must be specified for the created database user.
Or standard, which I have indicated above.
If it gives an error
2002 Cannot log in to the MySQL server
Edit the phpmyadmin / config.inc.php file, replacing this line here:
$cfg['Servers'][$i]['host'] = 'localhost';
on this one:
$cfg['Servers'][$i]['host'] = '127.0.0.1';
Full listing
<?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 ?>
You may have edited the MySQL configuration file to run on another port. In this case, the new port must be specified in the phpMyAdmin configuration file (see the last line from the listing above).
In addition, the configuration file config.inc.php itself should be in the root folder of phpMyAdmin.
MySQL should already be running before starting phpMyAdmin. Check if there is an appropriate process in the task manager.
Check whether the user on whose behalf you are trying to log in has appropriate permissions.
If all of the above did not help, perhaps MySQL itself is crookedly up. Try reinstalling it.
- > 2002 Cannot log in to the MySQL server here displays this error - aaa
- @aaabbbccc, I updated my answer - VenZell
- <? php $ cfg ['blowfish_secret'] = 'ba17c1ec07d65003'; // use here a value of your choice $ i = 0; $ i ++; $ cfg ['Servers'] [$ i] ['auth_type'] = 'cookie'; ?> here is my config.inc.php file - aaa
- @aaabbbccc, then add the specified line before ?> - VenZell
- describe how the config.inc.php file should look like - aaa
In ubuntu 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 //Это пользователь password = uTjAXFyQFsySSJOZ //Это пароль socket = /var/run/mysqld/mysqld.sock<br> [mysql_upgrade] host = localhost user = debian-sys-maint //Это пользователь password = uTjAXFyQFsySSJOZ //Это пароль socket = /var/run/mysqld/mysqld.sock
This thing in the settings helped me: Login: root Password is empty
Thank
Protected by a member of the Spirit of the community ♦ Mar 18 at 14:42 .
Thank you for your interest in this issue. Since he collected a large number of low-quality and spam responses, which had to be deleted, now it’s necessary to have 10 reputation points on the site (the bonus for account association is not counted ).
Maybe you want to answer one of the unanswered questions ?
/etc/dbconfig-common
there is a filephpmyadmin.conf
and it contains login and password. If you wish, you can change them. - Zun Zunov