Mysqltuner Doesn't accept my root and password

[dibidib]

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

[studio4host]

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

Code Select Expand

cat /root/.my.cnf

[dibidib]

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

[studio4host]

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

[dibidib]

i appreciate for you want to help me.

you can check the screenshot to see my problem.

[bullten]

In ssh type

Code Select Expand

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.

[dibidib]

it has been resolved now..

Thank you so much..

[dibidib]

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?

[bullten]

what is output of

Code Select Expand

cat /etc/my.cnf

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

[dibidib]

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 Expand


# 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

[bullten]

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

So it should look like

Code Select Expand

[mysqld]
local-infile=0

[dibidib]

 

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