Shulou(Shulou.com)06/01 Report--

This article mainly explains the "Ubuntu mysql compilation garbled solution", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "Ubuntu mysql compilation garbled solution" bar!

My solution is to add the following two lines to the / etc/my.cnf file:

[client] default-character-set=utf8 [mysqld] default-character-set=utf8

Note that this file does not necessarily exist. You need to copy / install the original file / support-files/my-medium.cnf to / etc/ and rename it.

Need to restart Ubuntu mysql

Deactivation: sudo / usr/local/mysql/bin/mysqladmin shutdown

Enable sudo / usr/local/mysql/bin/mysqld_safe-user=mysql &

View Ubuntu mysql encodings

After sudo / usr/local/mysql/bin/mysql is enabled

Mysql > show variables like 'character%'

Variable_name Value

Character_set_client utf8

Character_set_connection utf8

Character_set_database utf8

Character_set_filesystem binary

Character_set_results utf8

Character_set_server utf8

Character_set_system utf8

Character_sets_dir / usr/share/mysql/charsets/

Note that after this change, the original database built by Ubuntu mysql does not seem to work (uncertain). Try to back up the new database so that there will be no garbled code.

Screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt='Click here to open new window\ nCTRL Mouse wheel to zoom in/out';} "onmouseover=if (this.width > screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\ nCTRL Mouse wheel to zoom in/out';}" onclick=if (! this.resized) {return true } else {window.open ('https://cache.yisu.com/upload/information/20210521/367/443009.gif');}" onmousewheel=return imgzoom (this); "alt=" / >

Thank you for your reading, the above is the content of "Ubuntu mysql compilation garbled solution", after the study of this article, I believe you have a deeper understanding of the problem of Ubuntu mysql compilation garbled solution, the specific use of the need for you to practice and verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.