准备工作:下载安装包(MySQL-5.5.44-1.el6.x86_64.rpm-bundle.tar)
下载地址:https://downloads.mysql.com/archives/community/
1. 查看该系统是否已存在mysql和mariadb数据库,如果已存在则删除
# yum list | grep mysql
# yum remove -y mysql*
# yum list | grep mariadb
# yum remove mariadb-libs.x86_64
2. 解压,并安装
# tar -C /tmp/mysql -xvf MySQL-5.5.44-1.el6.x86_64.rpm-bundle.tar;
# yum install /tmp/mysql/*.rpm
3. 启动mysql服务
# service mysql start
4. 设置mysql root用户的密码
# mysqladmin -u root password '密码'
5. 登录,并设置远程ip地址可连接
# mysql -uroot –p密码
mysql> use mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'IP地址' IDENTIFIED BY '密码' WITH GRANT OPTION;
(生产环境忌用 > GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION;)
mysql> exit
6. 重启数据库,使远程可连接生效
# service mysql restart
7. iptables配置文件中新增3306端口开放,并重载配置
# echo "-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT" >> /etc/sysconfig/iptables
# service iptables reload
注意:如果重载失败,重启系统即可(# reboot)
8. 其他
修改密码
# mysqladmin -u root -pOldPassword password new-password
版本5.7.33
cat /var/log/mysqld.log | grep password
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY "***";
flush privileges;
use mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '***' WITH GRANT OPTION;
select host, user, authentication_string, plugin from user;
#导出数据
docker run -it -v $(pwd)/lib:/data mysql:5.6.37 \
sh -c "mysqldump -h192.168.18.5 -uroot -p*** -t database_name --tables table_name > /data/table_name.sql"
#导入数据
cat /data/table_name.sql | mysql -h**** -uroot -p***
cat /data/table_name.sql | mysql -uroot -p**** db_name