manageing sql from ispconfig web admin

Hello,

I cannot manage sql users or databases from my ispconfig admin frontend. Nothing happening if i do anyhthing.

I migraited the isp from older server but changed this: /usr/local/ispconfig/server/lib/mysql_clientdb.conf

Also as Till told me i tried this:

Code:

root@i01:~# mysql -h localhost -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2823247
Server version: 10.3.29-MariaDB-0+deb10u1 Debian 10
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye

root@i01:~# mysql -h 127.0.0.1 -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2823273
Server version: 10.3.29-MariaDB-0+deb10u1 Debian 10
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye

I can login on both way.
On error log i see this:
Unable to connect to the database: Access denied for user 'root'@'localhost' (using password: YES)
and ofc mysql dumps failing to.

What should i check?

Thanks:
Máté

 

Is there any character lengt maximum? My password is random 20 char alphanumeric

 

MariaDB password maximum length is 80 characters, unless configuration changed by user.
What can be problem is some characters confuse the password handler. But if you use only numbers and characters a-zA-z that works. I'm sure MariaDB documentation explains which characters are allowed.

 

hello,

after i run ispconfig update, the problem solved.
thanks for your help.
i don't know if i should make an another topics about it, but is there any way to make multiple backups? maybe to another server too?

Thanks

 

sorry for my poor english, i meant by multiple backups like 1. for local 2. for remote server too

 

Thanks!