A
A
Alexander Degtyarev2017-01-05 20:39:14
PHP
Alexander Degtyarev, 2017-01-05 20:39:14

How to change connection encoding mapping from utf8mb4_general_ci?

Can't change utf8mb4_general_ci connection encoding mapping to utf8_general_ci. When trying to connect in phpmyadmin, a message appears at the bottom of the panel "You connected as 'root' without entering a password, which is typical for the default MySQL account settings. The MySQL server started with these settings is open to intrusions. You should correct this error by setting a password for the user 'root'."
It is not even possible to log in under another user, he immediately enters the panel as root and without a password. Through user accounts, I wanted to put a password on root - the whole phpmyadmin fell, I had to reinstall it.
Deployed everything through xampp. PHP version is 5.6.28. MySQL version is 4.5.1.
All tables with the necessary coding stand and all DB created too. Help, I'm working on a js stack (in general, divinely both client and server) and now I need to do work on this bastard bundle with eternal coding problems. Reviewed a bunch of solutions, nowhere is suitable for solving the problem.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey, 2017-01-05
@alexdeg

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question