![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
tjjingpan
这个作者很懒,什么都没留下…
展开
-
windows mysql备份数据库及清除过期数据(bat脚本)
查看数据库使用的存储引擎MariaDB [(none)]> show engines \G;*************************** 1. row *************************** Engine: CSV Support: YES Comment: Stores tables as CSV filesTransac...原创 2018-11-27 11:33:07 · 463 阅读 · 0 评论 -
mariadb 10.3 主从配置 主主配置
1,修改mariadb-server增加这两个配置server-id=22log-bin=mysql-bin2,增加复制用户和相应权限CREATE USER 'slave'@'%' IDENTIFIED BY 'slave';GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' WITH GRANT OPTION;flush privileges;3,查看主库的状态MariaDB [(none)]> show mas...原创 2020-11-20 15:32:21 · 576 阅读 · 0 评论 -
centos 8 mysql8安装
安装mysql官网https://dev.mysql.com/downloads/找到yum repo.执行yum localinstall https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpmyum install mysql mysql-server启动mysql服务systemctl start mysqld修改mysql root用户名密码ALTER USER ...原创 2020-11-05 13:30:27 · 146 阅读 · 0 评论