mysql配置

mysql -u root -p
SHOW VARIABLES LIKE 'char%';

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

lc-messages-dir= /usr/share/mysql
语句后添加 character-set-server=utf8 语句

在终端输入 sudo vim /etc/mysql/conf.d/mysql.cnf 命令打开mysql.cnf配置文件，添加代码：default-character-set=utf8

重启mqsql
/etc/init.d/mysql restart

 

use mysql；

select User,authentication_string,Host from user ;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'jbkj@123' ;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.17.0.1' IDENTIFIED BY 'root' ;

set password for root@localhost = password('jbkj@123');

监听端口
/sbin/iptables -I INPUT -p tcp --dport 8066 -j ACCEPT

firewall-cmd --zone=public --add-port=8066/tcp --permanent

 

docker run -d -p 8893:80 -p 3305:3306 \
-e USER="root" -e PASSWD="password" \
-e BIND_ADDRESS="false" \
-e SMTP_HOST="163.177.90.125 smtp.exmail.qq.com" \
-v /data/zbox/:/opt/zbox/ \
--name zentao-server \
idoop/zentao:latest
---------------------