在mysql进行操作时候遇到的一些问题 Last_IO_Errno: 1593 Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different fo...

一机多实例下直接cd到目录这不需要跟端口 Mysql -h host -u root -p pwd -P3306 mysqldamdin shutdown mysqldadmin start show databases; create database dbXXX; use dbxxx; show tables; show columns fro...

注：最好在mysqld下面就添加，不要写到最后免去，有可能会出错，完了记得重启 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci

mycat 启动 连接 mysql -umycat -pmycat -P8066 -h127.0.0.1 -Dmycat 记得加-h127.0.0.1 druidparser 1 8066 9066 mycat mycat true/false 如果出现乱码添加字符集 ...

error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max po...

删除数据库中某个字段中某个数据语法：replace(字段,字符1,字符2)解释如下：replace是替换语法字段：数据库中的某个字段，一般是你需要字段字符1：原字符，你需要替换的字符，比如A（示例学生）字符2：新字符，替...