Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The solution to the inability of phpmyadmin to log in and browse the contents of the database with root

2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report