Access Denied

[nighteous]

Password kept in client but still getting Access denied to varoo@localhost

Expected Behavior: rr should work and display table of users

Actual Behavior: rr leads to the error Enter password: ERROR 1045 (28000): Access denied for user 'varoo'@'localhost' (using password: YES)

my.cnf

[client]
user=varoo
password=varoo

[clientAnysuffix]
database=idkdatabase

idk.sql

-- --defaults-group-suffix=Anysuffix
-- -p
-- -t
--

SELECT * FROM USER;

[kezhenxu94]

Hi @airpods69 , vim-mysql-plugin relies on the my.cnf and the mysql command to picks up the config, are you able to run mysql --defaults-group-suffix=Anysuffix in your own terminal?

[nighteous]

I need to specify the password as well with it

[kezhenxu94]

I need to specify the password as well with it

So I think your my.inf doesn't take effect for some reason.

[nighteous]

probably what can we do about that?

also sorry for the late reply, I have been traveling

[kezhenxu94]

probably

what can we do about that?

also sorry for the late reply, I have been traveling

I'm not sure why but that looks to be an issue of mysql client or mysql setup. my.inf should be automatically picked up by the command

[nighteous]

ah I'll set it up again and check it out again

should I avoid a password for the user just to make it work? (I dont mind doing this since its only for development purposes)

[kezhenxu94]

ah I'll set it up again and check it out again

should I avoid a password for the user just to make it work? (I dont mind doing this since its only for development purposes)

You can do that as a workaround but it's better to find out why the my.ini is not working