ubuntu18.04安装mysql

ubuntu:18.04

mysql:5.7.32

1、安装MySQL

  sudo apt-get update;

       sudo apt-get install mysql-server

  

2、配置Mysql

  sudo mysql_secure_installation

  

3、检查状态

  systemctl status mysql.service

  

4、测试登录

  mysql -u root -p

  

5、问题:mysql不能显示中文

  cd /etc/mysql

  修改mysql.cnf,添加如下代码:

[client]
default-character-set = utf8

  cd mysql.conf.d

  修改mysqld.cnf,添加如下高亮代码:

[mysqld]
#
# * Basic Settings
#
character-set-server = utf8
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
port        = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir        = /tmp
lc-messages-dir    = /usr/share/mysql
skip-external-locking

  重启服务

  sudo service mysql restart

原文地址:https://www.cnblogs.com/kwoon/p/14182846.html