MySQL not connecting, install fails

[jodmcc1]

I have been trying to install the program a number of times without success. I have never worked with database setup or password protected sites, but do know setting up websites. I have a GoDaddy Hosted site and one thing also that I was not sure about is the password part of the deadlock install.
1. Do both the password in the deadlock install and the password for the database on GoDaddy need to match?

Below is the message I get:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/p/a/u/pauladmin4hf/html/deadlock/install/install.php on line 348
The script could not connect to MySQL. Install Failed.

Any help would be greatly appreciated.

jodmcc1

[newbie455]

I believe with Godaddy, you need to create a database user through their control panel and give it access to the database you wish to install on. Also make sure to use the hostname provided in their control panel as the mysql hostname in Deadlock.

[jodmcc1]

I created a database on a hosted account with GoDaddy and used the mySQL hostname in the Deadlock setup and the following error came up:
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /home/content/p/a/u/pauladmin4hf/html/deadlock/install/install.php on line 348
The script could not connect to MySQL. Install Failed.

1. Do both the mySQL database on GoDaddy and the Deadlock password need to be the same?
2. Do both the mySQL database on GoDaddy and the Deadlock name need to be the same?

Still having problems and again, I have never setup a password to database before.

Thanks,
jodmcc1

[newbie455]

The error to both of your questions is no. As long as you enter the database information correctly, Deadlock should be able to connect. I have not seen that error before. What exactly is the hostname you are using?

[jodmcc1]

I'm using the following for the hostname:

hamburglar.db.4915585.hostedresources.com


jodmcc1

[newbie455]

I suggest you contact godaddy about the error. It is a mysql generated error (doesn't have to do with deadlock) so they may be able to help you.

If you don't have any luck with that and are willing to give me your login info, I can have a look.

[jodmcc1]

Still not having any success. Newest error:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /home/content/p/a/u/pauladmin4hf/html/deadlock/install/install.php on line 348
The script could not connect to MySQL. Install Failed.

jodmcc1

[jodmcc1]

Still having problems, even after following your install guide and Guppy's install guide. Error:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /home/content/p/a/u/pauladmin4hf/html/members/install/install.php on line 348
The script could not connect to MySQL. Install Failed.

[newbie455]

Did you contact godaddy?

[jodmcc1]

Yes. First time I called, they needed me to go to my database and select configure and use the "connection strings" to connect to database. Not seeing where I was supposed to put this information in the setup screens, I tried to reinstall. Another error. Second time called they said that according to my screenshots, .htaccess needed to be in root and not a separate folder. I went back to setup and changed setting from /protected/.htaccess to just /.htaccess. tried to do reinstall and got error 500 before getting to setup screen. Finally got to setup screen entered the /.htaccess and again got another error. Tried reinstalling, making both .htaccess and .htpasswd settings to /.htaccess and /.htpasswd and still got error. Tried reinstalling, making sure I had .htaccess and .htpasswd in root directory. When I view site through FTP, there is no "public_html" directory. I went to GoDaddy and looked at the domain name configuration and it showed the "absolute hosting path" to be /home/content/p/a/u/pauladmin4hf/html. So in setup I entered that string and added "/.htaccess" and "/.htpasswd" in the respective setup boxes. Then I get an error in the next setup box telling me the path is wrong and it is showing me a path, which is the string I entered and another identical string behind it. I thought since I'm having so many issues with the original instructions that maybe I would try the install Guppy put together, including naming the directories the same as the instructions. This is when I got the last error listed above.

[newbie455]

Private message the "connection string" to me. Your problem is with mysql, not the .htaccess, so just leave that however you had it before.

[jodmcc1]

Just checking to see if you have any solutions yet?

Thanks,
jodmcc1