czl0325的专栏

1. 在主服务器上创建从表用户# 创建slave用户，允许192.168.0开头的从服务器访问create user 'slave@192.168.0.%' identified with mysql_native_password by '111';# 配置权限grant replication slave on *.* to 'slave'@'192.168.0.%';...

1. 修改表中的字段alter table tb_good change cate_id c_id int unsigned not null2. SOME, ANY, ALL

1. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)在设置中无法启动mysql。解决方法：打开终端cd /usr/local/mysqlsudo ./bin/mysqld_safe （可按CONTROL-Z退出）bgexitCONTROL-D（退出）接着就可以启动了。2.navicat无法连接mysql需要编辑连接