随笔分类 -  mysql

mysql授权IP登录
摘要：授权所有，youpassword为登录密码GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION; 指定IPGRANT ALL PRIVILEGES ON *.* TO 'root 阅读全文
posted @ 2019-12-15 23:11 覃上 阅读(3651) 评论(0) 推荐(0)
error 1055 sql
摘要：SELECT @@sql_mode;ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION SET sql_mode=' 阅读全文
posted @ 2019-02-16 16:06 覃上 阅读(309) 评论(0) 推荐(0)