I need to enter my MySQL data

andycampbellcreative

I was installing Instant Update 3.1 when I was abruptly kicked out at Step 3 - Get MySQL Data. The rest of the installation seems like it was a success, but now when I try to login to IU I get the following error message: "Critical error: Could not connect to MySQL server!Unknown MySQL server host '{$dbhost}' (2)"

I have all five pieces of my MySQL data (host, username, password, database name and table prefix) and am ready to connect my IU installation to my database. How do I do this? Is there a .php file in my 'manage' folder that stores this data? If so, I could enter it manually, but what's the name of that .php file?

Please help!

Avram

Hello,

You can try to put data in manage/connection.php

$iu_table_prefix - table prefix
$db - database name
$host - MySQL server hostname
$user_name_on_host - MySQL user username
$password_on_host - MySQL user password

andycampbellcreative

Thank you. I found that .php file and filled in each of those values and I'm now getting the following error message: "Critical error: Could not connect to MySQL server!Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

Any ideas what might be causing that?

andycampbellcreative

With Avram's help via email I was able to fix the issue. See full description under separate discussion here: http://forums.cubescripts.com/discussion/74/socket-connection-to-mysql-server/

Avram

Hello,

As I already told you in the support ticket, Instant Update uses default socket to connect to MySQL server. Place your socket path in your MySQL server address field (in IU installer) as that field accepts identical parameters as first argument of PHP's mysql_connect() function:

"The MySQL server. It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket" for the localhost."

Howdy, Stranger!

Categories