在mysql中创建用户时,请遵循以下步骤:
CREATE USER IF NOT EXISTS 'devadmin'@'localhost' IDENTIFIED BY 'admindev';
GRANT ALL PRIVILEGES ON developerparse.* TO 'devadmin'@'%';
FLUSH PRIVILEGES;
我可以加入mysql:
mysql -u devadmin -p
但是我需要为用户设置远程访问,所以当我将主机设置为“%”时:
CREATE USER IF NOT EXISTS 'devadmin'@'%' IDENTIFIED BY 'admindev';
尝试加入mysql时,我遇到了一个错误:
MySQL ERROR 1045 (28000): Access denied for user 'devadmin'@'localhost' (using password: YES)
如何解决?
用户帐户表:
select user, host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| devadmin | % |
| devuser | % |
| prodadmin | % |
| produser | % |
| testadmin | % |
| testuser | % |
| debian-sys-maint | localhost |
| developer | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
1条答案
按热度按时间1tuwyuhd1#
%意味着这个用户可以来自任何主机。localhost,用户只能从该服务器。这对于root-by-example非常有用(出于安全目的)。root@localhost 意味着除了服务器本身,没有人可以与root用户连接。