It seems there is no connection between the client's creation of database users and databases. I only can created database users and databases within the Phpmyadmin by another user there, not by the client within ISPconfig3. Please see the screenshots attached. My server IP is 164.92.101.227. I do not install mail and dns. My system is Ubuntu 20.04.02. It seems the following test 'Access denied for user 'root'@'localhost'' is the cause for my above problem. Am I right? But I don't know how to solve 'ERROR 1045 (28000)'. I run the test script: Last login: Sun Jun 26 02:34:59 2022 from 223.18.190.151 root@less:~# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /root/htf-common-issues.php on line 288 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) And share the output in a code block. Code: IP-address (as per hostname): [localhost] [WARN] could not determine server's ip address by ifconfig [INFO] OS version is Ubuntu 20.04.4 LTS [INFO] uptime: 02:13:00 up 1 day, 3:02, 1 user, load average: 0.02, 0.01, 0.00 [INFO] memory: total used free shared buff/cache available Mem: 976Mi 378Mi 106Mi 58Mi 491Mi 389Mi Swap: 0B 0B 0B [INFO] systemd failed services status: UNIT LOAD ACTIVE SUB DESCRIPTION ● fwupd-refresh.service loaded failed failed Refresh fwupd metadata and update motd ● logrotate.service loaded failed failed Rotate log files ● snap.lxd.activate.service loaded failed failed Service for snap application lxd.activate LOAD = Reflects whether the unit definition was properly loaded. ACTIVE = The high-level unit activation state, i.e. generalization of SUB. SUB = The low-level unit activation state, values depend on unit type. 3 loaded units listed. [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.2.8p1 [WARN] Could not connect to mysql with given user data. [WARN] Could not use mysql command line to connect to the database. Check your mysql config! ##### VERSION CHECK ##### [INFO] php (cli) version is 7.4.30 [INFO] php-cgi (used for cgi php in default vhost!) is version 7.4.30 ##### PORT CHECK ##### [WARN] Port 143 (IMAP server) seems NOT to be listening [WARN] Port 993 (IMAP server SSL) seems NOT to be listening [WARN] Port 110 (POP3 server) seems NOT to be listening [WARN] Port 995 (POP3 server SSL) seems NOT to be listening [WARN] Port 465 (SMTP server SSL) seems NOT to be listening --More--Connection to 164.92.101.227 closed by remote host.
You are right. How was this ISPConfig installed? Check in PHPMyAdmin what you have in User Accounts. Compare what ISPConfig installation instructions tell about creating database users. The common issues script show other dubious test results, there may be more problems ahead.
Check that the correct mysql root password is set in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf
Till Brehm, you are great. After I changed the root passwd as same as the one you show me, 'ERROR 1045 (28000) ' problem disappeared and the database user and database the client created on ispconfig3 can be seen on myphpadmin. Thank you very much!
Thank you for your caring. Till has solve my main problem. I still has small problem. I installed ISPConfig3 with the automatic scripts.
Last month I installed ispconfig3 on Debian 11, I did not meet 'ERROR 1045 (28000) ' problem, the client created the database user and database can be seen instantly on myphpadmin. Why? Because Ubuntu 20.04 is more strict on root user's password than Debian?
Are you sure you did not change the MySQL root password after installing ISPConfig, e.g. via phpmyadmin or the admin console? This error can normally only happen in case that MySQL root password was changed manually after installing ISPConfig without setting the new password in the ISPConfig config file.
I am sure I did not change the root password on Debian 11. But I installed ispconfig3 twice on Debian 11. The first time I installed it with Email and DNS, found that the database user and database the client created on ispconfig3 can't be seen on myphpadmin. Then I decited to install ispconfig3 without Email and DNS. Both choose nginx instead of apache. I found it was the second time installation let me lucky to avoid the 'ERROR 1045 (28000) ' problem. I never know the path (/usr/local/ispconfig/server/lib/mysql_clientdb.conf) you give me, and how I can change the root passwd in the correct way? Thank you again!
