Control Web Panel

WebPanel => MySQL => Topic started by: dibidib on July 19, 2018, 02:27:17 PM

Title: Mysqltuner Doesn't accept my root and password
Post by: dibidib on July 19, 2018, 02:27:17 PM
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
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: studio4host on July 19, 2018, 06:00:25 PM
you can check mysql password in this file: /root/.my.cnf
Code: [Select]
cat /root/.my.cnf
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: dibidib on July 19, 2018, 06:04:59 PM
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
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: studio4host on July 19, 2018, 09:08:23 PM
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
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: dibidib on July 20, 2018, 06:47:26 AM
i appreciate for you want to help me.

you can check the screenshot to see my problem.

(https://preview.ibb.co/nySUdd/mysqltuner.png) (https://ibb.co/cC2HWy)
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: bullten on July 20, 2018, 08:27:03 AM
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.
Title: Re: Mysqltuner Doesn't accept my root and password - Resolved
Post by: dibidib on July 20, 2018, 08:46:59 AM
it has been resolved now..

Thank you so much..
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: dibidib on July 20, 2018, 10:01:27 AM
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?

Title: Re: Mysqltuner Doesn't accept my root and password
Post by: bullten on July 20, 2018, 11:04:24 AM
what is output of
Code: [Select]
cat /etc/my.cnf
Also how are you adding in /etc/my.cnf
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: dibidib on July 20, 2018, 11:32:52 AM
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 :(
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: bullten on July 20, 2018, 11:36:22 AM
You are missing [mysqld] above local-infile=0

So it should look like

Code: [Select]
[mysqld]
local-infile=0
Title: Re: Mysqltuner Doesn't accept my root and password
Post by: dibidib on July 20, 2018, 12:03:24 PM
 :D :D :D

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