Alright, so I'm trying to set up my database and I have no idea if I'm doing this correctly.
My host asks me which version of MySQL I want to use. I've tried both 4.1 and 5.0. Which version would I want to use?
My host also asks me if I want to "Allow Direct Database Access". I've been hitting "no" but I'm wondering if I should change that.
When I hit submit on the install eFiction screen I get a warning on the top of my screen that says: Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/h/y/s/hystericzone/html/serpensortia/install/install.php on line 903
It also says " Cannot connect to the database. The information you supplied appears to be incorrect. Please try again."
I know that the information I've supplied is correct.
Additional information:
Dunno if this matters but when I go to create the database, the database name and username is defaulted to one name (username is automatically the same as the database name. it doesn't let you create a username. I don't know if there's a way to change this through the PHP MyAdmin screen)
Edited to add: I run off a linux server, not sure if this matters, either. PHP version 5.x
To my knowledge, you can use either 4 or 5 with eFiction. My opinion is that's it's usually better to keep more current so long as the script supports it.
I'm not 100% sure what the "allow direct database access" question is getting at (I've not had it be worded that way before), but you do want the dbuser to have all privileges on the database, so I would lean towards answering yes to that. Answering no could be causing the connect issue, which is what all the messages are warning about.
It shouldn't matter what the database/username is, as long as you're supplying the correct info to the eFic install.
Just as an FYI, the majority of webservers used for eFiction are Linux-based (usually with cPanel). So it doesn't matter at all. : )
I finally got it to install correctly today. Turns out with godaddy hosting you can't use MyLocalHost as your hostname. You have to go into the database you set up and get the actual host name and install it that way. 🙂 I am very pleased that I finally got it to install.
Awesome. : ) Yeah, some hosts have their own things going on, but that's good to know about GoDaddy since they are popular & it might come up again.
