Author Topic: Mysqltuner Doesn't accept my root and password  (Read 665 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Mysqltuner Doesn't accept my root and password
« 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

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #1 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
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #2 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

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #3 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
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #4 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.


Offline
****
Re: Mysqltuner Doesn't accept my root and password
« Reply #5 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.

Offline
*
Re: Mysqltuner Doesn't accept my root and password - Resolved
« Reply #6 on: July 20, 2018, 08:46:59 AM »
it has been resolved now..

Thank you so much..

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #7 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?


Offline
****
Re: Mysqltuner Doesn't accept my root and password
« Reply #8 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

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #9 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 :(

Offline
****
Re: Mysqltuner Doesn't accept my root and password
« Reply #10 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

Offline
*
Re: Mysqltuner Doesn't accept my root and password
« Reply #11 on: July 20, 2018, 12:03:24 PM »
 :D :D :D

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