Database MySQL multiple database service conflicts

First, the target name

Mysql

Second, the target version

Mysql-5.6.24-win32.1432006610.zip

Third, environmental information

System: Windows 7 Ultimate Edition

Firewall: Off-note: remote login will fail if the firewall does not shut down or does not allow columns.

Iv. severity and complexity of the problem

Severity: Very serious, directly causing the database to be unusable, and all applications associated with it are affected.

Complexity: Very complex, involving the installation of the database, the introduction of other installation applications, the problem is more obscure is not easy to find.

V. Description of the problem

(1)-When the program that relies on the database is opened, a pop-up error dialog box prompts the database "xxx @ XXX" to be inaccessible.

　　

There are many reasons why this is inaccessible in MySQL database, such as the server does not have remote access permission, user password error, and a series of reasons. The ' root ' @ ' localhost ' shows that I am logged in locally, but in fact this is an inaccessible hint that I intentionally made locally after I have maintained the MySQL database, because I have to do a good job of reproducing the original.

(2)-then access to the database in Navicat also has an unreachable error prompt. Initial judgment when the database service did not start caused.

(3)-Telnet to a server made with the Windows 7 Ultimate system and run the Command window with administrator privileges.

(4)-Switch to Mysql\bin directory, with mysql-u root-p log in the database, found that the previously set password can not be used, directly prompts access denied for user. Then I tried to log in without a password, and I found that I was able to enter MySQL, and that by using Select User (), my current login user was [email protected]. However, when querying a database with show databases, there is always only the Infromation_schema and test two databases, and the MySQL and other application databases in the directory are not displayed. And after setting mysqladmin-u root-p password password can not be modified, sad reminder.

(5)-start to fix the problem by uninstalling the service directly and then reinstalling the service, so I use net stop MySQL to stop the service and then use mysqld Remove to uninstall the service. I try to reinstall the service and then start the MySQL service and find that there are still only Infromation_schema and test two databases. So I started to think of the My-default.ini configuration file, and I started to try to find a variety of ways to configure My.ini, the most of the process of starting the MySQL service is 1067. The problem of light is going to ruin you, because you don't know where you're wrong. Here is a very vague question, can not be started is not necessarily my.ini problems, but also may be other problems, such as other software also installed and started the MySQL service, and we stopped and started a conflict service, but generally we can not find, only see it gave us 1067 of the error feedback. It took me 1 days to solve the problem and it was very silent.

(6)-Changed a machine, downloaded the latest MySQL 5.7.11 for Windows on the official website and then I installed it on my home computer, only Infromation_schema and test two databases. Finally have to use the original version of the Mysql-5.6.24-win32.1432006610.zip database decompression, without configuration My.ini directly using the default My-default.ini installation to start the MySQL service login can see MySQL this database, overjoyed.

(7)-Use Navicat test connection locally, change database MySQL using update user set host= '% ' where user= ' root '; flush privilideges; Update external access, at this time there is another problem is that I have a user in the users, host, localhost, this record will harm the local connection and remote access, so I deleted it will be able to access the normal.

(8)-The original database is re-added to the data directory, directly copy the other, note that MySQL, INFORMATION_SCHEMA, test and other original database do not copy, especially MySQL. The copy will find the database we copied to see, but the database can not be accessed, there will be inodb errors and other things.

(9)-the original database in the data directory in addition to the local user-related files are copied over the overwrite.

　　

(10)-Back to the original server, using Navicat Log on to the local, found to be able to login to the password-free version, and found the Zantao database, so found the problem is because this is called Zen Road software also started the MySQL service, this service for my installation of the service conflict, And I was aware of the other one when I signed in at the command window, which is a very cryptic conflict. MySQL itself is not very good to detect.

(11)-Stop the service and reconfigure my database, OK.

Database MySQL multiple database service conflicts