福田祥菱箱货_房地产资讯_杭州seo推广服务_搜索引擎优化名词解释

1.安装新版mysql前，需将系统自带的mariadb卸载

rpm -qa|grep mariadb        //查找mariadb的rpm包

rpm -e mariadb-libs-5.5.56-2.el7.x86_64        //卸载mariadb包

2.去官网下载对应mysq包https://downloads.mysql.com/archives/community/

3.解压下载包，将目录下所有解压出的rpm包进行安装

4.配置/etc/my.cnf文件，可以设置端口，路径等

vim /etc/my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/logs/mysql.err
pid-file=/usr/local/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0

5.启动mysql 服务修改初始密码并且可以远程登录

systemctl start mysqld

grep 'temporary password' /var/log/mysqld.log        //在日志查看root初始密码

mysql -uroot -p -P端口

set password=password('你要修改的密码');

flush privileges;

grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option;

flush privileges;

6.验证远程登录以及设置开机启动