I’m about to hire an outside company to build out a new database for my website. I have already created the database through cPanel (new user/pw) and can access it or modify it through PHPMyAdmin.
What I need to know is if it were possible to give the outside company the information for only the new database, such as user/pw and database name, and can they access and work on the database without the need of going through cPanel?
I would like to protect all my other info, and only allow access to what they need to work on.
.
If your database is not too big, why not use MySQL to export your database, possibly in a zip format and just give the database creation SQL file to the outside company? No need for them to access your site, etc
What I need to know is if it were possible to give the outside company the information for only the new database, such as user/pw and database name, and can they access and work on the database without the need of going through cPanel?
Yes, you can. You need to give them the necessary credentials (server info, IP or host name, username, pass, database name). They need to give you the IP(s) that they’ll be connecting from. Then you go to “Remote Mysql” in cPanel and add them there.
Now they will be able to connect to your mysql server and do anything they need to.