I recently completed a site and another gentleman is hosting it.
It's proving to be a bit of a challenge in that, while I thought his hosting it would provide me easy access to the files and database, apparently that isn't the case.
I've dealt with several ISPs and I've never been restricted in having access to the phpMyAdmin. When I asked him for the login credentials, I got this: "I don’t generally open up phpMyAdmin because of the security holes. I’d have to move this off a shared server to a new VM if we want to open that up so that it can’t hose anything else up."
I don't know what that means and I want to sound intelligent when I respond. Bottom line: I'm having to make some changes and edits and I don't want to always have to knock on his door to put the changes in place before it goes live. When he talks about moving it to a new Virtual Machine - frankly, I'm not familiar enough with network dynamics to understand what he's doing or why me being given access to the database is suddenly akin to signing up for a new Healthcare plan. He's a good guy, so I'm not suspecting he's being difficult, I just want to have a better idea of what's happening on his end so I can figure out how to best proceed.
Also, when I asked him for the ftp login credentials, I got this: "It going to take a little adjustment. Do you have sftp? I’ve set the owner to a user tkd and the group to apache for the web service. Anything uploaded via sftp won’t have the right permissions by default either so will have to be fixed."
I know "sftp" is either "Simple File Transport Protocol" or perhaps, "Secure File Transport Protocol," but either way, all I've ever done is use an ftp client like Fetch, enter in my login credentials and got to work. I've never encountered this many chutes and ladders in an attempt to access either the database or the files.
What is he asking for and what do I need to have in place so I can communicate with his server based on the questions he's asking?