Centos上安装mysql

/ 技术 / 1541浏览

一、安装Jdk1.8

yum install -y java-1.8.0-openjdk-devel.x86_64
完成后查看版本
java -version

image-20200503101616346

二、安装mysql

下载mysql
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
安装repo
rpm -ivh mysql57-community-release-el7-10.noarch.rpm
安装mysql
#进入安装目录下
> cd /etc/yum.repos.d/
> yum install mysql-server
启动mysql
 systemctl start mysqld
进入
mysql -u root -p
报错
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
1. 暂时解决
mysql -h 127.0.0.1 -u root -p
2. 修改配置

三、进入mysql

修改初始化密码
>mysql alter user 'root'@'localhost' identified by '123';
开启远程连接
mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> flush privileges;
mysql> quit;
$ systemctl restart mysqld.service

image-20200503112919067