Hi, I'm using the virtualbox image of debian7 withispconfig downloaded from here. I have difficulties to access to my mysql server from a remote host. I have already searched in the forum and i have found this old post http://www.howtoforge.com/forums/showthread.php?t=12455&highlight=allowed+connect+MySQL+server , therefore i have changed the hostname within the user table of the mysql db without results. The vps run behind a debian apache proxy but the there is a direct nat from the wan port to the lan port. In the ispconfig I have selected the "remote access" leaving empty the IP field. I have verified also the /etc/mysql/my.cnf and the the bind-address is commented out. Where I mistake?! Error: Unable to connect to host my-ip-1-2-ip3.fastwebnet.it because access was denied. Double-check your username and password and ensure that access from your current location is permitted. MySQL said: Access denied for user 'c1test'@'my-ip-1-2-ip3.fastwebnet.it' (using password: YES)
The thread you used is really old and does not applyto current setups. If you changed a hostname, then please undo this first so we start from a clean setup. Does the login with phpmyadmin with this user work?
Hi, in the user table of the mysql db there was two field with 'server1.example.com' that was changed to myhostname.mydomain.com
Ok, so its a general isue with that mysql user and not a problem with the external access only. Does this user exist in mysql user table? And if yes, which values has this user set for the hostname and how many linses are there in the table with that username?
Hi, I'm experiencig the same problem on the other debian nginx vps image, downloaded the same from your site. No database is created when added from the ispconfig control pannel! and.. on the nginx virtualbox image the phpmyadmin alias is not available, 404.
Thats quite strange as I use the same images here for develping and testing ispconfig and I can add databases without a problem. Did you change the mysql root password after you downloaded the image. The phpmyadmin on nginx works different then on Apacahe. phpmyadmin is reachable on port 8081 on nginx systems.
