MySQL用户数据库没有密码列-在OSX上安装MySQL

我正在尝试更改MySql根密码。

我所做的如下。

  1. 安装MySql-5.7.6〜.dmg(社区服务器)和工作台。
  2. 在OSX系统首选项上关闭服务器。
  3. 使用控制台访问MySql。该命令是mysqld_safe --skip-grant
  4. 执行update user set password=password('1111') where user='root';并得到一条错误消息-> ERROR 1054 (42S22): Unknown column 'password' in 'field list'

仅供参考,我做到了use mysql;。所以我确实在用户表上选择了查询,发现密码列实际上不存在。

这很奇怪。原始用户表是否可能没有密码列?

如何更改不存在的密码?

谢谢你的回答:D

回答:

在MySQL 5.7中,删除了mysql.user表字段中的password字段,现在该字段名称为’authentication_string’。

首先选择数据库:

mysql>use mysql;

然后显示表格:

mysql>show tables;

您将找到用户表,现在让我们看一下它的字段:

mysql> describe user;

+------------------------+-----------------------------------+------+-----+-----------------------+-------+

| Field | Type | Null | Key | Default | Extra |

+------------------------+-----------------------------------+------+-----+-----------------------+-------+

| Host | char(60) | NO | PRI | | |

| User | char(16) | NO | PRI | | |

| Select_priv | enum('N','Y') | NO | | N | |

| Insert_priv | enum('N','Y') | NO | | N | |

| Update_priv | enum('N','Y') | NO | | N | |

| Delete_priv | enum('N','Y') | NO | | N | |

| Create_priv | enum('N','Y') | NO | | N | |

| Drop_priv | enum('N','Y') | NO | | N | |

| Reload_priv | enum('N','Y') | NO | | N | |

| Shutdown_priv | enum('N','Y') | NO | | N | |

| Process_priv | enum('N','Y') | NO | | N | |

| File_priv | enum('N','Y') | NO | | N | |

| Grant_priv | enum('N','Y') | NO | | N | |

| References_priv | enum('N','Y') | NO | | N | |

| Index_priv | enum('N','Y') | NO | | N | |

| Alter_priv | enum('N','Y') | NO | | N | |

| Show_db_priv | enum('N','Y') | NO | | N | |

| Super_priv | enum('N','Y') | NO | | N | |

| Create_tmp_table_priv | enum('N','Y') | NO | | N | |

| Lock_tables_priv | enum('N','Y') | NO | | N | |

| Execute_priv | enum('N','Y') | NO | | N | |

| Repl_slave_priv | enum('N','Y') | NO | | N | |

| Repl_client_priv | enum('N','Y') | NO | | N | |

| Create_view_priv | enum('N','Y') | NO | | N | |

| Show_view_priv | enum('N','Y') | NO | | N | |

| Create_routine_priv | enum('N','Y') | NO | | N | |

| Alter_routine_priv | enum('N','Y') | NO | | N | |

| Create_user_priv | enum('N','Y') | NO | | N | |

| Event_priv | enum('N','Y') | NO | | N | |

| Trigger_priv | enum('N','Y') | NO | | N | |

| Create_tablespace_priv | enum('N','Y') | NO | | N | |

| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |

| ssl_cipher | blob | NO | | NULL | |

| x509_issuer | blob | NO | | NULL | |

| x509_subject | blob | NO | | NULL | |

| max_questions | int(11) unsigned | NO | | 0 | |

| max_updates | int(11) unsigned | NO | | 0 | |

| max_connections | int(11) unsigned | NO | | 0 | |

| max_user_connections | int(11) unsigned | NO | | 0 | |

| plugin | char(64) | NO | | mysql_native_password | |

| authentication_string | text | YES | | NULL | |

| password_expired | enum('N','Y') | NO | | N | |

| password_last_changed | timestamp | YES | | NULL | |

| password_lifetime | smallint(5) unsigned | YES | | NULL | |

| account_locked | enum('N','Y') | NO | | N | |

+------------------------+-----------------------------------+------+-----+-----------------------+-------+

45 rows in set (0.00 sec)

惊喜!没有名为“ password”的字段,密码字段为“ authentication_string”。因此,只需执行以下操作:

update user set authentication_string=password('1111') where user='root';

现在,一切都会好的。

与MySQL 5.6相比,更改非常广泛:MySQL 5.7的新增功能

以上是 MySQL用户数据库没有密码列-在OSX上安装MySQL 的全部内容, 来源链接: utcz.com/qa/399292.html

回到顶部