大家好,这可能只是一个简单的修复,但我似乎无法让它工作...
我正在尝试设置一个MySQL数据库(在RHEL上),但出现以下错误:
mysql> SELECT 1;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('new_pass');
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
mysql> SELECT PASSWORD('new_pass');
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
我尝试了所有可能的命令/查询,但无法绕过这两个错误消息。也许我的权限有问题?有什么想法吗?谢谢!
SET old_passwords = 0;
- Mihai