MariaDB charset issue

from https://community.centminmod.com/th...db-mysql-default-character-set-collation.398/

at very bottom of guide

Changing existing database's character set data can be tricky as it can screw up existing database's existing non-latin1 character set based data if there is any if you're existing database came from a latin1 based MySQL server originally. If it did come from a latin1 based MySQL server original, leave your default at latin1 instead of UTF8.

If you must change your database from latin1 to UTF8, do it on a separate test VPS server first to make sure it works and always backup and download a copy of your database before changes are made.

You're on your own for changing existing database's character sets which involve 4 levels of changes from server level, database level, table level and column level as outlined in multi-page documentation at http://dev.mysql.com/doc/refman/5.5/en/charset-syntax.html. The guide at https://community.centminmod.com/th...db-mysql-default-character-set-collation.398/ outlines just the first level for server level defaults for newly created MySQL databases.

 

oh much easier if existing database is empty, just set the defaults for mysql as outlined at https://community.centminmod.com/th...db-mysql-default-character-set-collation.398/ and delete existing database and re-create it

 

did you restart mysql server as instructed ?

you should see this in SSH window when you type

Code:

mysqladmin var | grep -E 'character|collation' | tr -s ' '

should see

Code:

| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |

 

because that is your server mysql client connection character set hence only character_set_client connection reports as latin1

tried logging out of SSH and back in and try

 

what does your /etc/my.cnf look like ?

i have no such problems

Code:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.38-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

Are you even using Centmin Mod + MariaDB MySQL ? as I notice your mysql client prompt says mysql> and not MariaDB>

 

Then it should be working AFAIK

 

start a new thread so others can search and find the answer too

 

oh i meant for both questions for deleting database and domain have separate new threads

 

strange that kind of setup is only required for MySQL <5.5 versions and not for MySQL 5.5+