+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: MySQL Hostname (/showthread.php?tid=1646)
MySQL Hostname - Canderson - 06-05-2015
Hello, I am new to this having been on 1and1 hosting for a while. Idiot steps might be needed lol
I am trying to install opencart on a sub domain, everything so far was going well.
I have created a MySQL database and a user that is linked to the database.
I have gone to the landing page to set things up and I get:
"Error: Could not connect to the database please make sure the database server, username and password is correct!"
Please enter your database connection details.
Database Driver: MySQL (Also tried MySQLi)
* Database Host: http://MYDOMAIN.CO.UK (also tried my servers ip address, the public/external one not its 192)
* User: [Username I created]
Password: [Password I created for user above]
* Database Name: zadmin_dbblahblahblah (not really blahblahblah just a filler)
Database Prefix: oc_
All the correct ports have been opened (Very first thing I did BEFORE installing Sentora, knowing exactly what I would be hosting)
I am probably missing something or fudging something up, so hopefully someone with more experience and knowledge will be able to help me
Just in case it is relevant the Server is on the same local network as my computer but I have edited the hosts file on my computer to reflect this (didnt even need google to help me with that go me! lol)
Thanks in advance for any help, and I appologise for any dead feelings you may be left with for reading/answering probably a basic question lol
I would buy whoever helps me with this a pint, but you would have to be in the Blackpool area of the UK lol!
RE: MySQL Hostname - apinto - 06-06-2015
Database Host: is likely:
Code:
localhostHope this helps
RE: MySQL Hostname - Canderson - 06-06-2015
(06-06-2015, 12:14 AM)apinto Wrote: Database Host: is likely:
Code:localhost
Hope this helps
I have just tired that
Unfortunately it just makes the page disappear altogether. 
RE: MySQL Hostname - apinto - 06-06-2015
localhost should work, I mean, must work...
127.0.0.1 doesnt work either?
If it doesnt work you have some other misconfig on OpenCart or the server itself.
RE: MySQL Hostname - Canderson - 06-06-2015
(06-06-2015, 12:45 AM)apinto Wrote: localhost should work, I mean, must work...
127.0.0.1 doesnt work either?
If it doesnt work you have some other misconfig on OpenCart or the server itself.
Nope goes blank again I press continue and the page goes white.
cant see it being opencart tbh.
any ideas?
is there something I need to configure with MySQL before trying to connect to the database? I have very very limited experience with MySQL Can you tell? lol
[OFF TOPIC]Up until a few month ago I was semi afraid of it because I had been taught by an admin I used to work for "Never ever ever go into it its confusing and if you do the wrong thing you will break the whole system" now I am using it I am thinking hmm yea its just one giant database why dont you back it up?
RE: MySQL Hostname - Canderson - 06-07-2015
(06-06-2015, 12:45 AM)apinto Wrote: localhost should work, I mean, must work...
127.0.0.1 doesnt work either?
If it doesnt work you have some other misconfig on OpenCart or the server itself.
Just an update, incase there is anyone as dense as me reading through ever.
I reinstalled CentOS again, did all the OS updates... again, Firewall..... again... then installed Sentora..... again lol then for some reason it worked I did nothing different but for some reason, it worked lol
Probably somewhere in something installing it missed a file or two? Dont know however the good news is ITS ALIVE!!! Mwahahahahahahhahaha
Thanks for your help @apinto, it was your suggestion of a misconfiguration that lead me to reinstall the lot lol