我想用我创建的另一个用户登录mysql db
mysql -u root
create USER 'myuser'@'%' IDENTIFIED BY 'password' REQUIRE SSL; flush privileges;
授与权限
grant all on *.* to 'myuser'@'%' IDENTIFIED BY 'password'; flush privileges;
但是mysql拒绝连接并“强制”本地主机!
mysql -h myhost -p
Enter password:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES)
TCP端口3306是打开,
telnet-ssl myshost 3306
Escape character is '^]'.
Y
******-MariaDB...
ss -tulnepona|grep 3306
tcp LISTEN 0 80 *:3306 *:* users:(("mariadbd",pid=13501,fd=20)) uid:27 ino:39020 sk:45 cgroup:unreachable:1 v6only:0 <->
tcp TIME-WAIT 0 0 [::1]:59876 [::1]:3306 timer:(timewait,53sec,0) ino:0 sk:47
为什么强制本地主机而不连接到远程服务器?服务器是slackware-15上的mariadb,我不使用$HOME/.my.cnf
1条答案
按热度按时间zxlwwiss1#
找到了解决方案,我必须从远程站点测试它,而不是从本地站点