install MariaDB on debian 8
sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db sudo ad »
使用Python备份mysql
#!/usr/bin/env python import osimport time username = root password = 123456 hostname = localhost filestamp = time.strftime('%Y-%m-%d') »
Linux,使用mysqldump导出数据时对sql文件进行压缩
mysqldump -h192.168.1.222 -ubackup -pbackup kds trank | gzip > $backupdir/back.sql.gz »
Shell,mysql开启远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; 允许局域网内192.168.访问 GRANT ALL PRIVILEGES ON *.* TO 'root'@' »
Linux,查看mysql执行sql时资源占用
打开profiling 功能：set profiling = 1； 执行要分析的sql； show profiles； SHOW profile CPU,BLOCK IO io FOR query Query_ID； 当前查询 show processlist; »
MySQL,ERROR 1045 (28000): Access denied for user 'root'@'localhost'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' # /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --sk »
Linux,shell脚本mysql的使用
#!/bin/sh mysql -uroot -p123456 <use test; select * from test where a=10000; »