Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : MySQL login question

[croakingtoad]

If I do not have access to the database, how can I log in to view, add, delete tables, etc.?

The host who is hosting my design client's site does not provide a control panel to access the shared MySQL server.

I have the username and password to the database my client has, is there anyway for me to login to just the database for my client so I can administer it?

As it is now, I have to contact the hosting company and have them do it, and that takes about 2 days. First I submit the support ticket one day, then 2 days later I call to ask why it hasn't been addressed yet and they do it while I'm on the phone. It would be much easier if I could use a tool or something to do it...They advise I should program a php page to make any changes, but I don't know enough about PHP to do it.

Thanks!

[nudotfm]

If you can telnet in (try www.ssh.com because it is probably secure access). Login username password.

If you get in, use mysqladmin to create delete db's etc.
mysql for table creation and data insertion.

use mysqlshow to see if you have any db's setup.

hope it helps

[kostagr33k]

you should be able to install phpmyadmin so you can control your databases ... if not they should install it for you.

Kosta

[mno]

Even if the host installs phpMyAdmin for you, it's usually an older version. I always upload my own copy. You can get phpMyAdmin from www.phpmyadmin.net for free. The set up is very easy, but feel free to PM me if you need help. Once you've set it up, simply FTP it to your account into a separate directory. I would also suggest that you password protect that directory (you don't want to the world to play around with your db, do you?)

[croakingtoad]

I have the ability to make changes by using php scripts to the MySQL database, so would phpmyadmin then work fine once I install it?

That's what it sounds like you-all are saying, and I'm very familiar with phpmyadmin, so hopefully that'll work...

[mno]

Yes, phpMyAdmin is a PHP script. It should work like this - haven't seen a host where this didn't work where there was PHP and MySQL.

Max

[jtrovato]

You could also use MySQL Front, which works great.

2 things must be in place in order to use mysql Front.

1. You are using a windows box to edit the databases
2. The Hosting company will allow you IP to access the Database remotely.


It's a free program that works great. I use it all the time, it's faster and easier to use than phpMyAdmin.

Good Luck

[jjmac78]

u using bluedomino?

[Shannara]

MySQL front is great software, if used with MySQLcc. After all, you would need to be able to insert and delete records, MySQL Front does not provide that basic functionality.