Problem connect mysql data

notelseit

I have problems connecting with the database, as you can see from the videos, the logs do not show anything strange, has anyone ever experienced something like this? the data are correct for both the root password and the database in question

Video 1

Video 2

aaPanel_Kern

notelseit
Hello,

Try to turn on the database switch again in the recycle bin on the file interface. Or close the switch and delete it
Please check that the input is correct. Is the database name the same as the password? Is there a database with the same name in MySQL?

notelseit

aaPanel_Kern

already done as a test by the way I have done several tests, databases with different user, password and name, same data for all three values but as you can see from the video it does not work. the strange thing is that in ssh it does not present these problems on many databases while others give access denied error.

aaPanel_Kern

notelseit
Hello, can log in using phpmyadmin or the command?

notelseit

aaPanel_Kern

no , not login , and not open sphpmyadmin

aaPanel_Kern

notelseit
Hello, can I log in with phpmyadmin or the command?

notelseit

aaPanel_Kern

I connect via ssh without problems on different db, on others even resetting the password does not log in giving that error

notelseit

found the problem of no connection to the database the users in the mysql.user table are not present, now is to understand why this happened and where the panel gets the data from to check the situation

notelseit

I have tried to create the terminal-side mysql users and delete the database assigni but the users are deleted but not the databases.

in the meantime, I am looking for solutions to the problem, it has never happened to me on the panel that users were deleted but not the database

aaPanel_Kern

notelseit
Hello, which directory is the database directory stored in? The log prompt table does not exist? Have you upgraded the database?

notelseit

aaPanel_Kern

Hello, which directory is the database directory stored in?

/www/server/data

The log prompt table does not exist?
no
Have you upgraded the database?
yes

aaPanel_Kern

notelseit
Whether the upgrade failed. It not be initialized successfully. Check whether MySQL is running. View the upgrade log
View database error log
cat /www/server/data/*.err|grep -i -C 10 error