单启动多个mysql实例mysqld_multi配置
1. 创建 mysqld_multi.conf 配置
[mysqld_multi] mysqld=/usr/bin/mysqld_safe mysqladmin=/usr/bin/mysqladmin user=AAA password=BBB [mysqld3306] port=3306 datadir=/var/lib/mysql3306 socket=/var/lib/mysql3306/mysql.sock pid-file=/var/lib/mysql3306/mysqld.pid log-error=/var/log/mysqld_3306.log user=mysql symbolic-links=0 character-set-server = utf8 skip-name-resolve server-id=123 log-bin=mysql-bin log-slave-updates binlog-ignore-db=mysql binlog-ignore-db=test binlog-ignore-db=information_schema binlog-ignore-db=performance_schema replicate-ignore-db=mysql replicate-ignore-db=test replicate-ignore-db=information_schema replicate-ignore-db=performance_schema master-connect-retry=10 max_connections=1000 sort_buffer_size = 300M join_buffer_size = 300M key_buffer_size = 300M innodb_buffer_pool_size = 4000M query_cache_size=200M
注意, 要配置 user 和 password, 一会将要创建一个帐号用于 mysqld_multi.
2. 初始化空数据库
sudo mysql_install_db --datadir=/var/lib/mysql3306 --user=mysql
3. 启动实例
/etc/init.d/mysqld_multi start mysql3306
4. 修改 root 密码
修改 root 密码要用到 /usr/bin/mysql_secure_installation 脚本, 但这个脚本默认是通过 /var/run/mysql.sock 本地连接. 所以不对, 你需要修改它.
make_config() { echo "# mysql_secure_installation config file" >$config echo "[mysql]" >>$config echo "user=root" >>$config echo "host=127.0.0.1" >>$config echo "port=3306" >>$config esc_pass=`basic_single_escape "$rootpass"` echo "password='$esc_pass'" >>$config #sed 's,^,> ,' < $config # Debugging } 4. 创建管理帐号
GRANT SHUTDOWN ON *.* TO 'AAA'@'localhost' IDENTIFIED BY 'BBB';
正文到此结束
热门推荐
相关文章
近期评论
-
文章和留言都翻到11页了 没有OOM
-
-
朋友，翻页到11页，及以后，会出现OOM，无法访问
-
-
搞个gitee的项目
-
-
版本号是多少，你可以下载哪个代码仓库，jdk选1.8 直接跑就行
-
-
-
Loading...
![[HBLOG]公众号](https://www.liuhaihua.cn/img/qrcode_gzh.jpg)
