View Single Post
Author Message
trannygranny
Junior Member
Join Date: Jul 2017
Old 04-19-2018 , 21:51   Sourcebans Unknown MySQL Server Host 'root'
Reply With Quote #1

I've been trying to install Sourcebans on my vps, and I've gotten to the point where I need to set up the MySQL stuff. I've gotten to here:



When I submit this, I get this peculiar error:
Code:
Fatal error: mysqli error: [2005: Unknown MySQL server host 'root' (2)] in CONNECT(root, '****', '****', !!@***.**.***.**:3306/sourcebans) in /usr/share/nginx/html/sourcebans/includes/adodb/adodb-errorhandler.inc.php on line 77
I'm not sure why this happens. In an SSH terminal, I can connect to my MySQL database just fine using 'mysql -u root -p'PASSWORD' --host=localhost, so I have no idea why this is happening. If anyone can point me in the right direction, I would appreciate it. It may be worth it to note that in my SSH terminal, when logged into root, rather than displaying 'root@localhost', it displays 'root@ns543799' at the beginning of each line. Not sure if this makes a difference or not.

As well, I made a test PHP script to connect to my database, and it worked fine as so:

Code:
<?php
    $pConnection = new mysqli( "localhost", "root", "********", "sourcebans" );
    if( $pConnection->connect_error )
		die("Connection error ".$pConnection->connect_error );
?>
The connection error is not echoed.

Last edited by trannygranny; 04-19-2018 at 21:56.
trannygranny is offline