时间:2021-07-01 10:21:17 帮助过:5人阅读
再在本地下载,再上传 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar
安装的过程如果和mariadb包有冲突,如果要有先卸载
- rpm -qa|<span style="color: #0000ff;">grep</span> mariadb
查看已安装的mariadb包
- rpm -e --nodeps mariadb-libs-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span><span style="color: #000000;">.el7.centos.x86_64
- rpm </span>-e --nodeps mariadb-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span><span style="color: #000000;">.el7.centos.x86_64
- rpm </span>-e --nodeps mariadb-devel-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span>.el7.centos.x86_64
依次先后安装
- rpm -ivh mysql/mysql-community-common-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
- rpm </span>-ivh mysql/mysql-community-libs-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
- rpm </span>-ivh mysql/mysql-community-client-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
- rpm </span>-ivh mysql/mysql-community-server-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span>.el7.x86_64.rpm
- <span style="color: #000000;">[mysqld]
- character</span>-set-server=<span style="color: #000000;">utf8
- [mysql]
- default</span>-character-set =<span style="color: #000000;"> utf8
- [mysql.server]
- default</span>-character-set =<span style="color: #000000;"> utf8
- [mysqld_safe]
- default</span>-character-set =<span style="color: #000000;"> utf8
- [client]
- default</span>-character-set = utf8
- <code class="hljs"><span class="zh-hans"> 查看修改后的效果<br></span></code>
- SHOW VARIABLES LIKE <span style="color: #800000;">‘</span><span style="color: #800000;">character%</span><span style="color: #800000;">‘</span>;
- mysqld --initialize --user=<span style="color: #000000;">mysql
- 如有必要指定路径可以加上下面的参数
- </span>--basedir=/usr/local/mysql --datadir=/data/mysql<br><br><em>root 用户随机密码保留在/var/log/mysqld.log 文件中</em>
- <span style="color: #000000;">systemctl start mysqld (启动mysql)
- systemctl restart mysqld (重启mysql)
- systemctl status mysqld (查看状态)</span>
- mysql -u root -p (使用刚才的随机密码)
或者 使用下面命令初始化mysql,则不需要密码登录
- mysqld --initialize-insecure --user=<span style="color: #000000;">mysql
- mysql </span>-u root --skip-<span style="color: #000000;">password
- alter user </span><span style="color: #800000;">‘</span><span style="color: #800000;">root</span><span style="color: #800000;">‘</span>@<span style="color: #800000;">‘</span><span style="color: #800000;">localhost</span><span style="color: #800000;">‘</span> identified by <span style="color: #800000;">‘</span><span style="color: #800000;">pwd456</span><span style="color: #800000;">‘</span>;
如果无法登录,再修改/etc/my.cnf 文件 加入以下参数
- skip-grant-tables
再 systemctl restart mysqld (重启mysql) 就可以无密码登录了,修改密码
- update user set authentication_string=password(<span style="color: #800000;">"</span><span style="color: #800000;">pwd456</span><span style="color: #800000;">"</span>) where user=<span style="color: #800000;">"</span><span style="color: #800000;">root</span><span style="color: #800000;">"</span><span style="color: #000000;">;
- flush privileges;</span>
- log-bin=mysql-<span style="color: #000000;">bin
- server</span>-<span style="color: #0000ff;">id</span>=<span style="color: #800080;">1</span>
- --------<span style="color: #000000;">下面可以忽略
- binlog</span>-ignore-db=<span style="color: #000000;">information_schema
- binlog</span>-ignore-db=<span style="color: #000000;">mysql
- </span>-----------------------
- GRANT FILE ON *.* TO replicate@<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.xx</span><span style="color: #800000;">‘</span> IDENTIFIED BY <span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
- GRANT REPLICATION SLAVE,RELOAD,SUPER ON </span>*.* TO replicate@<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.xx</span><span style="color: #800000;">‘</span> IDENTIFIED BY <span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
- 查看状态
- SHOW MASTER STATUS \G;</span>
- log-bin=mysql-<span style="color: #000000;">bin (非必须项,当slave需要同步的时候才必须)
- server</span>-<span style="color: #0000ff;">id</span>=<span style="color: #800080;">2</span><span style="color: #000000;">
- log_slave_updates </span>= <span style="color: #800080;">1</span><span style="color: #000000;">
- read_only </span>= <span style="color: #800080;">1</span><span style="color: #000000;">
- slave</span>-skip-errors =<span style="color: #000000;"> all
- slave</span>-net-timeout = <span style="color: #800080;">60</span>
- --------<span style="color: #000000;">下面可以忽略
- binlog</span>-ignore-db=<span style="color: #000000;">information_schema
- binlog</span>-ignore-db=<span style="color: #000000;">cluster
- binlog</span>-ignore-db=<span style="color: #000000;">mysql
- replicate</span>-<span style="color: #0000ff;">do</span>-db=<span style="color: #000000;">ufind_db
- replicate</span>-ignore-db=mysql
- change master to master_host=<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.01</span><span style="color: #800000;">‘</span>,master_user=<span style="color: #800000;">‘</span><span style="color: #800000;">replicate</span><span style="color: #800000;">‘</span>,master_password=<span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span>,master_log_file=<span style="color: #800000;">‘</span><span style="color: #800000;">mysql-bin.000001</span><span style="color: #800000;">‘</span>, master_log_pos=<span style="color: #800080;">760</span>;
查看 slave 状态
- <span style="color: #000000;">START SLAVE;
- SHOW SLAVE STATUS \G;</span>
可以看到
- <span style="color: #000000;">Slave_IO_Running: Yes
- Slave_SQL_Running: Yes</span>
参考
mysql的安装 参考 https://jingyan.baidu.com/article/93f9803f010d8fe0e56f555e.html
MYSQL-5.7.20的安装和主从配置(rpm安装包)
标签:unity roo local variable 改密码 emc alter for log