deepin安装mysql

2019-08-25  本文已影响0人  AsGroot
  1. 安装mysql
sudo apt-get install mysql-server mysql-client

登陆后查看数据库当前编码:SHOW VARIABLES LIKE 'character%'

  1. 修改默认编码为utf-8
    修改/etc/mysql/my.cnf (默认安装路径下) (标签下没有的添加,有的修改)
[mysqld]
character_set_server=utf8

[mysql]
default-character-set= utf8

[client]
default-character-set = utf8
  1. 启动命令
sudo systemctl stop mysql.service
sudo systemctl start mysql.service
sudo systemctl restart mysql.service
sudo systemctl status mysql.service
上一篇 下一篇

猜你喜欢

热点阅读