Som, they have guides on how to install phpmyadmin and SFTP comes with every web app you make. The phpmyadmin installation is pretty painless - I'm a noob as well and I was able to set it up without an issue by following their guide and succeeded in under 5 minutes. SFTP works the same as FTP - I use FileZilla. When you make a user on serverpilot you can edit their password, and I think (not 100% sure) that's what you use to log into the SFTP service where you can upload your site files like normal. They don't provide an email client. They cite a lack of security in self-hosted mail servers as a reason, and they recommend just to use Google Apps for business (5$/month, comes with branded emails i.e email@example.com) but also provide links to other guides in installing self-hosted email servers. I should note that emailing through php scripts still works.
[PHPmyAdmin ](http:// "https://serverpilot.io/community/articles/install-phpmyadmin.html")
I've been using it since Nov -- *November 26, 2013 12:22:49 AM UTC-4 (7065 hours) * in conjunction with one of my Amazon AWS servers to host some Wordpress, ExpressionEngine instances etc. I currently have 7 apps loaded and it's been flawless this entire time.
They get a 5/5 as a provider from me. I had some issues deploying a vagrant environment using them and they were right there to provide all the help I needed and got me up and running.
Their ability to create apps quickly for testing is unbelievably and easy and quick which has been so helpful. I haven't logged into my AWS server via terminal in 6+ months. 100% worth the time and the money.
The service they provide is so good, I actually seek people asking about it so I can recommend it because I want to see them be successful as I would hate to live without their service!
Silver Pilot is a good service, but you have to trust these guys a lot, because you have to entrust them your data, your app, your creditcard number... They rule your server , they can run on it whatever they want. And you are responsible for your server... So, it's really good service, I tested it, it's easy, it's powerful, but who are these guys, should we trust them?
i have been using serverpilot for about one and half month. it's easy for non-techie guy as well. it's very stable too until today,all of my sites are suddenly down at the same time due to mysql databse problems. i actually did nothing, don't know if it's the system updating to new version of phpmyadmin i will update this post later.
I love what ServerPilot brings in simplicity. There are a few things that I don't like with them.
Not a fan of not being able to control the firewall, well at least through SP. You have to disable SP control and handle it through command line.
I think the price is a little inflated when you compare the features with cPanel, etc. Especially with the "business" plan. Honestly that plan should have the features moved to the $10 plan and have the enhanced support be a separate package. Makes it cost more than many of the servers I run.
Little more control on the database would be good.
Overall though great idea/service. I am following them to see where they go. I am using them on smaller projects right now.
I was looking to get off shared hosting, but did not want to deal with a ton of command lines and tutorials that are all slightly different as I learn what to do.
Server Pilot was much easier than I thought it would be. I spent some time watching the couple of youtube videos posted and read through some of the tutorials to get an idea of where I was headed. Everything was easy.
The first wp site I brought over was example1.com/blog and that went smoothly into example1.com/blog. Next up example2.com, obviously smooth. And then I went from example3.com/wp to example3.com.
On a windows machine I used putty for the initial install and filezilla for all the file transfers. phpmyadmin was easy enough to copy over and use. After the first go through, it took me about 5 minutes to transfer (minus the moving of files) the 2nd website over.
Hint: Using cloudflare upfront did not work out very well. I could not flush my DNS through router reset (Edgerouter Lite), flushdns or emptying the DNS in chrome. Eventually went to DO nameservers and it worked.
Next up is moving my business website over as that's why I was playing around with these little sites, to experiment. They should offer the logging for $1/month or something to capture those of us who probably won't pay for this, but want to send some money over. Should be more inline with pricing of ($5) DO droplets.
You know, I think serverpilot is great, though I am deeply saddened that they made adding users a premium feature.
You want to limit the number of users, fine... but to say that apps on the free account should all run under the same user is super stingy of them and I would think a security concern.
I pay for my own personal account - but when I set up a DO server for my clients, I use serverpilot to kick it off, they don't need all the other features in the premium plans - I am sending them clients that may or may not convert to premium ones, I can;t say - regardless they should just be able to have at least one custom user.
Been using it for the past 3 weeks and so far only positive things to say (fast, well thought, great helpdesk, works with several providers including OVH in Europe). Also, I prefer their user interface vs. cloudways.
Now I'll see in 6-months how their service evolve (new functionalities, etc. - I also made some suggestions to them by email).
If someone wants to give it a try, here is my referral link for a free 10USD (even though their basic offer is free).