deepin15.4.1mysql_Deepin15.11mysql5.7安装与配置

deepin系统中&＃xff0c;默认的系统源&＃xff0c;使用apt-get install mysql-server会自动拉取mysql的分支海狮DB&＃xff0c;然后无法安装成功mysql5.7正确的版本&＃xff0c;LZ在这里也是几经波折&＃xff0c;实践了几次(其中包括了deb包安装&＃xff0c;apt-get安装&＃xff0c;压缩包源码安装&＃xff0c;但是效果都不尽人意)&＃xff0c;最后发现只需要更换系统的apt源即可。

1.卸载

sudo apt purge mysql-*

sudo rm -rf /etc/mysql/ /var/lib/mysql

sudo apt autoremove

2.换源

进入etc/apt/目录中&＃xff0c;备份sources.list文件(具体备份命令&＃xff0c;请自行百度&＃xff0c;LZ这里使用的是直接复制一个文件出来&＃xff0c;更改名字)。

执行命令&＃xff0c;修改文件内容&＃xff1a;

sudo vim /etc/apt/sources.list

#删除内容&＃xff0c;并添加以下内容&＃xff1a;

## Generated by deepin-installer

deb [by-hash&＃61;force] https://mirrors.tuna.tsinghua.edu.cn/deepin panda main contrib non-free

wq保存文件&＃xff0c;退出&＃xff0c;执行sudo apt-get update和sudo apt-get upgrade命令。

操作完成&＃xff0c;更换源成功。

3.安装mysql-5.7并修改密码

sudo apt-get install mysql-server mysql-client

sudo cat /etc/mysql/debian.cnf

Automatically generated for Debian scripts. DO NOT TOUCH!

[client]

host &＃61; localhost

#用户名密码

user &＃61; debian-sys-maint

password &＃61; VPgo7lfDrISsIP9u

socket &＃61; /var/run/mysqld/mysqld.sock

[mysql_upgrade]

host &＃61; localhost

user &＃61; debian-sys-maint

password &＃61; VPgo7lfDrISsIP9u

socket &＃61; /var/run/mysqld/mysqld.sock

> mysql -u debian-sys-maint -p VPgo7lfDrISsIP9u

> use mysql;

> update user set plugin&＃61;"mysql_native_password",authentication_string&＃61;password(&＃39;root&＃39;) where user&＃61;"root";

> FLUSH PRIVILEGES;

4.修改mysql中字符编码

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

# 在mysqld节点&＃xff0c;添加以下&＃xff1a;

character-set-server &＃61; utf8

重启mysql服务&＃xff1a;

sudo systemctl restart mysql.service

查看当前字符集

show variables like &＃39;char%&＃39;;

得到以下结果&＃xff1a;

&＃43;--------------------------&＃43;----------------------------&＃43;

| Variable_name | Value |

&＃43;--------------------------&＃43;----------------------------&＃43;

| 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/ |

&＃43;--------------------------&＃43;----------------------------&＃43;

修改成功。