mysql笔记

目录

1service启动

2.linux登录mysql修改密码授权远程登录

3.日志清理

4.设置锁超时

5.导入导出

6 导入导出mysql

1service启动

windos
mysql -u root -p
exit;
net start mysql
net stop mysql
/usr/local/mysql/support-files/mysql.server start

重启服务：service mysql restart
停止服务：service mysql stop
启动服务：service mysql start
查看服务：service mysql status
systemctl unmask mysql.service
service mysql start

2.linux登录mysql修改密码授权远程登录

su - mysql
cd /usr/local/mysql/bin
登录：./mysql -u root -p    
修改密码：alter user 'root'@'localhost' identified by 'youpassword'; 

3.日志清理

show binary logs;
purge binary logs to 'mysql-tb-bin.000005';

4.设置锁超时

SHOW VARIABLES LIKE 'innodb_lock_wait_timeout';
SET innodb_lock_wait_timeout=5;

5.导入导出

mysql --local-infile=1 -uroot -p10288536qweQWE
SHOW GLOBAL VARIABLES LIKE '%secure%';
show variables like 'datadir';

6 导入导出mysql

Load  data infile '/var/lib/mysql-files/ai_label_dim_20211.csv' into table ai_label_dim fields terminated by '|' optionally enclosed by '\"' escaped by '"' lines terminated by '\r\n';
select * from  dim_sv_classify_info into outfile '/var/lib/mysql-files/dim_sv_classify_info.csv' fields terminated by '|' optionally enclosed by '\"' escaped by '"' lines terminated by '\n';