SOLVED How to change Server Charset in phpmyadmin

[cpfan]

Hello,

How can I change Server Charset in phpmyadmin? I googled but did not find a proper solution.
I have root access.

Thanks in advance

 

[kodeslogic]

You may find the below link useful.

Setting Character Sets and Collations

 

[keat63]

I found this.

Setting Character Sets and Collations

Changing from the default character set and collation.

mariadb.com

Hope its of some use.

 

[cpfan]

I tried them before by adding these two lines in my.cnf file, but it doesn't work. Here is my.cnf contents:

[client]
character_set_server='uft8'
character_set_database='utf8'

I also tried this:

[client]
character_set_server=uft8
character_set_database=utf8

When I restart mysql service and check it again, it's still latin1. But when I manually change these two variables in phpmyadmin GUI, it works (I know it's temporary and works until mysql restarts).

When I add these two lines within [mysqld] part in my.cnf, mysql service cannot restart and it returns error, so I should remove or comment them.

 

[cpfan]

I did fix it by using this link: Change MySQL default character set to UTF-8 in my.cnf?

Thanks all

 

[cPRex]

I'm glad you were able to get that fixed, @cpfan !!!