Missing PHP extensions?
I have been in touch with the guys in my website server company and they told me that everthing is set up and should be running. Unfortunately, I cannot find a solution. I tried to make a clean installation, and it does not get on. The with old an new version. The difference is with the messages that appear. When I install the 3.04 version the message that appears is:
This program requires the PHP 'mysql' extension.Please ask your hosting provider (or server administrator) to install missing PHP extension(s).
If I install the 3.14 version the message that appears is:
mysqli: error setting character set utf8mb4: Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/)
The guy from the server told me to change the charset for each database, then change the charset for each table of the database, and then the charset for each column of each table of each database. He suggested to use the following code:
# For each database:ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;# For each table:ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;# For each column:ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Sorry, this all looks impossible for me.
Is there anything I can do? Should I change server? Can you suggest me a server where the database will definetely work?