How Discuz solves the error run_sql_error during installation

The functions implemented in this article

Solution to the run_sql_error error reported by discuz when installing MySQL8.0

If you want to see the solution results directly, go directly to the problem solving directory

Problem environment

1. VMware virtual machine
   

2. ##Centos7.3

3. PHP7.0

4. MySQL8.0

5. NGINX1.14

6. Discuz3.4

   
   

Problem restoration

The local environment is PHP5.6 MySQL5.6 without any problems when installing discuz.

The following problem occurs on the centos of the virtual machine. The MySQL table cannot be created and the installation error is reported.

The host uses Xsheel and Ftp

Due to the inconvenience of taking screenshots from the centos terminal, all environment modifications below will be performed on xshell and accessed directly on the host machine.

About configuring how to use xsheel to connect to a virtual machine

The connection mode is NAT, and the tools have been installed

Use xsheel to connect, in The virtual machine uses ifconfig to check the IP address

and then connects. You need to enter the account password. The account password is your virtual machine account password

The connection looks like the following if the connection is successful. You can enter PHP -v to view the PHP version information

The other one is ftp, because it is needed To transfer something, I also used the host's ftp to connect to the virtual machine. In the same way, enter the IP address and the port is 22

After the connection is successful, you can obtain the virtual machine file

Solution to the problem

The root of this problem is the MySQL version. The version supported by discuz is PHP5.3. But all database files are created on MySQL5.5. Therefore, the character set will be garbled.

At this time, we open /etc/my.ini. This is the default configuration. Don’t worry about the mysqldump below. That is the situation where MySQL master-slave replication was configured before to have data. configured.

Add the following code to this file

init_connect='SET NAMES utf8'

default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci

default_authentication_plugin=mysql_native_password

All storage engines in mysql8.0 are innodb , so the default setting here is innodb

The character set is set to utf8

default_authentication_pluginModify the password verification plug-in

After the above configuration, let’s test it

Test

Enter http://192.168.254.130/forum/install/index.php in the address bar, and then continue to the next step. Enter your database account password here

Click to confirm, and there will be no error report

Just visit the forum OK

Viewing the database

The number of tables viewed is 292 in total

Then go to the locally installed database and check that the number is also 292

Summary

The above is the solution for discuz's installation error in MySQL8.0. Although it only requires a few lines of configuration, it cannot be solved in a short time.

The above is the detailed content of How Discuz solves the error run_sql_error during installation. For more information, please follow other related articles on the PHP Chinese website!