In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
This article is about how to solve the problem of 2003 error in phpmyadmin. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.
Phpmyadmin has a 2003 error and the server is not responding: first change [$cfg ['Servers'] [$I] [' auth_type'] = 'config';] to [' http'], and then enter your user name and password when you access it.
A 2003 error occurred in phpmyadmin, and the server did not respond:
Method 1: find
$cfg ['Servers'] [$I] [' auth_type'] = 'config'
Change to
$cfg ['Servers'] [$I] [' auth_type'] = 'http'
You need to enter a user name and password when you visit
Method 2: the solution to the PHPMYADMIN login problem of "# 2003-server is not responding"
Problem description:
Prompt # 2003 when logging in to PHPMYADMIN-the server is not responding
1. Other local php+mysql programs are running normally
2. Phpmyadmin used to run normally, but there has been an error recently.
Solution:
Locate the following snippet in the / libraries/config.default.php file:
Copy the contents to the clipboard code:
$cfg ['Servers'] [$I] [' auth_type'] = 'config'; / / Authentication method (valid choices: config, http, HTTP, signon or cookie) $cfg [' Servers'] [$I] ['user'] =' root'; / / MySQL user$cfg ['Servers'] [$I] [' password'] ='; / / MySQL password (only needed with 'config' auth_type)
Add the corresponding correct password to $cfg ['Servers'] [$I] [' password'].
Method 3: $cfg ['Servers'] [$I] [' port'] configuration, find it, and add the port number (default is 3306)
However, it still failed.
So go to the service to see if MySQL started, and found that it did not start, the original problem is here.
Start manually with the following error:
The system specified path could not be found
Enter the BIN directory under DOS
C:\ Program Files\ MySQL\ MySQL Server 5.4\ bin
Enter mysqld-nt-remove to delete the service under DOS
Type mysqld-nt-install to install the service next
The following prompt appears:
The service already employees the current server installed: e:\ Program Files\ MySQL\ MySQL Server 5.4\ bin\ mysqld-nt MySQL
This is due to the fact that MySQL has not been uninstalled cleanly before.
How to clean up the mysql?
When you uninstall the old MYSQL database service from your computer, first stop the MYSQL service in the WINDOWS service. Then delete it in the add and delete program in the control panel, but you can't delete the MYSQL service completely, so you need to remove your MYSQL service from the registry.
There are several places:
1. Delete the HKEY_LOCAL_MACHINE\ SYSTEM\ ControlSet001\ Services\ Eventlog\ Application\ MySQL directory
2. Delete the HKEY_LOCAL_MACHINE\ SYSTEM\ ControlSet002\ Services\ Eventlog\ Application\ MySQL directory
3. The HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services\ Eventlog\ Application\ MySQL directory deletes the ControlSet001,ControlSet002 in the registry, not necessarily 001 and 002, but ControlSet005, 006 and so on. When deleting, you can delete all of them.
Check if there is a my.ini file in the C:\ WINDOWS directory and delete it
Just reinstall it again.
Thank you for reading! This is the end of this article on "how to solve the problem of 2003 errors in phpmyadmin". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!
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: 236
*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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.