在mysql安装前如果之前安装过mysql,就要把mysql全部都删除。
1,下载mysql安装包
rpm -ivh http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2,安装mysql
yum install -y mysql-server
3,设置开机启动Mysql
systemctl enable mysqld.service
4,检查是否已经安装了开机自动启动
systemctl list-unit-files | grep mysqld
5,设置开启服务
systemctl start mysqld.service
6,查看MySql默认密码
grep 'temporary password' /var/log/mysqld.log
7,登陆MySql
mysql -u root -p
8,设置密码的验证强度等级
set global validate_password_policy=LOW;
9,设置密码位数
set global validate_password_length=7;
10,设置mysql密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
11,开启远程登录,授权root远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123' WITH GRANT OPTION;
12,命令立即执行生效
flush privileges;
这样mysql就已经基本安装完成。
设置mysql的编码格式为utf8
修改mysql的my.cnf文件中的字符集键值
在[client]下追加:
default-character-set=utf8
在[mysqld]下追加:
character-set-server=utf8
在[mysql]下追加:
default-character-set=utf8
mysql的相关操作命令
1,重启MySql服务
service mysqld restart
2,启动MySQL服务
systemctl start mysqld
3,查看MySQL服务状态
systemctl status mysqld
4,关闭MySQL服务
systemctl stop mysqld
原文链接:https://blog.csdn.net/Zeng__Yi/article/details/103256584