Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


You are here: Index > AMPPS > General Support > Topic : PhpMyAdmin Settings



Threaded Mode | Print  

 PhpMyAdmin Settings (3 Replies, Read 9654 times)
ManosP
Posted on # May 17, 2014, 9:55 am
Group: Member
Post Group: Newbie
Posts: 2
Status:
Hi. I am a new user to Ampps. It's fantastic and very simple.
I have the following question.

How can i set these values to phpmyadmin,

from:
collation_connection    utf8mb4_unicode_ci
collation_database    latin1_swedish_ci
collation_server    latin1_swedish_ci

to
collation_connection    utf8_unicode_ci
collation_database    utf8_unicode_ci
collation_server    utf8_unicode_ci

When i am going to change the value utf8mb4_unicode_ci to utf8_unicde_ci, it's auto change it back again to utf8mb4_unicode_ci.

IP: --   

PhpMyAdmin Settings
tidus
Posted on # May 18, 2014, 7:37 am | Post: 1
Group: Member
Post Group: Super Member
Posts: 1121
Status:
In your Mysql configuration, set the following

[mysqld]
default-character-set=utf8_unicode_ci

Restart your Mysql server afterwards for the changes to take effect.

   

Edited by tidus : May 18, 2014, 7:38 am

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

PhpMyAdmin Settings
ManosP
Posted on # May 18, 2014, 2:40 pm | Post: 2
Group: Member
Post Group: Newbie
Posts: 2
Status:
I am getting

[ERROR] mysql\bin\mysqld.exe: unknown variable 'default-character-set=utf8_unicode_ci'

i have mysql 5.6.17
IP: --   

PhpMyAdmin Settings
tidus
Posted on # May 19, 2014, 7:00 am | Post: 3
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Quote From : ManosP May 18, 2014, 2:40 pm
I am getting

[ERROR] mysql\bin\mysqld.exe: unknown variable 'default-character-set=utf8_unicode_ci'

i have mysql 5.6.17


Hi,

Okay. Try the add the following options in respective section.
Code

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8




Edited by tidus : May 19, 2014, 7:02 am

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 28, 2024, 5:01 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.024