Attempted to use login credentials, but they were invalid

[ghost]

C:\Program Files\MySQL\MySQL Server 8.0\bin>perl mysqltuner.pl --host abcd.rds.amazonaws.com --user username --pass 'password' --mysqladmin "C:\Program Files\MySQL\MySQL Server 8.0\bin" --mysqlcmd "C:\Program Files\MySQL\MySQL Server 8.0\bin" --forcemem 1024
[--] * Windows OS(Win10) is not fully supported.

MySQLTuner 1.7.14 - Major Hayden major@mhtx.net
Bug reports, feature requests, and downloads at http://mysqltuner.com/
Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
'C:\Program' is not recognized as an internal or external command,
operable program or batch file.
[--] Performing tests on abcd.rds.amazonaws.com:3306
[!!] Attempted to use login credentials, but they were invalid

C:\Program Files\MySQL\MySQL Server 8.0\bin>

I am getting above error when running mysqltuner script from remote machine on AWS RDS instance.

[ghost]

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'

C:\Program Files\MySQL\MySQL Server 8.0\bin>

Does this causing issue here ?

[jmrenouard]

Yes,
user /password options should be used for credentials.

[ghost]

I am new to MySQL, Can you please provide more details on this ?

[ghost]

I wanted to know how to fix mysqltuner issue as mentioned above ?
[--] Performing tests on abcd.rds.amazonaws.com:3306
[!!] Attempted to use login credentials, but they were invalid

[jmrenouard]

Hi @akashsarpate

Have a look at FAQ
Question: Why does MySQLTuner keep asking me the login credentials for MySQL over and over?

And official documentation of course:
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html

This should help you :)

[ghost]

I have updated password in my.cnf file but still getting same error:

operable program or batch file.
[--] Performing tests on abcd.rds.amazonaws.com:3306
[!!] Attempted to use login credentials, but they were invalid

C:\Program Files\MySQL\MySQL Server 8.0\bin>

[jmrenouard]

Hi @akashsarpate

Do you try with mysql command ?

If it's not working manually with mysql/mysqladmin, it won't work with mysqltuner.

Best regards,

[ppelgrims]

That's actually good advice

mysql: [ERROR] unknown variable 'pass=************'

Docs should be updated to:
~/.my.cnf

[client]
user=someusername
password=thatuserspassword

[jmrenouard]

README updated with right config.

I close this issue.
Feel free to reopen it fi need.