<html><head><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body>Are you trying to connect as the user 'root' to your mysql database? For security reasons that account is usually restricted to connections from 'localhost' only.<br><br>-- Justin<br><br>This is an initial install, and I need to configure the database schema, but the database server is on a different host. I am attempting to run mogdbsetup as:
<br>$ mogdbsetup --dbhost=db1 --dbname=xx --dbuser=xx --dbpassword=xx --dbrootuser=xx --dbrootpass=xx --yes<br>But the error I'm getting out is:<br>Failed to connect to DBI:mysql:mogielfs;host=db1 as specified root user: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
<br><br>Even though it's told to connect on an external host, it's trying to connecut through the local socket (which doesn't exist since mysqld is not running locally).<br><br>Any idea what I'm doing wrong? Or did I find a minor bug in mogdbsetup ?
<br>
</body></html>