my.cnf acces denied
upgrade done !!
always the same problem !!
can cloudflare make the problem ?
No, cloudflare shouldnt be a problem.
Have you ever connected cyberpanel to cyberpanel cloud and did the mysql optimization? If so, then the log-bin code might be added…please let me know if you did that in past?
login to ssh and then edit my.cnf file using
nano /etc/mysql/my.cnf
and see if there is any entry related to “log”
show the /etc/mysql/my.cnf content please
NO MY FRIEND I DIDN’T LINK CYBERPANEL TO CYBERPANEL CLOUD SHOULD I DO THIS ?
about the second part i didn’t now how to do this i will search in google
always the same problem cpu usage 85%
thank you
-bash: /etc/mysql/my.cnf: Permission denied
how can i get this content .?
thank you
The MariaDB configuration file
The MariaDB/MySQL tools read configuration files in the following order:
1. “/etc/mysql/mariadb.cnf” (this file) to set global defaults,
2. “/etc/mysql/conf.d/*.cnf” to set global options.
3. “/etc/mysql/mariadb.conf.d/*.cnf” to set MariaDB-only options.
4. “~/.my.cnf” to set user-specific options.
If the same option is defined multiple times, the last one will apply.
One can use all long options that the program supports.
Run program with --help to get a list of available options and with
–print-defaults to see which it would actually understand and use.
This group is read both both by the client and the server
use it for options that affect everything
[client-server]
Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
Permission denied? You will need to login to your server as root user. If root permissions are not enabled, please contact your hosting provider and they will help/guide you.
ok thank you , i will contact them now & i will give you a feedback later , always my cpu runing out , my websites very very very slow
Are you by any chance hosting at Contabo?
I just saw that they changed away from “root” user in favor of “admin”.
So you cannot go to the /etc/ folder as root anymore.
I have tried explaining this to their support.
This is what I got around this, I reverted my OS to an earlier snapshot, so I still have root user.
you could ssh to your server then create a new group. Add the user admin to the newly created group and change the group owner of the home folder to the newly created group. Then set the required permisions for groups, so that user Admin will have access to home folder for root user.
If you have any questions or need help, please do not hesitate to contact us.
hello & thank you
yes contabo
really i don’t now how to do this !!
can you please send me the cmd here ? or in private
thank you again
please can you help in private in order to open the folder , i still have to same problem