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

This article mainly introduces the solution to the 2003 error in phpmyadmin login, which is very detailed and has a certain reference value. Interested friends must finish reading it!

The solution to the 2003 error in phpmyadmin login: 1, find [$cfg ['Servers'] [$I] [' auth_type'] = 'config'] to change to [* * =' http']; 2, add the correct code to $cfg ['Servers'].

The solution to a 2003 error in phpmyadmin login:

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

Phpmyadmin used to run normally, but recently there was an error.

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.

Manual startup 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.

The above is all the contents of this article entitled "the solution to the 2003 error in phpmyadmin login". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.