Shulou(Shulou.com)05/31 Report--

This article introduces you how to solve the problem of mysql 2003 errors, the content is very detailed, interested friends can refer to, hope to be helpful to you.

The solution to the mysql 2003 error: 1, find the "MYSQL" service in "computer"-> "Management"-> "Service", and start the service; 2, open cmd and execute the "mysqld.exe-install" command.

Operating environment of this article: Windows7 system, Mysql5.6, DELL G3 computer

How to solve the mysql 2003 error problem?

2003 error solution of connection failure in mysql

When using mysql database to create a new connection, a 2003-Can't connect to server on 'localhost' (10038) error will be reported. The main reason is that the MYSQL service has not been started, but the MYSQL service cannot be found in the computer-management-service. The main solution:

Method 1:

1. Find the bin folder under the installation path of mysql. For example, mine is: "E:\ dataBase\ mySQL\ bin"

2. Find the "mysqld.exe" executable file under the bin folder and double-click so that the mysql service can be found in the service.

3. In "computer"-"Management"-"Service", find the "MYSQL" service, start this service, and then go back to navcat for mysql, reconnect, and connect to ok.

Method 2: (this is a reference to a netizen's answer, but also very ok)

1. After completing the installation of Mysql5.6, when using mysql, open cmd and enter net start mysql to indicate that the service name is invalid and view the list of services. As a result, no mysql-related services can be found, which can be solved by the following methods.

Solution: 1. Open cmd and change to the bin directory of mysql (this needs to be found according to the location of mysql installation on your computer. The following is the mysql installation directory on my computer)

2. C:\ Program Files (x86)\ MySQL5.6\ bin > mysqld.exe-install

Service successfully installed.

3. C:\ Program Files (x86)\ MySQL5.6\ bin > net start mysqlMySQL service has been started successfully

4. Now open the list of services and you can see the mysql service. Then reconnect in navcat for mysql, and it is successful.

In addition, attach the commands commonly used in cmd:

Disk switching, for example, from disk C to disk D: "X:" + enter (X is the disk number) C:\ Users\ Administrator > ASSOC displays or modifies the file extension association. ATTRIB displays or changes file properties. BREAK sets or clears extended CTRL+C checks. BCDEDIT sets properties in the startup database to control startup loading. CACLS displays or modifies the access control list (ACL) of the file. CALL calls this one from another batch program. CD displays or changes the name of the current directory. CHCP displays or sets the number of active code pages. CHDIR displays or changes the name of the current directory. CHKDSK checks the disk and displays a status report. CHKNTFS displays or modifies the startup time disk check. CLS clears the screen. CMD opens another Windows command interpreter window. COLOR sets the default console foreground and background colors. COMP compares the contents of two or two sets of files. COMPACT displays or changes the compression of files on the NTFS partition. CONVERT converts FAT volumes to NTFS. You cannot convert the current drive. COPY copies at least one file to another location. DATE displays or sets the date. DEL deletes at least one file. DIR displays files and subdirectories in a directory. DISKCOMP compares the contents of the two floppy disks. DISKCOPY copies the contents of one floppy disk to another. DISKPART displays or configures disk partition properties. DOSKEY edits the command line, invokes the Windows command, and creates a macro. DRIVERQUERY displays the current device driver status and properties. ECHO displays a message or turns the command echo on or off. ENDLOCAL ends the localization of environment changes in the batch file. ERASE deletes one or more files. EXIT exits the CMD.EXE program (command interpreter). FC compares two files or sets of files and shows the differences between them. FIND searches for a text string in one or more files. FINDSTR searches for strings in multiple files. FOR runs a specified command for each file in a set of files. FORMAT formats the disk for use with Windows. FSUTIL displays or configures the properties of the file system. FTYPE displays or modifies the file types associated with the file extension. GOTO points the Windows command interpreter to a labeled line in the batch program. GPRESULT displays group policy information for the machine or user. GRAFTABL enables Windows to display the extended character set in graphic mode. HELP provides help for the Windows command. ICACLS displays, modifies, backs up, or restores the ACL of files and directories. IF performs conditional processing in a batch program. LABEL creates, changes, or deletes the volume label of a disk. MD creates a directory. MKDIR creates a directory. MKLINK creates symbolic links and hard links MODE to configure system devices. MORE displays the output screen by screen. MOVE moves one or more files from one directory to another. OPENFILES displays files opened by remote users for file sharing. PATH displays or sets the search path for executable files. PAUSE stops processing the batch file and displays information. POPD restores the last value of the current directory saved by PUSHD. PRINT prints a text file. PROMPT changes the Windows command prompt. PUSHD saves the current directory and then makes changes to it. RD deletes the directory. RECOVER recovers readable information from a damaged disk. REM records comments in a batch file or CONFIG.SYS. REN renames the file. RENAME renames the file. REPLACE replaces the file. RMDIR deletes the directory. SET, the advanced utility for ROBOCOPY copying files and directory trees, displays, sets, or deletes Windows environment variables. SETLOCAL began to change the localization of the environment with batch files. SC displays or configures services (background processing). SCHTASKS arranges commands and programs to run on a computer as scheduled. SHIFT adjusts the location of replaceable parameters in the batch file. SHUTDOWN causes the machine to shut down correctly either locally or remotely. SORT will enter the sort. START opens a separate window to run the specified program or command. SUBST associates a drive letter with a path. SYSTEMINFO displays the specific properties and configuration of the machine. TASKLIST displays all currently running tasks including the service. TASKKILL terminates a running process or application. TIME displays or sets the system time. TITLE sets the window title for the CMD.EXE session. TREE graphically shows the directory structure of the initiator or path. TYPE displays the contents of the text file. VER displays the version of Windows. VERIFY tells Windows to verify that the file is written correctly to disk. VOL displays the disk volume label and serial number. XCOPY copies files and directory trees. WMIC displays WMI information in the interactive command shell. On how to solve the problem of mysql 2003 errors to share here, I hope that the above content can be of some help to 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.