Problems with MySQL

playtoncz

Hello,
I'm dealing with some MySQL problems.
First of all. MySQL service is running, i can login to server via phpmyadmin but I can only start it using command sudo mysqld_safe. When i use service mysqld start I get message "Unit mysqld.service not found." (It is the same when i try sudo /etc/init.d/mysqld start.) Also I can't manage it through aaPanel.
I tried changing password but it didnt help and after install i had to change /tmp/mysqld.sock to /tmp/mysqld2.sock. Because it was crashing for some reason. I tried reinstalling it, I tried installing other versions, but nothing helped.

Please help me.
Thanks in advance!

aaPanel_Kern

playtoncz
Hello, there is no mysql service indicating that the installation was not successful, please check the installation log /tmp/panelExec.log
When installing the software, be sure to check the installation process for errors.

playtoncz

Everything looks okay until the end. This is what is happening:

Installed /www/server/panel/pyenv/lib/python3.7/site-packages/PyMySQL-0.9.3-py3.7.egg Processing dependencies for PyMySQL==0.9.3 Finished processing dependencies for PyMySQL==0.9.3 Reload Bt-Panel.. ^[[32mdone^[[0m Stopping mysqld (via systemctl): mysqld.serviceFailed to stop mysqld.service: Unit mysqld.service not loaded. failed! Changing password... Logging to '/www/server/data/debian.err'. 2022-05-30T23:58:39.723622Z mysqld_safe Starting mysqld daemon with databases from /www/server/data 2022-05-30T23:58:41.580879Z mysqld_safe mysqld from pid file /www/server/data/debian.pid ended ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) Starting mysqld (via systemctl): mysqld.serviceFailed to start mysqld.service: Unit mysqld.service not found. failed The root password set ************** successuful 1 Stopping mysqld (via systemctl): mysqld.serviceFailed to stop mysqld.service: Unit mysqld.service not loaded. failed! Starting mysqld (via systemctl): mysqld.serviceFailed to start mysqld.service: Unit mysqld.service not found. failed! mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

aaPanel_Kern

playtoncz
Hello, reinstall mysql in the "app store" Pay attention to check if there is an error during the installation.

playtoncz

I reinstalled it and again no error only in the end.

Here is the full log:
https://pastebin.com/vQjNAt4G

playtoncz

Okay I reinstalled phpmyadmin, now it is kind of working. I can add and edit databases in aaPanel, but mysqld service is still not working and database server must be running in mysqld_safe mode. And i can't control database with phpmyadmin. I get following error:

aaPanel_Kern

playtoncz
Hello, the database is not started, deal with the database first, and then use other.
Check the log for specific errors
/www/server/data/debian.err

Check if the database is up
ps aux|grep mysql