Modify mysql8.0 in Linux system The default encoding of 0 is utf8
chnhbhndchngn 2022-02-13 08:18:12 阅读数:829
modify
mysql8.0
mysql
linux
default
Linux Installed mysql8.0 Some of the default codes are Latin , Not and store Chinese , View encoding
mysql> show variables like '%character%';
Need to use root user , modify /etc/my.cnf file
stay [mysqld] Add below
collation_server = utf8_general_ci
character_set_server = utf8Then save to exit
Restart mysql Program ,
service mysqld restartStart again mysql client , View encoding
copyright：author[chnhbhndchngn]，Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130818111059.html
- Comparing Maven with gradle, does gradle use more?
- dubbo v2. Version 6.6 queue capacity is full exception
- How does message in netty solve the problem of sticking and unpacking
- Java project, with GC files, how to analyze or know whether optimization is needed?
- Introduction to redis [9] redis6 core features
- Redis[8] Redis6. Cluster cluster with high availability of X nodes
- Redis [7] sentinel for redis node high availability monitoring
- Redis [6] master slave replication + read write separation
- Redis [5] key's expiration time deletion strategy, LRU algorithm and persistence configuration
- Redis [4] case introduction + cache breakdown, cache avalanche and cache penetration
- Redis [3] interview question: design distributed locks + code to realize native distributed locks
- Redis [2] redis configuration and distributed lock introduction
- Introduction, data structure and application scenario of redis [1]
- Java programmers learn deep learning djl get started 9 using style transfer learning in cifar-10 dataset
- Java programmers learn deep learning djl get started 8 using style transfer learning
- Java programmers learn deep learning djl get started 7 using pytoch engine
- Mybatisplus configuring multiple data sources (II)
- Mybatisplus configuring multiple data sources (I)
- Unity cannot find the Android SDK builder component!!!
- An error occurred during the initialization of Android application accessing Xiaomi login SDK in the application
- MySQL visual add-on program wampserver64
- Design a calculator with Java and realize four mixed operations, and save the operation history in the folder
- Five mixed operations of Java arithmetic problems
- User mode and kernel mode communication, ioctrl and copy_ from_ User, what scenarios are used
- The Linux server requests the interface. You can ping the IP, but curl times out.
- Java is a kind of keyword synchronized lock. What does optimization include?
- What are the native RMIS in Java?
- How to understand channel in Java NiO???
- How many types of redis data are there? What are they?
- Background retry gave up
- What values can redis's string data type store?
- What values can redis's list data type store?
- What values can be stored in redis's set data type?
- What values can be stored in the hash data type of redis?
- What values can be stored in the Zset data type of redis?
- What can redis do with its string data type?
- What can redis list data types do?
- What can be done with redis's set data type?
- What can be done with the hash data type of redis?
- What can be done with the Zset data type of redis?
- What are the main application scenarios of redis's string data type?
- What are the main application scenarios of redis's list data type?
- In performance optimization, what tools can be used to troubleshoot online exceptions of Java applications or analyze application code bottlenecks?
- What are the main application scenarios of redis's set data type?
- What are the main application scenarios of redis's hash data type?
- What are the main application scenarios of the Zset data type of redis?
- How can redis be applied to counter scenarios?
- How does redis apply to caching scenarios?
- How can redis be applied to session caching scenarios?
- How can redis be applied to full page caching scenarios?
- How can redis be applied to lookup table scenarios?
- Docker building online office -- onlyoffice (III)
- Docker building online office -- onlyoffice (II)
- Docker enters the container and the docker container copies files with the host
- Docker building online office -- onlyoffice (I)
- Tomcat configures SSL and domain name
- The springboot interface receives parameters and supports both JSON and form
- Springboot exception redirection
- mysql5. Version 7 SQL_ mode=only_ full_ group_ By problem
- AOP custom annotation of spring boot and parameter parsing