1.mysql Service failed to start, report 1067 error
Solution:
1. The MySQL server to extract the directory of the new add a My.ini file, the contents are as follows
[Mysqld]
# set Basedir to installation path, e.g., C:/mysql
# set for MySQL installation directory
basedir=c:/tool/mysql5617win32
# Set DataDir to location of data directory,
# e.g., c:/mysql/data or D:/mydata/data
# set to MySQL's catalog
datadir=c:/ Tool/mysql5617win32/data
character_set_server = UTF8
character_set_client = UTF8
[winmysqladmin]
server=c:/tool/mysql5617win32/bin/mysqld.exe
user=root #这里感觉没有用
password=123456 # It doesn't feel right here
#以上是设置WinMySQLadmin的配置
[Client]
user=root #这里感觉没有用
password=123456 #这里感觉没有用
2). DOS Input: SC delete MySQL
3). Reboot the computer
4. Mysqld Install MySQL--defaults-file= "Your solution to the root directory \my.ini", Hint: Service successfully installed.
5). net start MySQL
6). Prompt to start successfully
2. Modify root password hint 10061
1). 100,611 is the MySQL service does not start to cause, go to the service to see if it has started
2. If you start or report this error, then shut down the firewall (required by the remote server)
3). There should be no 10061 at this time.
3. Modify root password hint 10045
1. cmd into the MySQL extract directory under the bin, similar to: CD C:/tool/mysql5617win32/bin
2). Input: Mysql-u root-p
3. There is a enter password: Do not direct carriage return (because there is no password at first)
4). Use MySQL; Probably will appear: Changed table success;
5. Update user set Password=password ("123465") where user= ' root '; Probably will appear changed 3;updated 3
6). Flush privileges;
7 and then open the client input you above 123456 can connect successfully