linux安装mysql

安装mysql

创建目录 mkdir /usr/mysql

下载mysql安装包 wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

使用yum安装 yum -y install mysql57-community-release-el7-10.noarch.rpm

安装mysql服务器 yum -y install mysql-community-server

安装完成后启动mysql 初始化配置 systemctl start mysqld.service

进入之前查看密码 grep “password” /var/log/mysqld.log

mysql -uroot -p 进入mysql 首次进入的密码为刚刚查看的密码

修改密码ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘new password’;

开启mysql远程访问grant all privileges on . to ‘root’@’%’ identified by ‘password’ with grant option;

刷新生效 flush privileges;