mysql 登陆权限的问题

ziwei

各位，我用的是redhat 8.0 + mysql 3.23,我发觉一个问题输入mysql -u root -p123456可以登陆
[root@test sasl2]# mysql -u root -p123456
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 3.23.58-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

但是输入mysql -u root@localhost  -p123456就不能登陆
[root@test sasl2]# mysql -u root@localhost  -p123456
ERROR 1045: Access denied for user: 'root@localhost@localhost' (Using password: YES)

请问还要设置什么，才能使mysql -u root@localhost  -p123456可以登陆？

Unicorn_angel

Access denied for user: 'root@localhost@localhost'

仔细看看那出错了，

Fan.Wu

Access denied for user: 'root@localhost@localhost

它默认就是 localhost !

ziwei

怎么看呢?以下是我建库的脚本
USE mysql;
# Postfix user & password
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','postfix','postfix','Y');
# Postfix Admin user & password
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'))
;
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localho
st', 'postfix', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
FLUSH PRIVILEGES;
GRANT USAGE ON postfix.* TO postfix@localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfix@localhost;
GRANT USAGE ON postfix.* TO postfixadmin@localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfixadmin@localhost;
CREATE DATABASE postfix;
USE postfix;

为什么mysql -u root@localhost  -p123456会不能登陆呢?

hardiwang

mysql -u root -p123456

这样登陆

ziwei

我明白了，其实我研究mysql是因为我用的smtp auth sasl认证通不过，以下是mysql的日志
7 Connect     Access denied for user: 'postfix@localhost' (Using password: YES
)
                      8 Connect     Access denied for user: 'postfix@localhost' (Using password: YES
)
                      9 Connect     Access denied for user: 'postfix@localhost' (Using password: YES

从这个日志里，我不能看出是因为postfix 登陆的时候密码不对，还是postfix登陆成功后 ，在查询表的时候没有返回项，请问有什么方法可以让mysql的日志记录地更加详细呢？
谢谢各位啊

macrodba

mysql -h localhost -u root -p123456