1.下载安装

cd /home

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm 

rpm -ivh mysql-community-release-el7-5.noarch.rpm 

yum install mysql-community-server

过程中多次提示Is this ok [y/N],输入y,回车即可

2.启动

service  mysqld  start

3.配置
(1).账户

mysql -u root 
//设置密码
mysql> set password for 'root'@'localhost' =password('密码');
//赋值权限
mysql> grant all privileges on *.* to root@'%'identified by '密码';
//刷新生效
mysql> flush privileges;

(2).编码

vim /etc/my.cnf

default-character-set = utf8

4.非安装后修改密码
(1).修改my.cnf

vim /etc/my.cnf

在[mysqld]最后一行加上skip-grant-tables
在这里插入图片描述

(2).重启mysql

service mysqld restart

(3).登录mysql后修改密码

mysql -u root
update mysql.user set authentication_string=PASSWORD('admin123') where User='root';
flush privileges;

(4).改回my.cnf,重启mysql

Logo

瓜分20万奖金 获得内推名额 丰厚实物奖励 易参与易上手

更多推荐