Linux安装MySQL服务(统信UOS)

安装mysql

下载mysql-apt-config_0.8.24-1_all.deb
https://dev.mysql.com/downloads/repo/apt/

dpkg -i mysql-apt-config_0.8.24-1_all.deb
apt-get update
aptitude install mysql-server

安装libmysqlclient-dev

aptitude install libmysqlclient-dev

修改root密码

mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过命令cat /var/log/mysqld.log的方式找到root默认密码

mysql -u root -p

use mysql;
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql@123456';
flush privileges;

此时发现密码不生效，且全局免密，搜索资料后

检查mysql.user表记录：检查字段plugin、authentication_string(此字段有可能不为空)

select plugin,authentication_string from mysql.user where user = 'root' ;

将插件改为非auth_socket

alter user root@localhost identified with mysql_native_password by 'root';

操作完成后，此时默认密码是root
需要重新执行修改密码的操作

配置默认编码为utf8

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

character_set_server=utf8
init_connect='SET NAMES utf8'