Saeedfar_h
New member
- Joined
- Apr 22, 2024
- Messages
- 2
Hi guys,
I needed to change mysql variables , tried to set super pirivilage access to da admin user. I tried to reset mysql root password and running necessary command , but during this process it failed with aria log file error , i tried to kill all mysql process , after reseting root password , Run ssh commands for altering , giving access and flushing privileges
I don’t know what happened to my direct admin and mysql. Everything looks ok on front side , website is loading but very slow. Directadmin also works fine but in mysql management section under user level , DA cant list my db’s. Internal error, failed to load database list.
But my website works good.
I tried mysql troubleshooting on DA documents , confirming there is no conflict files , my.cnf , mysql.conf files are ok and user passwords matched. Also, Mysql.sock file is ok
Also i checked phpmyadmin mysql tables , there was a problem with user and privilege table and done repairing procedure. Everything gets down ( roundcube , wordpress and etc )It. i found that mysql users lost their privileges, user dont have access and necessary privileges, i done granting super privileges for da_admin user and necessary for wp and roundcube. Everything is working deadly slow. Also still DA cant show db list.
Would you please help me ?!
I appreciate
I needed to change mysql variables , tried to set super pirivilage access to da admin user. I tried to reset mysql root password and running necessary command , but during this process it failed with aria log file error , i tried to kill all mysql process , after reseting root password , Run ssh commands for altering , giving access and flushing privileges
I don’t know what happened to my direct admin and mysql. Everything looks ok on front side , website is loading but very slow. Directadmin also works fine but in mysql management section under user level , DA cant list my db’s. Internal error, failed to load database list.
But my website works good.
I tried mysql troubleshooting on DA documents , confirming there is no conflict files , my.cnf , mysql.conf files are ok and user passwords matched. Also, Mysql.sock file is ok
Also i checked phpmyadmin mysql tables , there was a problem with user and privilege table and done repairing procedure. Everything gets down ( roundcube , wordpress and etc )It. i found that mysql users lost their privileges, user dont have access and necessary privileges, i done granting super privileges for da_admin user and necessary for wp and roundcube. Everything is working deadly slow. Also still DA cant show db list.
Would you please help me ?!
I appreciate
Attachments
Last edited:
