mysql
Michael10001
stay hungry ,stay foolish
展开
-
host ip is not allowed to connect to this MySql server解决方案
1、d:\mysql\bin\>mysql -h localhost -u root //这样应该可以进入MySQL服务器2、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //赋予任何主机访问数据的权限3、mysql>FLUSH PRIVILEGES //修改生效4、mysql>EXIT //退出My原创 2016-02-03 09:33:09 · 708 阅读 · 0 评论 -
修改mysql用户密码
方法1: 用SET PASSWORD命令 mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');方法2:用mysqladmin mysqladmin -u root password "newpass" 如果root已经设置过密码,采用如下方法 mysqladm原创 2016-02-03 09:36:02 · 310 阅读 · 0 评论 -
mysql You are using safe update mode
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconne原创 2016-04-11 07:04:57 · 1191 阅读 · 0 评论 -
mysql 虚拟自增ID
SELECT (@i:=@i + 1) AS id, m.*FROM (SELECT DATE_FORMAT(c.report_time, '%Y') AS report_year, c.unit_id, COUNT(1) fix_num FROM subway.t_work_order_原创 2016-11-07 13:46:06 · 3612 阅读 · 0 评论