HZero搭建目录(点击访问)----------------------
HZero搭建(1)- 域名映射
HZero搭建(2)- yum篇
HZero搭建(3)- docker篇
HZero搭建(4)- JDK篇
HZero搭建(5)- Nginx篇
HZero搭建(6)- Node篇
HZero搭建(7)- Git篇
HZero搭建(8)- Maven篇
HZero搭建(9)- Redis篇
HZero搭建(10)- Mysql篇
HZero搭建(11)- Jenkins篇
HZero搭建(12)- 数据初始化篇
需先安装Docker
拉取Mysql 镜像
docker pull registry.cn-hangzhou.aliyuncs.com/choerodon-tools/mysql:5.7.17
启动Mysql(先生成mysql目录)
docker run -d -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=root -v /hzero/data-server/mysql/mysql_data/:/var/lib/mysql/:rw -v /hzero/data-server/mysql/mysql_db.cnf:/etc/mysql/:rw --privileged=true 954
数据库配置
在 /hzero/data-server/mysql/mysql_db.cnf 下新建 my.cnf 文件,添加以下内容
[mysqld]lower_case_table_names = 1max_connections=1000innodb_log_file_size = 1Ginnodb_buffer_pool_size = 4Gkey_buffer_size = 521mtmp_table_size = 128Msort_buffer_size = 32Mread_rnd_buffer_size = 32Mjoin_buffer_size = 128mmax_allowed_packet = 256Mread_buffer_size = 16mcharacter_set_server = utf8
然后重启mysql
docker restart mysql
进入mysql 容器
docker exec -it mysql /bin/bash
登陆mysql
mysql -uroot -proot
创建用户
create user ‘hzero’@’%’ identified by ‘hzero’;
grant all on . to hzero@’%’;
flush privileges;
退出容器和mysql,都通过以下命令
exit