Linux Systems Engineer
- Oct 18, 2019
- Reaction score
- Novosibirsk, Russia
By the way you need to make sure you don't actually edit the file thats located in the /etc/my.cnf which mysql server uses to boot up because if you do anyone can use the server with ALL privileges and ALL databases without a password. So instead create a file in your local /root directory call it my.cnf and make sure only root can read it (of course)
The easiest way to do this is to use a client section of the ~/.my.cnf file, and add the credentials inside that file.
Before upgrading the server, remove sql-mode="" and restore it again after the upgrade is complete.
Cyberpanel mysql root password
All changes must end with a restart
sudo service mysqld restart