• mysql 生产环境多实例配置

    Linux 超过558 views围观 0条评论
      多实例启动 /usr/bin/mysqld_multi –defaults-extra-file=/etc/mysql/cfg3307.cnf –log=/var/log/mysql/mysql_3307.log start /usr/bin/mysqld_multi –defaults-extra-file=/etc/mysql/cfg3308.cnf –log=/var/log/mysql/mysql_3308.log start /usr/bin/mysqld_multi –defa...
  • mysql 多实例密码破解

    Linux 超过441 views围观 0条评论
    适用于环境的 1.停止相应实例 /usr/bin/mysqld_multi –defaults-extra-file=/etc/mysql/cfg3309.cnf –log=/var/log/mysql/mysql_3309.log stop 2.修改相应实例配置文件 [mysqld3309] skip-grant-tables  #增加一条跳过权限检测 "/etc/mysql/cfg3309.cnf" 39L, 1682C 3.开启实例 var...
  • mysql 一种crash的解决方法

    Linux 超过810 views围观 0条评论
    报错日志如下,数据库无法起来 Thread pointer: 0x0Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong…stack_bottom = 0x0 thread_stack 0x48000/usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x7f1...