Troubleshooting of series of problems installed on the mysql server, mysql Server

Troubleshooting of series of problems installed on the mysql server, mysql Server

1. mysql service cannot be started and error 1067 is reported

Note: do not include other symbols (such as "_" and other symbols) in the file name after the mysql server is pressurized. use only English letters and numbers, I did not carefully verify whether the started service will be affected by the symbol. However, if the service fails to be started twice, I changed the file name to start the service successfully. You can refer to this practice for reference.

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 MYSQL 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/data
Character_set_server = utf8
Character_set_client = utf8
[WinMySQLadmin]
Server = c:/tool/mysql5617win32/bin/mysqld.exe
User = root # It seems useless here
Password = 123456 # It seems useless here

# The above is the configuration for setting WinMySQLadmin
[Client]
User = root # It seems useless here
Password = 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.

 

How to install mysql Server

First download the windows version of MySQL from the official MySQL website www.mysql.com. Download an Msi installation package. Double-click the installation package. The installation process is divided into the following steps:
(1) first, the welcome page is displayed. Click NEXT to enter the Setup Type dialog box.
(2) MySQL provides three installation modes: The Type option is standard installation, the Complete option is full installation, and the Custom option is Custom installation. Select Custom and click Next. The Custom Setup dialog box is displayed.
(3) Click Change to Change the installation directory to C: \ MySQL. click NEXT.
(4) After confirming the installation, click the Install button to start the installation.
(5) The MySQL.com Sign-Up dialog box will pop Up during installation.
(6) Select the Skip Sign-Up option and click Next.
(7) after the installation is complete, the Wizard Completed dialog box is displayed.
(8) choose Start> MySQL> MySQL5.0> Configure the MySQL server now from the Start menu, and click Finish to complete the installation process and start configuring the MySQL service.
..............................
After writing, you can

How to install mysql Server

I also think that my colleague installed me with the MySQL client and entered the information you need to query. I also installed MySQL on the computer to connect to your computer and tell him your computer ip address, writing a query command is basically complete!