mysql密码空_MySQL password可以为空吗?

可以的。

有两种方法证明：

1)创建密码为空的用户

create user test identified by '';

grant usage on test.* to test;

操作是可行的。

2)数据字典查看密码

5.5版本：

mysql> select user,host ,password from mysql.user where user='test';

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

| user | host | password |

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

| test | % | |

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

1 row in set (0.00 sec)

5.7高版本的字段是authentication_string

select authentication_string ,user,host from mysql.user where authentication_string='';

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

| authentication_string | user | host |

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

| | root | localhost |

| | dba_test | 192.168.100.% |

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

2 rows in set (0.00 sec)