Mysql And Phpbb

[pompey_john]

Hello,

 

I was just wondering how people connect to their mysql databases? At the moment I am using the php admin tool in the cpanel. Although its functional it's not great.

 

I use to love a tool called toad which worked with Oracle databases. Does anyone know of anything similar for mysql, and have they got it working with the remote databases at TCH??

 

thanks

John

[carbonize]

The best, and most widely used, is phpMyAdmin. http://www.phpmyadmin.net

Curious as to why you put phpBB in the title ?

Edited March 27, 2005 by carbonize

[owatagal]

I use YourSQL for quick work/updates. It's ok (and free), although I don't think it's that much better than PHP MyAdmin. I had the chance to use NavCat once, and that's a very nice program if you want to pay the fees for it.

[carbonize]

total choice provides you with phpMyAdmin in your control panel somewhere. Most hosts do.

[borfast]

I recommend MySQL Administrator. It's free, works on multiple operating systems and is made by the same folks that make MySQL. I haven't had the chance to work a lot with it but it seems to be pretty good. I don't think it's as feature packed as phpMyAdmin but for regular database administration it works just fine and it's faster than loading a webpage for each action you do.

[pompey_john]

I recommend MySQL Administrator.

 

Thanks I'll look into that. Interestingly I just found that TOAD have made a TOAD for Mysql so will download that and have a play as well.

 

I don't think it's as feature packed as phpMyAdmin but for regular database administration it works just fine and it's faster than loading a webpage for each action you do.

<{POST_SNAPBACK}>

 

That is exactly what I'm after, I dont really need all thee bells and whistles - and certainly not loading a web page each time.

 

Does anyone have any experience of accessing dbs remotely? I'm guessing the port would be the one shown in the url when opening myphpadmin. But what would the host be? If anyone knows much appreciate the answer, If not I'll create a ticket and post the syntax here.

 

(it's lovely and sunny in England today! wooo hoooo)

 

John

[TweezerMan]

I have MySQL Administrator installed here at home - it's geared towards managing a MySQL server. Many of the tools it provides are not usable by you on TCH's SQL servers, because you won't have sufficient permission to use those functions.

 

Depending on what you're wanting to do, the MySQL Query Browser may meet your needs better (and it's also made by the people who make MySQL).

 

Does anyone have any experience of accessing dbs remotely? I'm guessing the port would be the one shown in the url when opening myphpadmin. But what would the host be? If anyone knows much appreciate the answer, If not I'll create a ticket and post the syntax here.

Before you can connect to the MySQL server with any program, you have to give yourself (your home PC) permission to do so.

 

In your CPanel, go to "MySQL Databases". Near the bottom of the page is a section titled "Access Hosts". Enter your home PC's IP address then click the "Add Host" button. (If you're not sure what your home IP address is, go to whatismyip.com in your browser.)

 

In whatever MySQL client program you use, the hostname will be your (TCH-hosted) domain name, and the port is 3306 (which should be default).

[pompey_john]

Thank you so much David, fantastically helpful. I can now tinker away on my home machine and not have to refresh after each change.

[carbonize]

You don't have to refresh with phpMyAdmin. It informs you of what changes it is going to make and what it has made.