Mysqltuner Doesn't accept my root and password

i tired reset root password

but still does not work..

Please enter your MySQL administrative password: [!!]  Attempted to use login credentials, but they were invalid.


i need to tune my server..

8Core
32GB ram

Server is not fast that i need. system sources are empty..

how can i modify my sql ?

thx all

you can check mysql password in this file: /root/.my.cnf

Code: [Select]

cat /root/.my.cnf

Yes i tried it..

Also i changed root password with script.

İ can connect phpmadmin with root password.

But mysqltuner does not accept.

İ have 4 cwp7pro servers. All is same

then your script has some issue if the root password works fine.
Anyway cwp has this script integrated so you can use it from cwp.admin mysql manager there is  "Security & Optimization Check" link

i appreciate for you want to help me.

you can check the screenshot to see my problem.

In ssh type

Code: [Select]

mysqladmin ping
It will definitely give error in your case. Just delete the line it report as error in /etc/my.cnf or under /etc/my.cnf.d where you have added.

You will be good to go now.

it has been resolved now..

Thank you so much..

i couldnt modify my.cnf..

i could find which my.cng file that i need to modify..

i tried /usr/share/mysql/my-large.cnf rename to my.cnf and edited. NO
i tried to add ~/.my.cnf. NO

when i add /etc/my.cnf mysqltuner doesn work..

how can i edit my.cnf and which one?

what is output of

Code: [Select]

cat /etc/my.cnf
Also how are you adding in /etc/my.cnf

i rename /etc/my.cnf to BAKmycnf

you told me to run mysqltuner

when i fix name of it mysqltuner doesnt work..

now. i renamed to show you what is output /etc/mycnf

Code: [Select]

# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

local-infile=0

i tried to edit /etc/my.cnf.d/client.cnf - server.cnf
result zero

You are missing [mysqld] above local-infile=0

So it should look like

Code: [Select]

[mysqld]
local-infile=0

 

Yesss.. you did it.. Thank you..