Location of mysql tuner password


#1

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


#2

any update with this one?? where can I find it the .my.cnf is not working when I used the login


#3

e even the tuning-primer don’t work


#4

fixed need to update the .my.cnf manually


#5

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'.

#6

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. :slight_smile:


#7