安装Mysql

centos7 安装mysql5.7

#切换yum源为国内镜像（切换国内镜像要速度快）

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

yum makecache

#安装

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

rpm -ivh mysql57-community-release-el7-11.noarch.rpm

yum install -y mysql-community-server

 

 

#查看mysql状态
service mysqld status

# 启动mysql
service mysqld start

# 停止mysql
service mysqld stop

# 重启mysql
service mysqld restart

 

mysql5.7常用命令

#登录mysql
mysql -hhost -u username －p password

#创建用户
CREATE USER 'userName'@'host' IDENTIFIED BY 'password';

#为用户授权
grant all privileges on *.* to 'username'@'host' identified by 'password';

#刷新权限

flush privileges;

 

#忘记数据库密码解决方案

在my.ini中添加

skip-grant-tables

重启mysql：service mysqld restart
免密登录：mysql -u root
进入数据库：use mysql

修改root密码：

update user set authentication_string = password('新密码'),password_last_changed=now() where user='root';