Jump to content

Mysql And Phpbb


pompey_john

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

 

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...