Control Web Panel
WebPanel => MySQL => Topic started 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
-
you can check mysql password in this file: /root/.my.cnf
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.
(https://preview.ibb.co/nySUdd/mysqltuner.png) (https://ibb.co/cC2HWy)
-
In ssh type
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
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
# 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
[mysqld]
local-infile=0
-
:D :D :D
Yesss.. you did it.. Thank you..