The solution to the inability of phpmyadmin to log in and browse the contents of the database with root
This article mainly introduces the solution that phpmyadmin can not log in with root and can not browse the contents of the database. It has a certain reference value, and friends who need it can refer to it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.
Phpmyadmin cannot log in with root (username and password are correct)
Resolve:
See if the mysql client can log in (what I encounter is that I can't log in). If I can't log in, change the root password and then log in. Log in after phpmyadmin refreshes the page.
Phpmyadmin cannot browse the contents of the database after entering the page. There will be an error # 1146-Table 'phpmyadmin.pma_recent' doesn't exist on the left
Resolve:
Find /-name create_tables.sql 'finds the location of this table, and this error will not be reported if the table is imported into phpmyadmin for the tables needed to turn on the advanced features of phpmyadmin.
At the bottom of the phpmyadmin login page, "failed to control the user connection defined in the configuration file" is displayed, and the entry page will also be displayed.
Resolve:
Find /-name config.inc.php 'find the location of the file cp / etc/phpmyadmin/config.inc.php. / config.inc.php.bak' my file is in this location. Vim config.in.php 'edit the file to find $cfg [' Servers'] [$I] ['controluser'] and $cfg [' Servers'] [$I] ['controluser']. The value of the first one is changed to the mysql user name, and the latter is changed to the corresponding password. Like the following: $cfg ['Servers'] [$I] [' controluser'] = 'root' $cfg ['Servers'] [$I] [' controlpass'] = '123456789'
Refresh the phpmyadmin and it will not display.
Missing mcrypt extension. Please check the PHP configuration
1. Sudo apt-get install libmcrypt4 php5-mcrypt
2. Find /-name mcrypt.so
3.vim / etc/php5/apache2/php.ini
Extension=path/mcrypt.so
4.sudo / etc/init.d/apache2 restart
Thank you for reading this article carefully. I hope the editor can share the solutions that phpmyadmin cannot log in with root and can not browse the contents of the database. At the same time, I also hope that you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!
