Hello,
So when I try to make database I get this error:
ERROR to connect database, pls check database status!
aaPanel is freshly installed, MySQL 8.0 is running.
Also I can connect with the terminal:
mysql -u root -p
Also I can connect local and remotely to the MySQL.
PhpMyAdmin also letting me to connect to the root user.
Changing password did not help at all, it just changes password and I can connect with terminal/phpmyadmin with new password, but creating database with panel does not work.
If you need any more further informations, let me know!
Thanks in advice!
ERROR to connect database, pls check database status!
almir101
Do you want to access your mysql on the public network or other ip?
If yes, please check if your 3306 port has been released
Add the ip that needs to be accessed in database-->Permissions
I am quoting myself:
"Also I can connect with the terminal:
mysql -u root -p
Also I can connect local and remotely to the MySQL.
PhpMyAdmin also letting me to connect to the root user."
mysql -u root -p will let me connect (With terminal - localhost)
and phpmyadmin also lets me to connect (with my private IP adress - client)
so both, public and local connections work, but aapanel cannot connect to the database...
So you can log in on phpmyadmin using the root password displayed on aaPanel But can't manage the database on aapanel?
9 months later
How can i Connect mysql root user using mysql workbench I can allow other users via specific ips but how can i allow to root user db to access all database using workbench.