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'.
Hi @rnovino
If you don’t have .my.cnf
in /root
and if dont remember the mysql’s root password consider resetting it, have a look at the following link :
also create a .my.cnf
in /root
with the new password for root.
You can tweak mysql setting in my.cnf
located at /etc/mysql/my.cnf
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.