MySql Query in CRON

zeroinf

Hello friends !!!
I try to make cron job to execute mysql query but wont work . Also i tried in terminal to execute but without success.
Is there someone can indicate me some usefull trick
mysql -u USERNAME -p PASSOWRD -D DATABASE -e 'DELETE FROM oc_activity WHERE timestamp > 1'
Thanks

aaPanel_Kern

zeroinf
Hello, what is the prompt that cannot be executed? Please check if the mysql statement is correct?

zeroinf

aaPanel_Kern
In terminal mysql -u ******* -p ******* -D ******* -e 'DELETE FROM oc_activity WHERE timestamp > 1' Enter password: ERROR 1045 (28000): Access denied for user '*******'@'localhost' (using password: YES) [root@srv ~]#
But the password is that . is copied from aApane > Database management

aaPanel_Kern

zeroinf
1045 Indicates that the password is wrong. Try resetting the root password in databases.
If it still doesn't work. Refer to this:
https://www.percona.com/blog/2019/07/05/fixing-a-mysql-1045-error/