燕郊 网站开发,室内设计网站排行榜前十名知乎,怎么修改wordpress模板文件,湛江建设工程造价信息网文章目录 一、检查是否安装过MySQL二、上传安装包三、安装MySQL3.1 安装mysql依赖3.2 安装mysql-client3.3 安装mysql-server 四、启动MySQL五、配置MySQL5.1 修改密码#xff08;1#xff09;查看密码#xff08;2#xff09;登陆#xff08;3#xff09;设置复杂密码1查看密码2登陆3设置复杂密码4更改mysql密码策略5设置简单密码 5.2 设置MySQL允许其他机器登陆root账号1进入msyql库2查询user表3修改user表把Host表内容修改为%4刷新5退出 一、检查是否安装过MySQL
[mallmall ~]$ rpm -qa | grep mysql
[mallmall ~]$ rpm -qa | grep mariadb
[mallmall ~]$ rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps二、上传安装包
01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm
04_mysql-community-client-5.7.16-1.el7.x86_64.rpm
05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
mysql-connector-java-5.1.27-bin.jar三、安装MySQL
3.1 安装mysql依赖
[mallmall mysql]$ sudo rpm -ivh 01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
[mallmall mysql]$ sudo rpm -ivh 02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
[mallmall mysql]$ sudo rpm -ivh 03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm3.2 安装mysql-client
[mallmall mysql]$ sudo rpm -ivh 04_mysql-community-client-5.7.16-1.el7.x86_64.rpm3.3 安装mysql-server
[mallmall mysql]$ sudo rpm -ivh 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm可能会报缺少依赖的错误执行下面命令即可 [mallmall mysql]$ sudo yum install libaio 四、启动MySQL
[mallmall mysql]$ sudo systemctl start mysqld五、配置MySQL
5.1 修改密码
1查看密码
[mallmall mysql]$ sudo cat /var/log/mysqld.log | grep password2登陆
mysql -uroot -p password3设置复杂密码
mysql set passwordpassword(Qs23zs32);4更改mysql密码策略
mysql set global validate_password_length4;
mysql set global validate_password_policy0;5设置简单密码
mysql set passwordpassword(123456);5.2 设置MySQL允许其他机器登陆root账号
1进入msyql库
mysql use mysql2查询user表
mysql select user, host from user;3修改user表把Host表内容修改为%
mysql update user set host% where userroot;4刷新
mysql flush privileges;5退出
mysql quit;
