Yes, "individual login" for every database was just not going to cut it for me. I finally managed to set up a MySQL account I could use through the Plesk/phpMySQLAdmin interface, and then finally I could get control over the db management through Navicat.
Navicat is so much easier with the data transfer, data synchronization, etc. I had Plesk set up on the VPS since it was free, and I thought "why not?"... now I know "why not!" I may keep it around for certain features, but never for managing the server. Rick > -----Original Message----- > From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 19, 2008 3:38 PM > To: CF-Talk > Subject: Re: Experiences with Railo > > > I'm strongly considering dumping Plesk. It seems designed for people > > who want to offer "public" > > hosting services > > Exactly, it's built so you can just hand off a login to the customer and let > them manage everything > themselves, perfect if you are reselling hosting. If your clients don't > access the server though, > there's little reason to use it. It does save some time on some things, like > automatically setting up > DNS entries, creating FTP accounts, etc. But I'm willing to put up with a > little extra hassle to not > have it on there messing up the server and getting in my way. And if you've > ever dealt with a Plesk > update gone awry, you'd definitely feel the same way! > > > > I'm having trouble now getting a connection to my MySQL instance on my > > new VPS... either remotely from > > my workstation or even with Navicat installed on the new VPS. > > Yes, it basically wipes out the root account and doesn't allow remote > connections at all. It's possible > to go on the server and use the command line to get around this and add a new > root account...but that's > really a pain to do if you are not familiar with doing command line functions > on MySQL. It also drove me > nuts that if you create MySQL databases through Plesk, it insists on each one > having its own login. > Suffice to say, I'd need a *really* good reason to let Plesk anywhere near > one of my servers again. ;-) > > > > I was told that to work on the server directly while having Plesk > > running at the same time could > > cause some conflicts. > > Not so much conflicts (although that certainly might be a possibility)...just > that you can have stuff > that you've added/created on the server that doesn't show up in Plesk so can > add to some confusion. > > > --- Mary Jo > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
