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.