Gossamer Forum
Home : Products : Others : MySQLMan :

login issue (maybe because mysql socket?)

Quote Reply
login issue (maybe because mysql socket?)
I am seeing an issue that I see many others report here:

Login failed. Please enter another hostname/username/password.

I am wondering if this could be due to the fact that with my MYSQL installation, a socket is required to access the database. For example, at command line mode, MYSQL is initiated like this:

/usr/local/mysql/bin/mysql --socket=/tmp/mysql.webadmin.sock --user=root --password=XXXX testdb

How do I adjust the mysqlman config if this is how I normally initiate MYSQL ?

tia,

Chuck
Quote Reply
Re: [ctmaiden] login issue (maybe because mysql socket?) In reply to
This was EXACTLY the issue. I went into mysql.cgi and found the DBI->connect call. I altered the call as follows:

$DBH = DBI->connect("$data_source"
. ";mysql_socket=/tmp/mysql.webadmin.sock",
$username, $password, { RaiseError => 0, PrintError => 0, AutoCommit => 1 });

This fixed it.

Anyone with a mysql installation requiring a socket designation will HAVE to use this fix!

CM