Hello people,
Many people have error sql on panel.
So
1º you need a clean server, Ubunto 18.04 is best ( i use and no bug)
2º sudo apt update
3º sudo apt install mysql-server
Now you need to change bind adress
nano /etc/mysql/mysql.conf.d/mysqld.cnf
Ctrl + w -> write bind and you see something like that
bind-address = 127.0.0.1
change to 0.0.0.0
4º mysql_secure_installation
On next steps Ask for new pass
Again the same pass
All OPTIONS Y BUT CHOOSE N FOR THE OPTION REMOTE ROOT CONNETION
5º sudo systemctl restart mysql
Go panel add main server and MAGIC
Many people have error sql on panel.
So
1º you need a clean server, Ubunto 18.04 is best ( i use and no bug)
2º sudo apt update
3º sudo apt install mysql-server
Now you need to change bind adress
nano /etc/mysql/mysql.conf.d/mysqld.cnf
Ctrl + w -> write bind and you see something like that
bind-address = 127.0.0.1
change to 0.0.0.0
4º mysql_secure_installation
On next steps Ask for new pass
Again the same pass
All OPTIONS Y BUT CHOOSE N FOR THE OPTION REMOTE ROOT CONNETION
5º sudo systemctl restart mysql
Go panel add main server and MAGIC