本月博客排行
年度博客排行
-
第1名
宏天软件 -
第2名
青否云后端云 -
第3名
龙儿筝 - gashero
- wallimn
- vipbooks
- benladeng5225
- wy_19921005
- fantaxy025025
- e_e
- zysnba
- ssydxa219
- sam123456gz
- javashop
- arpenker
- tanling8334
- kaizi1992
- xpenxpen
- wiseboyloves
- xiangjie88
- ranbuijj
- ganxueyun
- sichunli_030
- xyuma
- wangchen.ily
- jh108020
- lemonhandsome
- zxq_2017
- jbosscn
- Xeden
- luxurioust
- zhanjia
- lzyfn123
- forestqqqq
- ajinn
- nychen2000
- wjianwei666
- hanbaohong
- daizj
- 喧嚣求静
- mwhgJava
- silverend
- kingwell.leng
- lchb139128
- kristy_yy
- lich0079
- johnsmith9th
- jveqi
- java-007
- sunj
最新文章列表
Centos7下编译安装mariadb
https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.3.10/source/mariadb-10.3.10.tar.gz
https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.2.18/source/mariadb-10.2.18.tar.gz
https://mariadb.c ...
yum安装MariaDb10.2国内yum源配置
1、创建mariadb.repo
vim /etc/yum.repos.d/mariadb.repo
写入以下内容:
# MariaDB 10.2 CentOS repository list - created 2017-07-03 06:59 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mar ...
centos7 快速安装 mariadb(mysql)
从最新版本的linux系统开始,默认的是 Mariadb而不是mysql!
使用系统自带的repos安装很简单:
yum install mariadb mariadb-server
systemctl start mariadb ==> 启动mariadb
systemctl enable mariadb ==> 开机自启动
mysql_secure_install ...
MariaDB导出导入命令
导出:
mysqldump -h127.0.0.1 -P3306 -uroot -proot db>D:/db.sql
导入:
mysql -h127.0.0.1 -P3306 -uroot -proot -f db <D:/db.sql --default-character-set=utf8
mariadb 应用
1.官网 下载地址
https://downloads.mariadb.org/
2.启动停止命令
systemctl start mariadb ==> 启动mariadbsystemctl stop mariadb ==> 停止mariadbsystemctl enable mariadb ==> 开机自启动
3.配置 etc/my.cnf
character_ ...
mysql 删除记录时报错
在sql命令行,删除一条记录时,发现一个很奇怪的错误
下面的语句是可以正常执行的:
delete from t_mid_test_convention where convention_id=33;
但是下面的报语法错:
delete from t_mid_test_convention as mt2 where mt2.convention_id=33;
my ...
MariaDB主从复制配置实战
1,服务器安装:
搞两台虚拟机CentOS7 64位,IP分别为192.168.216.201、192.168.216.202
2,数据库安装:
参考官网yum安装:MariaDB
3,主服务器配置:192.168.216.201
> vi /etc/my.cnf.d/server.cnf
[mysqld]
log-bin=mysql-bin
...