This problem is caused by too low PHP version + too high MYSQL version

MYSQL8.0+ version introduces a new character set utf8mb4　

Change the old utf8 alias to utf8mb3

The old PHP’s MYSQLND module does not include the new character set

 

So there will be

The solution is simple, just upgrade to a new PHP version

Official https://bugs.php.net/bug.php?id=74461

Written

 

[2018-05-02 12:13 UTC] [email protected]

[2018-05-02 17:37 UTC] macleo at outlook dot com

So the 7.0+ version is basically OK

 

 

 

Read More:

• Mysqli::stmt Fatal error: Call to a member function bind_param() on a non-object in …
• Navicat connected to Mysql error: Client does not support authentication protocol requested by server;
• [Solved] MySQL Error: Client does not support authentication protocol requested by server
• mysqli_ Error() has no return value (Fixed)
• [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
• [Solved] SQLSTATE[HY000] [2002] Connection refused to report an error when PHP connects to mysql in the docker container
• ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
• How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
• [Solved] Running in 64 bit mode with the 32 bit Oracle client installed
• Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
• Error [err] is reported when redirecting_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
• [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
• MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
• How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
• How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
• [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
• [Solved] Error Code: 2013. Lost connection to MySQL server during query
• How to Solve postgres Errror: ERROR #42883 operator does not exist: smallint ~~ unknown
• Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
• [Solved] pymysql.err.internalError: (1054, “Unknown column ‘LGD_xiaohong’ in ‘field list’”)