Mysql?

[DarkHavoc]

can programmers code mysql and setup databases without my cpanel login?

 

via ftp? or anything.

i dont feel good about sharing my cpanel pass

 

havoc,

[Lianna]

That's a pretty sticky question. To use the Manage MySQL and phpMyAdmin functions requires cPanel access.

 

 

If this is a temporary thing, then you can easily change cPanel passwords immediately after the access is no longer needed. ???

 

I can use MyODBC to interface a MySQL db using MSAccess, but that gets kinda tricky and I still find myself having to access phpMyAdmin for table structure stuff.

 

Anyone else got ideas here?

[TCH-Dick]

have them do everything locally, I just set up phpdev on my PC and it works like a charm. I can set up everything locally, even sql databases and make sure i have everything like i want it, then just upload

[Lianna]

oooh, there's a good alternative!

[borfast]

Darq, you can also install phpMyAdmin in your account and create a database user with a different login (as opposed to using your cpanel login to access the database).

 

That way you can use the phpMyAdmin version you installed and provide the new user/pass you created to use with phpMyAdmin.

You will still need to access the Manage MySQL tool in Cpanel if you want to create new databases but that's something you won't need to do regularly, so just set up the databases you need when you start working and then you won't need to touch the Manage MySQL stuff.

 

I'd still recommend setting everything up locally in a development box. It's easier and faster to work with. Besides, if you mess things up, it won't be on the "live" webserver, meaning your site will still be OK and you can fix whatever you did wrong without any worries.