Only one user per database??!!
Why is it that we can no longer use the same database user on multiple databases?
Thorn in my side I tell ya!!
I create one admin, and then add under privileged db users for each app that needs it’s own database.
However, i can still access them all from my admin db user.
Seems dreamhost suddenly decided NOT to allow this anymore.
VN:F [1.8.4_1055]
VN:F [1.8.4_1055]
- Submit this to Script & Style
- Share this on Blinklist
- Share this on del.icio.us
- Digg this!
- Post this on Diigo
- Share this on Reddit
- Buzz up!
- Stumble upon something good? Share it on StumbleUpon
- Share this on Technorati
- Share this on Mixx
- Post this to MySpace
- Submit this to DesignFloat
- Share this on Facebook
- Tweet This!
- Email this to a friend?
- Suggest this article to ToMuse
- Subscribe to the comments for this post?
- Share this on Linkedin
- Seed this on Newsvine
- Share this on Devmarks
- Add this to Google Bookmarks
- Add this to Mister Wong
- Add this to Izeby
- Share this on Tipd
- Share this on PFBuzz
- Share this on FriendFeed
- Mark this on BlogMarks
- Submit this to Twittley
- Share this on Fwisp
- Moo this on DesignMoo!
- Share this on BobrDobr
- Add this to Yandex.Bookmarks
- Add this to Memory.ru
- Add this to 100 bookmarks
- Add this to MyPlace
- Submit this to Hacker News
- Send this page to Print Friendly
- Bump this on DesignBump
- Add this to Ning
- Post this to Identica
- Save this to Xerpi
- Share this on Wikio
- Tip this to TechMeme
- Sphinn this on Sphinn
- Post this to Posterous
- Grind this! on Global Grind
- Ping this on Ping.fm
- Submit this to NUjij
- Submit this to eKudos
- Submit this to Netvouz
- Submit this to Netvibes
- Share this on Fleck
- Share this on Blogosphere News
- Blend this!
- Add this to Wykop!
- Engage with this article!
- Share this on Hyves
- Push this on Pusha
- Bookmarks this on Hatena Bookmarks
- Store this link on MyLinkVault
- Submit this to SlashDot
- Add to a lense on Squidoo
- Submit this story to Propeller
- Submit this to FAQpal
- Clip this to Evernote
- Submit this to Meneame
- Submit this to Bitacoras
- Submit this link to JumpTags
- Share this on Bebo
- Submit tip to N4G
- Submit this to Strands
- Promote this on Orkut
- Share this on Tumblr
- Add this to Stumpedia
- Post this to Current
- Blog this on Blogger
This entry was posted on Sunday, November 13th, 2005 at 12:01 am and is filed under Advocacy, Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Chovy,
I’ve been following your dreamhost posts. You’re still with them. How do like the service? Earlier you complained about terminal window response time. Still a problem? How about web page response time? Any other complaints
The one thing I like about DH plans is that they offer shell and log access. Most hosts require that you buy a dedicated server before you get shell/log access. I still have not used DH because my current host, sectorlink, has had such GREAT, friendly service and you can call any time M-F to talk with someone and email 24×7 with about 15 min response time.
Thanks
pxforti
On Day 25 (see latest post), I have had ups and downs.
current complaints:
1) database can only have 1 user
2) frequent, but minimal down times (but it’s still better than neureal’s dropped connections
3) only get your own process in ‘top’
Other than that, they are awesome.
I give them about an 88% rating.
100% would be no problem.
as to their tech support, i am happy with 1-3 day waittime (depending on urgency) for tech support questions.
If you will loose money if your site is down, i probably would not use Dreamhost. My next stop would be http://www.clari.net
You still with Dreamhost? Do you still like them? I just signed up for an account at 1&1 and so far am very happy. They are a little slow creating a new account; I’m used to seeing a new account with an hour. They took 4 hours. But once it was set up, they have a lot of easy-to-use tools for creating email accounts, ftp users, adding and removing domains, and so on. Also, you can call them for support and the wait time is about 5-10 minutes. Not sure about their reliability, but have read they are pretty good. Of course, you can always find a disgruntled customer with an axe to grind, but most posts I read were positive. We’ll see. You get a LOT for your money, even more than at Dreamhost.
The reason you could only have one db per user is because they would fill up their database servers sequentially. So every database you create could be on a different server.
However they have since changed this so each user has a dedicated DB server where all their databases go. In order to accommodate future growth this also means the servers are generally less crowded. It also limits the number of other users that could affect you at the expense of all your databases going down if there’s a problem. All in all, Dreamhost service has really improved in the last year.
There are no limits for number of DB users now.
Great Deal
Gonna give them a try. I found out if you use the promo code ‘30AYEAR’ you get a full year for less than 30 bucks. Worth the chance for me.