zuopiezia的博客

格式：mysql> set password for 用户名@localhost = password('新密码'); 例子：mysql> set password for root@localhost = password('123');

查看字符集SHOW VARIABLES LIKE 'character_set_%'; SHOW VARIABLES LIKE 'collation_%';查看某个数据库的字符集show create database DBbase； show create table DBtable；修改默认的在目录下面 /etc/my.cnf.d/client.cnf [client] default-cha...

#!/bin/bash DBPass=xxxx@2018 /usr/bin/expect << EOF set timeout 30 spawn mysql_secure_installation expect { "enter for none" { send "\r"; exp_continue} "Y/n" { send "Y\r" ; exp_continue}...