记录mysql的安装过程, 包括 卸载原有的mysql与mariadb, 安装mysql, 配置mysql, 添加用户与分配权限等.
1, 卸载原有的mysql 与 mariadb
1.1 卸载mariadb
a,查看系统已有的mariadb
rpm -qa|grep mariadb
b,卸载mariadb
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
1.2 卸载mysql
a,查看系统已有的mysql
rpm -qa | grep -i mysql
b,卸载mysql
rpm -e mysql-community-server-5.7.17-1.el7.x86_64
2 安装mysql
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
以上三步可能比较耗时, 取决于网速
3 启动mysql并且设置mysql
systemctl start mysqld.service
systemctl status mysqld.service
出现active(running表示启动成功
3.1 设置mysql的信息
a,从启动日志中,找到root的初始密码
grep "password" /var/log/mysqld.log
b,进入mysql
mysql -uroot -p
c,重设密码(不重设密码,不可用, 密码要求: 大小写字母,数字,符合)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
3.2 添加用户与分配数据库权限
添加用户格式: CREATE USER 'username'@'host' IDENTIFIED BY 'password';
授权格式: GRANT privileges ON databasename.tablename TO 'username'@'host';
比如: 添加用户test,并且添加操作数据库test_qsql_219的权限
CREATE USER 'test'@'10.10.32.11' IDENTIFIED BY 'Iot.123456';
GRANT ALL ON test_qsql_219.* TO 'test'@'10.10.32.11';
4 安装的最后一步
安装的最后一步: 否则会自动更新yum
yum -y remove mysql57-community-release-el7-10.noarch