1. mysql service cannot be started. The following error is reported: 1 ). decompress the mysql Server Directory and add my. the INI file contains the following content: [mysqld] # setbasedirtoinstallationpath, e.g ., c: mysql # Set it to the MYSQL installation directory basedirc: toolmysql5617win32 # setdatadirtolocationofdat
1. mysql service cannot be started. The following error is reported: 1 ). decompress the mysql Server Directory and add my. the INI file contains the following [mysqld] # set basedir to installation path, e.g ., c:/mysql # set it to the MYSQL installation directory basedir = c:/tool/mysql5617win32 # set datadir to location of dat
1. mysql service cannot be started and error 1067 is reported
Solution:
1). decompress the mysql Server Directory and add a new my. ini file. The content is as follows:
[Mysqld] # set basedir to installation path, e.g ., c:/mysql # set it to the installation directory basedir = c:/tool/mysql5617win32 # set datadir to location of data directory, # e.g ., c:/mysql/data or d:/mydata/data # Set it to the MYSQL data DIRECTORY datadir = c: /tool/mysql5617win32/datacharacter_set_server = utf8character_set_client = utf8 [WinMySQLadmin] Server = c: /tool/mysql5617win32/bin/mysqld.exe user = root # No password = 123456 # No password is used here # The above is the configuration of WinMySQLadmin [Client] user = root # No password is used here = 123456 # It seems useless here
2) input below dos: SC delete mysql
3) restart the computer
4). mysqld install MySQL -- defaults-file = "Your unzipping root directory \ my. ini", prompt: Service successfully installed.
5). net start mysql
6). Prompt that the startup is successful
2. the root password is changed to 10061.
1). 10061 is generally caused by the failure to start the mysql service. Check whether the service has been started.
2). If this error is still reported after the firewall is started, disable the firewall (required by the remote server)
3) at this time, there should be no 10061
3. the root password is changed to 10045.
1). Run cmd to enter the bin in the mysql decompression directory, for example, cd c:/tool/mysql5617win32/bin.
2) input: mysql-u root-p
3). enter password: Press enter directly (because there is no password at the beginning)
4). use mysql; probably displays: changed table success;
5). update user set password = PASSWORD ("123465") where user = 'root'; changed 3 may appear; updated 3 may appear.
6). flush privileges;
7) then open the client and enter your above 123456 to connect successfully.