摘要：1. 结束mysql进程.2. 重新启动mysql，并进入相应的安装目录下并输入“bin/mysqld --skip-grant-tables &”,回车后该窗口将会停止，此时需要再打开一个窗口并同样进入安装目录下3. 输入mysql -u root4. 修该root的登录密码：update mysql.user set password = PASSWORD('新的密码') where user = 'root' ;flush privileges;quit;OK, let's login mysql again~久违了的欢迎画面~ 阅读全文

摘要：检查配置文件mysql.ini ：#设置WinMySQLadminServer=C:/Program Files/MySQL/MySQL Server 5.5/bin/mysqld-nt.exe user=rootpassword=xxxxxxxx # 设置为MYSQL的安装目录 basedir=C:/Program Files/MySQL/MySQL Server 5.5 # 设置为MYSQL的数据目录 datadir=C:/Program Files/MySQL/MySQL Server 5.5/data 阅读全文

摘要：在执行:deletefrom_ResumewhereIdin(selectA.Idfrom_ResumeAinnerjoin_UserBonA.UserId=B.UserIdwhere A.CreateTime < B.CreateTime):【详细错误】：Error Code: 1093. You can't specify target table '_Resume' for update in FROM clause.【错误原因】：在更新或删除目标表中数据的时候如果使用子查询，目标表不能在子查询的From语句中出现~原程序改造为：1createtabletm 阅读全文

摘要：Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.Solution：SETSQL_SAFE_UPDATES= 0;update T set col = 'xxx' where condition ……; 阅读全文