发布时间:2019-06-24作者:cui阅读(4726)
新买了阿里云环境,linux选用Centos7.6 数据库mysql5.7.26
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
# rpm -qa|grep mariadb mariadb-libs-5.5.60-1.el7_5.x86_64 # rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 rpm -qa|grep mariadb
mkdir mysql rz mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm(若在有网情况下可执行yum install libaio)
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
systemctl start mysqld.service set password=password('123456@@');
CREATE USER 'sunld'@'%' IDENTIFIED BY '123456@@'; GRANT ALL PRIVILEGES ON *.* TO 'sunld'@'%';flush privileges;
GRANT ALL ON *.* to root@'118.171.229.88' IDENTIFIED BY '密码'; FLUSH PRIVILEGES;
// 检查是否已经是开机启动 systemctl list-unit-files | grep mysqld // 开机启动 systemctl enable mysqld.service
[client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] character-set-server=utf8mb4 collation-server = utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' //查看字符集 SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
如果字符集没有修改成功
连接数据执行:
set names 'utf8mb4';
版权属于: 技术客
原文地址: https://www.sunjs.com/article/detail/12071834b38947f28cb94d3ed38aa51f.html
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。