mariadb mysql:我想作为远程主机上的用户进行身份验证,但是..给予我localhost

ahy6op9u  于 2022-12-04  发布在  Mysql
关注(0)|答案(1)|浏览(127)

我想用我创建的另一个用户登录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

zxlwwiss

zxlwwiss1#

找到了解决方案,我必须从远程站点测试它,而不是从本地站点

相关问题