Handling common errors during MySQL installation (summary sharing)

This article brings you relevant knowledge about mysql, which mainly organizes issues related to common error handling during installation, including failure to start processing, error 1053, Winwods installation initialization error, MySQL8 Unable to log in after installation, etc. Let’s take a look at it. I hope it will be helpful to everyone.

Recommended learning: mysql video tutorial

1. Unable to start processing, error 1053

Windows cannot start Mysql service error 1053: The service did not respond to the startup or control request in time

1.1 End the process

Handling method:
1. Type in the command line Enter the tasklist to view the process
2. Kill the process according to the process name
taskkill /f /t /im process name

1.2 Change the location of the network service

Server2012

Other win7 and win10 operating systems

1), Computer->Management->Local User And Group->Group double-click, the effect is as follows:

(2), double-click Administrators, and click Add, then click Advanced

(3), put NETWORK SERVICE added to Administrators group

1.3 Delete service

sc delete mysql57303307

Remember here, just reinstall Mysql and re-execute the 2-step operation (delete the original Mysql files and reinstall them all)
Another pitfall is that if it still cannot be started, remember to enable this service Windows Installer
Windows Installer is a general software distribution method for installing software.
By default, the service is started manually and needs to be opened in service management.
Right-click Start - Run - Enter "services.msc" - Windows Installer - Start

2. Winwods installation initialization error

Beginning configuration step: Writing configuration fileSaving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration fileBeginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
确定。

Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
确定。

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows serviceAttempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new serviceNew service added
Ended configuration step: Adjusting Windows serviceBeginning configuration step: Initializing database (may take a long time)Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.24...
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
Process for mysqld, with ID 2572, was run successfully and exited with code -1073741515.
Failed to start process for MySQL Server 8.0.24.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

Install VC_redist.x86 and execute OK

Enter gpedit. msc, open policy management

It works normally after enabling certificate update

Because some system images were built earlier and system updates cannot be performed, system patch packages need to be installed to complete vc Installation

4. Centos environment rpm initialization MySQL error

The openssl version provided by Centos7 by default is 1.0.2. Some php extensions or other software depend on versions 1.1 or above. If you pass If it is low, an error will be reported
libssl.so.1.1: cannot open shared object file: No such file or directory
There are also errors consistent with the above when executing openssl version. This is because the location of the openssl library is incorrect or not installed. Problems with versions 1.1 and above
If you want to upgrade the openssl version, you need to compile it manually. The error solution is very simple, just install it correctly.
Let’s talk about the specific compilation and installation steps using Centos7 as an example

–openssl version confirmation
[root@jeames ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
–Compile openssl
tar - xvf openssl-1.1.1g.tar.gz
cd openssl-1.1.1g
./config shared --openssldir=/usr/local/openssl --prefix=/usr/local/openssl
make && make install

–Configuration
After the compilation is completed, use openssl version to check the current openssl version number.
You will find that it is still 1.0.2 , so some additional configuration work needs to be done here.
[root@jeames openssl-1.1.1g]# more /etc/ld.so.conf
include ld.so.conf.d/*.conf
[root@jeames openssl-1.1.1g ]# echo “/usr/local/lib64/” >> /etc/ld.so.conf
[root@jeames openssl-1.1.1g]# ldconfig
Use openssl version again to verify the version ,
If it doesn’t work, you can try the following methods,
Execute them in sequence (first back up the old version, then create a soft connection from the installation location of the new version)
mv /usr/bin/openssl /usr/bin/openssl .old
ln -s /usr/local/openssl/bin/openssl /usr/bin/openssl
ln -s /usr/local/openssl/include/openssl /usr/include/openssl
echo "/usr/local/openssl/lib" >> /etc/ld.so.conf
ldconfig -v

4. Unable to log in after MySQL8 is installed

The first method:

1. Use the command to edit the /etc/my.cnf configuration file, namely: vim /etc/my.cnf or vi /etc/my.cnf
2. In Add skip-grant-tables under [mysqld], then save and exit
3. Restart the mysql service: service mysqld restart
4. Change the root user name
After restarting, execute the mysql command to enter the mysql command line
5. Modify the root user password. Note here that sometimes it will report that modification is not allowed. Just flush privileges first and then execute it.
update mysql.user set authentication_string=password('root') where user='root' ; --5.7 version
flush privileges;
6. Comment out skip-grant-tables in /etc/my.cnf, and then restart mysql, that is: service mysqld restart
Okay, here's the thing You can log in with the new root password!

The second method:

Under the mysql8 system, the following method applies (full path)
G:\mysql-8.0 .23-winx64\bin\mysqld --datadir=G:\mysql-8.0.23-winx64\data80323308 --console --skip-grant-tables --shared-memory

Then open another window and execute the following command
cd G:\mysql-8.0.23-winx64\bin

mysql> select user,host,authentication_string from mysql.user;
mysql> delete from mysql.user where user='root' ;
mysql> flush privileges; --Remember to refresh, If the prompt cannot be created
mysql> create user root@'%' identified with mysql_native_password by 'root';
mysql> grant all on . to root@'%' with grant option;
mysql> flush privileges;
mysql> drop user 'root'@'localhost';
mysql> flush privileges;
mysql> create user root@'localhost' identified with mysql_native_password by 'root';
mysql> grant all on . to root@'localhost' with grant option;
mysql> flush privileges;

Recommended learning: mysql video Tutorial

The above is the detailed content of Handling common errors during MySQL installation (summary sharing). For more information, please follow other related articles on the PHP Chinese website!