how to set collation_server and character_set_ server from utf8 to utf8mb4 and utf8mb4_unicode_ci?

48
January 12, 2019, at 03:20 AM

I have tried following this website https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4, but i can't able to find collation_server which is in my.ini mysql on windows 7.So i cannot modify it in my.ini.This is my result what i get as enter image description here

I appreciate who can help this working.

READ ALSO
How to concat_ws primarykey(id) and date in a new column on same table?(MySQL)

How to concat_ws primarykey(id) and date in a new column on same table?(MySQL)

I need add a new column named date_id by using concat_ws('-', curdate,id) on a same table, the id is a primarykey and auto_incrementHow to do this?

29
mysqldump fails with “Skipping dump data for table 'table1', it has no fields”

mysqldump fails with “Skipping dump data for table 'table1', it has no fields”

I'm running mysqldump from an older mysql databaseThe mysqldump is part of a mariadb distribution if it matters

32
Access denied for user 'root'@'localhost' Laravel / debian 18

Access denied for user 'root'@'localhost' Laravel / debian 18

I have a problem with laravel and mysqlIt is possible for me to php artisan migrate and seed my database

53