How to change Server Charset in phpmyadmin

cpfan

• November 09, 2020 11:37

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

  • November 09, 2020 18:38

  You may find the below link useful.

  0
• 

  keat63

  • November 09, 2020 18:38

  I found this.

  0
• 

  cpfan

  • November 09, 2020 19:00

  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.

  0
• 

  cpfan

  • November 09, 2020 19:14

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

  0
• 

  cPRex Jurassic Moderator

  • November 09, 2020 20:10

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

  0

Please sign in to leave a comment.