Home  >  Article  >  Database  >  What should I do if a 2003 error occurs when phpmyadmin is logged in?

What should I do if a 2003 error occurs when phpmyadmin is logged in?

coldplay.xixi
coldplay.xixiOriginal
2020-08-17 14:29:542615browse

Solution to the 2003 error when phpmyadmin logs in: 1. Find [$cfg['Servers'][$i]['auth_type'] = 'config'] and change it to [**= 'http'] ;2. Fill $cfg['Servers'] with the correct code.

What should I do if a 2003 error occurs when phpmyadmin is logged in?

【Related tutorial recommendations: phpmyadmin

Solution to the 2003 error when phpmyadmin logs in:

Method 1: Find$cfg['Servers'][$i]['auth_type'] = 'config';

Change to$cfg['Servers'][$i]['auth_type'] = 'http';

You need to enter your username and password when accessing

Method 2: "#2003 - The server is not responding"Solution to the PHPMYADMIN login problem

Problem description:

Prompt when logging in to PHPMYADMIN#2003 -The server is not responding

1 Other local php mysql programs are running normally;

2 phpmyadmin used to run normally, but an error occurred recently.

Solution:

Find /libraries/config. The following code segment in the default.php file:

Copy content 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)

Replace $cfg['Servers'][$i]['password' ] Fill in the corresponding correct password.

Method three: $cfg['Servers'][$i]['port']Configuration, Then I found it and added the port number (the default is 3306).

However, it still failed. So I went to the service to see if MySQL was started, and found that it was not started. It turned out that the problem was here.

Manual startup, the following error occurs: The system specified path cannot be found

Enter the BIN directory under DOS

C:\Program Files\MySQL\MySQL Server 5.4\bin

Enter under DOS mysqld- nt -remove Delete the service

Then enter mysqld-nt -install Install the service

The following prompt appears:

The service already exists!
The current server installed: E:\Program Files\MySQL\MySQL Server 5.4\bin\mysqld-nt MySQL

This is because I have installed MySQL before and failed to uninstall it.

How to clean up mysql?

When you uninstall the old MYSQL database service from your computer, first stop the MYSQL service in the WINDOWS service. Go to the Add and Delete program in the control panel to delete it. However, if you cannot completely delete the MYSQL service, you must clear your MYSQL service in the registry.

There are several places:

1. HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL directory deletion

2. HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\ Eventlog\Application\MySQL directory deletion

3, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL directory deletion ControlSet001, ControlSet002 in the registry, not necessarily 001 and 002, may be ControlSet005, 006 When deleting, just delete them all

Check if there is a my.ini file in the C:\WINDOWS directory, delete it

Just reinstall it again.

Related learning recommendations: Programming video

The above is the detailed content of What should I do if a 2003 error occurs when phpmyadmin is logged in?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn