安装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'