where is the location of the username and password of the mysqltuner I input the one on the .my.cnf but still says attempted to use login credentials, but they were invalid
any update with this one?? where can I find it the .my.cnf is not working when I used the login
e even the tuning-primer don’t work
fixed need to update the .my.cnf manually
where do I update this recommendation?
TABLE LOCKING Current Lock Wait ratio = 1 : 3673 You may benefit from selective use of InnoDB. If you have long running SELECT's against MyISAM tables and perform frequent updates consider setting 'low_priority_updates=1' If you have a high concurrency of inserts on Dynamic row-length tables consider setting 'concurrent_insert=ALWAYS'.
If you don’t have
/root and if dont remember the mysql’s root password consider resetting it, have a look at the following link :
also create a
/root with the new password for root.
You can tweak mysql setting in
my.cnf located at
To change mysql table format from myisam to innodb, have a look at following link: https://rtcamp.com/tutorials/mysql/myisam-to-innodb/#for-all-tables-in-all-databases
It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.
I am closing this support topic for now. Feel free to create a new support topic if you have any queries further.