Hello, I use an ftp user account (ispconfig) to inject my site on the server via Filezilla. (No problem yet) I modified the my.cnf file (optimization). I restart the service systemctl restart mariadb My ftp user access via filezilla responds: Answer: 530 Permission denied. Error: Unable to establish a connection to the server Do you have a solution to this problem? thank you in advance
Your FTP user is not allowed to edit this document, connect over SSH as root or as normal user with sudo rights. Edit your my.cnf with a program like nano as root (sudo nano /path/to/my.cnf)
Thank you for your comeback. I modified the my.cnf file with the command: sudo nano /etc/mysql/my.cnf I restarted the service systemctl restart mariadb then I lost my ftp access in user mode (filezilla), impossible for me to access my server. I have an error: 530 Permission denied. I no longer know how to recover my ftp access. I found no info on Google thank you
Login by ssh instead of ftp and undo the changes you made to the MariaDB configuration so that MariaDB is able to start again.