mysql4.0 新建用户执行:create user 'test1'@'localhost' identified by '123456';报错ERROR 1064语法错误
百度查询报错无果,尝试在mysql4的其他新建用户方式:
方法1:使用 INSERT 语句新建用
mysql > insert into mysql.user(Host,User,password) Values ('localhost','test1',password('123456'));
方法2:使用GRANT语句新建用户
mysql > GRANT ALL PRIVILEGES ON *.* TO 'test1'@'localhost' IDENTIFIED BY PASSWORD '123456' WITH GRANT OPTION;
执行报错:ERROR 1133: Password hash should be a 16-digit hexadecimal number,需要执行select password() ;语句获取密码的哈希值,需要注意的是mysql4.0和5.6版本相同密码的哈希值不同
mysql > GRANT ALL PRIVILEGES ON *.* TO 'test1'@'localhost' IDENTIFIED BY PASSWORD '565491d704013245' WITH GRANT OPTION;
mysql4.0版本需要刷新权限生效,否则操作修改密码会报(ERROR 1133: Can't find any matching row in the user table),5.6版本不需要刷新
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)