SQLSTATE[HY000] [2002]
Hi all,
I'm having problems with migrating my website, built with Tiki 9.1, from my development environment on my local xampp W7 host to my production environment on BellHosting.ca. I've set up a database in the environment and was able to import my database tables. I was also able to upload the tiki installation files to the file system on BellHosting (with some "file already exists" errors - a clue?) and I could start the tiki installer. I passed the memory test, and the email test, but I'm hitting the error message that you see in the message title above, with the detail text "Can't connect to MYSQL Server on my_domain_name(111)". I searched the forums and found a little information, such as the need to modify php.ini (which I probably won't be allowed to do in my environment) and a statement that someone else with the same problem was "using the wrong hostname". But none of the advice seems to be applicable or effective. I have some questions, then:
What should I use for the Host Name field? The help button says to use localhost if the database is running on the same sever as tiki. Does this apply to remote servers? Should I use localhost even on a remote server? Or should I use my proper domain name? FYI neither option gets me past the problem.
Would the manual installation procedure work for me (i.e. would it be worth trying)? I don't have shell access.
Thanks! I really want to make this work.