On Sat, 5 Oct 2019 11:51:59 -0400 Dave <debiantechquesti...@gmx.com> wrote:
> On our old server we used to access phpmyadmin via > "oursite.com/phpmyadmin" > > on the new server we have installed phpmyadmin / php / and sql-server > ... > > we cannot access phpmyadmin. > > also we have not been able to link other programs like wordpress to > sql or phpmyadmin to sql. > > DEBIAN 9.04 > > please advise > Two different issues. Is MySQL or MariaDb actually running? I recall there are gotchas with new installations (though of course, not what they were). There is a security program which must be run after installation, which MySQL used to do automatically under Debian but MariaDb didn't, and I've no idea what the situation is today. If you installed MariaDb, there should have been an instruction about this. Check netstat -tpan. Do you have a line with containing :3306 (if you did netstat as root, it will also show 'mysqld', even for MariaDb)? If not, check the logs to find why it isn't running. If there is, is it bound to localhost (127.0.0.1)? If so, are you trying to access it from other computers? If so, you need to make it listen on whatever addresses are appropriate. You also need to check that the right users from the right computers with the right passwords have found their way into the mysql/MariaDb database. This is easiest by comparing user accounts in phpmyadmin. If you normally use phpmyadmin, then this probably hasn't been done yet. phpmyadmin should Just Work, but it doesn't get put in the /var/www hierarchy, and needs its own configuration file. Check that @phpmyadmin.conf is in /etc/apache2/conf-enabled (it's a link to the file of that name in /etc/apache2/conf-available, which in turn is a link to /etc/phpmyadmin). Debian should have set all that up, but clearly something is wrong. If it can't find its database server, it should at least tell you. -- Joe
