Dreamhost and Mysql (31 posts)

  1. khaled
    Posted 10 years ago #

    I've bought an account at DH, Hurray!!!

    Why the hell don't they have phpmyadmin? What's going on there? I'm sure others have encountered this problem. I have NO idea what ssh is, don't have a friggin clue what to do to import my sql file.

    I swear I'm sure their support forums means something to someone, but to me it's all noise. I've checked the wp forums for something similar, I got a link to a tutorial how to actually get wp running which nearly made me cry.

    I'm seriously thinking of cancelling my plan with them.... they make some thing incredibly easy while others not so easy. Any help would be seriously appreciated.

  2. Jinsan
    Posted 10 years ago #

    You bought the plan and THEN checked if they had phpmyadmin?

    SSH is a way for you to upload files like ftp and then extract and install files from the client without having to extract on hdd first before uploading

  3. khaled
    Posted 10 years ago #

    Well it says it's got it, and it does, somewhere, but there's seems to be issues of how to bloody access the thing.

    The plan I got has got everything my current host has 4 times as much, and well DH seem more reputable. The problem is in order to make things easy they've made them hard...

  4. lbessant

    Posted 10 years ago #

    What plan are you on? I'm trying out Dreamhost, and I have phpmyadmin.

    Go into your panel, select Goodies - you should see MySQL listed there. From that section you can create new databases. Any databases you have alreadt created will be listed at the bottom of the page. The name of each database is a link to phpmyadmin for that database.

    The ssh access they offer is a bonus - lots of hosts don't let their customers have shell access like that. If you don't know (or care) about that kind of thing, you can safely ignore it....

    Dreamhost's Knowledge Base is very useful, too.

  5. khaled
    Posted 10 years ago #

    I've not propagated the domain name yet, and so I don't actually see phpmyadmin....

    So would I have to get my site propagated before I can access phpmyadmin?

    no ideas about ssh, completely over my head.

  6. Khaled, you'll have to wait for the domain name to propagate. Once it does, you can either click the database name in Goodies/MySQL as stated above, or just navigate your browser to the database URL. Either way, you'll be taken straight to the phpmyadmin interface.

    P.S. Don't be afraid to use DH's support forums. We're pretty active over there.

    P.P.S. You wouldn't be "emmortel", would you?

    P.P.P.S. Thanks for Manji!

  7. khaled
    Posted 10 years ago #

    Thanks macmanx I guess it's just good to know what the deal actually is. So phpmyadmin will come up once I've got it propagated.

    Okay in which case my site will go down for a day or so, eh what the hey, while I sort out the database transfer and the files transfer etc.

    Thanks for the help guys.

    p.s yeah I noticed :).

    p.p.s spot on :)

    p.p.p.s you're very welcome :)

  8. Check your domain (both via your browser and the Domains tab in DreamHost's CP) every three hours. A domain name transfer could take anywhere from 12-72 hours, sometimes less if you're lucky.

  9. Jinsan
    Posted 10 years ago #

    Hmmmm - Khaled, lol I just read the name! doh!

    So does dreamhost have their own Cpanel? And they don't use Fantastico?

    Well if it works, it works

  10. DreamHost constructed their own one-click installation for WordPress. They wanted more control over which version was installed, etc. I've seen Fantastico installers which are still installing v1.2.0. I'm glad that DreamHost is this dedicated to WordPress. They're also staying up-to-date on WP issues, such as not updating to MySQL 4.1.7 (and going to v4.1.8 instead due to WP incompatibility) and holding off the upgrade to PHP v5 until WP v1.5 is released. DreamHost also provides a one-click install for phpBB2, Advanced Poll, and OSCommerce. Again, all of these installers were developed in-house and not run by Fantastico.

  11. lbessant

    Posted 10 years ago #

    I've been playing at Dreamhost for about a month now, and so far I'm happy. It's the first time I've used Linux based hosting (all my previous hosts were Windows-based), and up till now it's been a positive experience. Their control panel works well for me - can't say I'd be inclined to use the one-click installs, but the rest is good.

    For the money[1], it's a good service.

    [1] The current UK-US exchange rate helps there :-)

  12. Joshua Sigar
    Posted 10 years ago #

    Why the heck you have to wait for domain to propagate to access phpmyadmin?

    It reminds me when I opened a new bank account, and they said they will freeze my opening balance for sometime before I could make withdrawal :(

  13. lbessant

    Posted 10 years ago #

    Propagation is necessary because access is by url of the database: database.yourdomain.com

  14. Also, the IP of your site changes when you switch to a new host. You must wait for your ISP to respect that change and apply it to your domain name in their caches.

  15. Mark (podz)
    Support Maven
    Posted 10 years ago #

    A database should not matter surely ?

    I thought that there was a delay purely for the DNS (Domain Name Servers) around the place to catch up - something that we were all told would be much much quicker ......and yet does not seem to be.

  16. lbessant

    Posted 10 years ago #

    In Dreamhost's setup, databases exist under a user-specifed hostname. The link from the panel is to dbhost.domain.com - or you can put that in the address line of your browser. Going to that link after entering the db user name and password takes you into phpmyadmin.

    So, no name propagation, no db access.....

  17. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Ahhhhh....... ta :)

  18. khaled
    Posted 10 years ago #

    Yeah I can confirm that little tid bit. Like I'd start propagating my site unless I was sure it was all going to work :).

    Right now to get things rolling and propagate the domain name. Thanks guys you've really been great as always.

  19. Joshua Sigar
    Posted 10 years ago #

    My webhost assigned me subdomain on their domain when I newly signed up, until my own domain propagates. I guess that's why I didn't have this issue. Phpmyadmin rightaway.

    Is most webhost setup similar to dreamhost's? Do most people experience this issue?

  20. khaled
    Posted 10 years ago #

    No generally speaking you don't have issues like this, since you get something like cpanel or directadmin etc. Dreamhost have made their own admin interface, and generally speaking it seems to be pretty good and you can control it very well, but in making things easy in somecases, they've made things slightly eh in others.

    Honestly setting up this seems a bit unorthodox to say the least, but hey I can live with that, there's a lot to actually be happy with.

    Oh yeah and btw for all those who are trying to get their mysql databases to talk to wp, make sure the host is not 'localhost'. It'll be databasename.yourwebsitename.com . That's all ^_^

  21. Jinsan
    Posted 10 years ago #

    well in my case I could access my Cpanel before the site propagated, because they assign an IP for your account which allows you to have a way to access things eg. http://serveripofyourdomain .com/~username/

    This allows you to set up db, and install whatever you want really until the site propagates. Trying to view the site before propagation is not really possibly, for example styles sheets won't load, and even the site may not load.

    It varies from host to host. Some offer it to you straight away, others say you have to wait

  22. khaled
    Posted 10 years ago #

    Jinsan how do you find the serverip?

  23. Khaled, going off of alphaoide's suggestion, you could great a subdomain.dreamhosters.com domain and have it mirror your main domain. This will give you direct access to your site. However, you can't do this for databases. But, if you have some static content that you'd like to get up there, this is the best way. As for your server IP, you'll have to ask DH Support for that.

  24. Jinsan
    Posted 10 years ago #

    khaled - I got it in my account information when the account got started. It varies from host to host, you could always contact Dreamhosts and ask them if you could access it immediately, so you could start uploading files and setting up db's or restoring them. You will have to wait for the domain to propagate because the page won't display otherwise

  25. Yeah, I kind of just covered how he could display his page, two posts above yours.

  26. Jinsan
    Posted 10 years ago #

    I'm very happy for you.

  27. Thanks, nice to know that someone is.

  28. Anamaria
    Posted 10 years ago #

    Even though this thread is quite old, I thought I would add to it in case someone in a similar situation comes across it, as I did. macmanx is right, in his comment above, that you can set up a subdomain at subdomain.dreamhosters.com domain and have it mirror your main domain. This allows you to access to your site before the DNS change propogates. You can also do something similar for databases however. Once your subdomain is up and running you can set up a database with the hostname at your the dreamhoster subdomain. You can then access the database using phpmyadmin at yourdatabase.subdomain.dreamhosters.com . Once your domain name has finished propagating, you can either keep it at the dreamhost sub-domain forever, or you can set up a second hostname for it at your real domain, and then once that propogates you can remove the dreamhost sub-domain mysql host. The dreamhost kb article on this is here: https://panel.dreamhost.com/kbase/index.cgi?area=2824&keyword=transfer


  29. Anamaria, thanks for the great tip!

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.