Connection failure in MySQL 2003 error resolution

Source: Internet
Author: User

When using the MySQL database, the new connection will be reported 2003-can ' t connect to server on ' localhost ' (10038) error, the main reason is that the MySQL service did not start up, but into: computer--management--services, Unable to find the MySQL service, the main solution:

Method 1:

1, find the MySQL installation path under the Bin folder, for example, my is: "E:\dataBase\mySQL\bin";

2, find the Bin folder "Mysqld.exe" executable file, double-click, so that the MySQL service can be found in the service.

3. In "Computer"-"administration"-"service", find the "MYSQL" service, start up the service, then go back to Navcat for MYSQL, reconnect, connect OK.

Method 2: (This is a reference to the answer of a netizen, also very OK)

1, after the completion of installation Mysql5.6, when using MySQL, open cmd, input net start MySQL, prompt service name is invalid, view the list of services, also results can not find MySQL related services, the following method to solve. Solution: 1, open cmd, switch to the MySQL bin directory (this need according to their own computer MySQL installation location to find, 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 that the list of services is open, you can see the MySQL service. Then re-connect to Navcat for MySQL and it succeeds.

Also, attach commands commonly used in CMD:

Disk switchover, such as C drive to D Drive: "x:" + ENTER (x for disk number) C:\USERS\ADMINISTRATOR>E:E:\>ASSOC displays or modifies the file extension association. ATTRIB Display or change file properties. Break sets or clears the extended CTRL + C check. BCDEDIT set the properties in the startup database to control the boot load. CACLS displays or modifies the Access Control List (ACL) of the file. Call calls this one from another batch program. The CD displays the name of the current directory or changes it. CHCP Displays or sets the number of active code pages. CHDIR displays the name of the current directory or changes it. CHKDSK checks the disk and displays the 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 color. COMP compares the contents of two or two sets of files. Compact displays or changes the compression of files on NTFS partitions. Convert converts a FAT volume to NTFS. You cannot convert the current drive. Copy copies at least one of the files to another location. Date Displays or sets dates. DEL deletes at least one file. DIR displays the files and subdirectories in a directory. DISKCOMP compares the contents of two floppy disks. DISKCOPY Copy the contents of one floppy disk to another. DISKPART displays or configures disk partition properties. DOSKEY Edit the command line, invoke the Windows command, and create a macro. Driverquery Displays the current device driver status and properties. echo Displays the message, or turns the command back on or off. Endlocal to end localization of environment changes in batch files. ERASE Delete one or more files. Exit CMD. EXE Program (command interpreter).            Fc Compares two files or two sets of files and displays the differences between them. Find searches one or more files for a text string. FINDSTR searches for strings in multiple files. For each file in a set of files, run a specified command. 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 that are associated with the file name extension. GOTO points The Windows command interpreter to a labeled row in the batch program. GPRESULT Displays Group Policy information for the machine or user. GRAFTABL enable Windows to display the extended character set in graphics mode. Help provides information about Windows commands. ICACLS displays, modifies, backs up, or restores ACLs for files and directories. IF a conditional process is performed in a batch program. Label creates, changes, or deletes a disk's volume label. MD to create a directory. MKDIR Create a directory. MKLINK Create Symbolic links and hard links mode to configure system devices. More display output per 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 the executable file. Pause stops processing of the batch file and displays information. POPD restores the previous value of the current directory saved by PUSHD. Print prints a text file. PROMPT Change Windows command prompt. PUSHD Save the current directory and make changes to it. RD Delete directory. The RECOVER recovers readable information from the damaged disk. REM records batch files or CONFIG. The comment in SYS. REN renames the file. RENAME Rename the file.     REPLACE   Replace the file. RMDIR Delete the directory. ROBOCOPY the Advanced utility set to copy files and the directory tree displays, sets, or removes Windows environment variables. SETLOCAL began to change the localization of the environment with batch files. SC Display or Configuration service (background processing). SCHTASKS schedule commands and programs to run on a single computer as scheduled. SHIFT adjusts the position of replaceable parameters in the batch file. SHUTDOWN allow the machine to shut down properly locally or remotely. Sort sorts the inputs. START opens a separate window to run the specified program or command. SUBST associates the drive letter with the path. SYSTEMINFO displays the specific properties and configuration of the machine. TASKLIST displays all currently running tasks that include the service. TASKKILL terminates a running process or application. Time displays or sets the system times. The TITLE sets CMD. The window caption of the EXE session. Tree displays the directory structure of the initiator or path graphically. TYPE Displays the contents of the text file. VER shows the version of Windows. VERIFY tells Windows to verify that the file is written to disk correctly. VOL Displays the disk volume label and serial number. XCOPY copies files and directory trees. WMIC displays WMI information in an interactive command shell.

  

Connection failure in MySQL 2003 error resolution

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.