Hello!

Does anyone know an online MySQL administrator which works right away after entering the server address, username and password? The reason is that I need to connect to my MySQL server at home but here at school we have a very restrictive firewall which only allows communication through port 80. Therefore I cannot use the MySQL Administrator or Query Browser. Uploading phpMyAdmin to my server doesn't work either because port 21 is blocked.

Regards,
Sebastian

Hey,

I use SQL Yog Enterprise Version 4.1:

http://www.webyog.com/sqlyog/index.php

I use it to connect via SSH Tunneling, since like you my host blocks normal remote access.

And it's fast.

Take Care,

Will

That's not what I am looking for. It shouldn't be something which I have to install somewhere or whatever. It should be like an online version of the MySQL Administrator or Query Browser where I can simply tell it to which server it should connect, which DB / user / password it should use.

Let's start with the basics. First off, port 21 is an FTP port which is probably the reason why it was disabled on the network to disable FTP connections. The default port for mySQL is port 3306. Now if this port has changed, it was the result of a human changing the port in the configuration files and has nothing to do with your firewall. If your mySQL port was really changed to port 21, then I would have to ask do you have access to change it, or do you know someone else that does. I doubt the mySQL port is blocked on a school computer just because of the nature of the program.

So my point with all this is that it doesn't matter what program you use. If the port is blocked it is blocked. Both mySQL Administrator and phpMyAdmin both run off localhost servers which means the connection that a firewall would pick up and block would be a local connection, even a connection from the same computer. The only other suggestion if you don't have access to change the configuration files would be to download the mySQL source (probably the mySQL4 source in your instance), and then unzip the source into a directory where you have access to and set up this service to run from the default port 3306, or change it to port 80 if that is the only one open.

I give up.

Folks, my school firewall only allows communication through port 80. Therefore, I cannot upload phpMyAdmin to my webserver via FTP because port 21 is blocked (since only 80 is open). I also cannot use MySQL Administrator or MySQL Query Browser because port 3306 is blocked (as I said, only 80 is open). What I need is a pre-installed phpMyAdmin somewhere on the Internet which accepts a server, a username and a password as arguments and connects to the given server.
Unfortunately, I also cannot change the MySQL service to run on port 80 because I have some other scripts on the Internet which connect to my MySQL server - and these expect the connection to take place over port 3306. Moreover, I cannot change the service to run on port 80 because I am at school - I cannot change it from here.

As I said, I'd need a website like http://www.this-is-some-cool-online-mysql-administrator.com where I can enter the details of my MySQL server and then be able to create tables, DBs...

I dont get what you mean then.

Because even using an online tool like that would be blocked. Like you said you run mysql on port 3306 which is blocked. And only port 80 is open.

So what your saying is that you could connect though port 80 via a web site that would connect to port 3306?

So how could you do that since port 3306 is blocked via firewall?

Only way I see you being able to do something like that is running a local proxy on the school pc that allows access though port 80. Though the local proxy itself points to port 3306 which is the mysql server.

This way only port 80 is really open to the outside world like normal but the proxy you run would allow port 3306. So like a forwarding proxy. Though I dobut school would let you do this? Perhaps vpn?

Something like that.

I know what you're talking about, but unfortunately I don't know of any.

Let me explain, since I seem to be the only one who understands.

Basically, like a phpMyAdmin proxy server.

http://www.domain.com/phpmyadmin - he can go there

It'll ask for his IP, database, username, and password - connect, and he can do the work through there.

Well only port 80 is open and it's for HTTP then MySQL can't use that port

surely you could just have phpmyadmin installed when your at home where you are trying to access - then use it remotely when you get to school? In other words if you have it already on the server you have at home then you shouldnt have a problem. For example to connect from school it would be http://youripaddresshere/phpmyadmin.

The problem is that I don't have it at home and I won't be at home for a few days.

war59312, when using an online administration tool, it's not the client PC that communicates with the MySQL server, but the server where the SQL administrator is installed. So, I will only communicate via port 80 with the MySQL administration software and the PC where the administrator is hosted will communicate with my MySQL server at home.

There used to be one of these that I found at one time...I'm quite sure it's been down since I found it as it probably got hammered...someone was doing an update to phpMyAdmin for just this reason. I tried finding it again but was unable to.

First off, phpMyAdmin is a file that is no more than 3kb in size. Are you not allowed to use floppys or flash drives to transfer the files over. There should be no reason to transfer the files via FTP when the computer are using a lan connection.

Second you seem to be missing the point. There is a file inside of the mySQL server directory that is usually named something like my.conf. What this file dictates is the port that mySQL operates on, and in the default case this is set to 3306. Since this port is blocked you will need to update the configuration file to allow mySQL to operate on other ports. No program will do that for you.

Once you change the port there is a way to run mySQL without using the internet. This type of connection is referred to as the socket connection in the phpMyAdmin manual which you obviously haven't read. If you read the manual it will tell you that in order to run a socket connection you will need to set up the host as localhost, the port as localhost, insert the path to the socket, and change the connection type to socket. However, keep in mind that this type of connection only works when the mySQL server lies on the same machine as the test machine. If you have to connect to a server computer then you will be unable to utilize a socket connection and the tcp/ip connection is the only other way and if this is the case it will continue to be blocked unless you can change the configuration file.

You are the one who seems to be missing the point entirely. He is looking for a phpMyAdmin-like script installed on some random remote web server that allows the user to input a server ip address, username and password to connect to a mySQL server running on a remote machine. This would be operating entirely outside the realms of whatever firewall he is behind and so will be able to access 3306 without any difficulties.

I told my dad to switch the port of the MySQL server to 80 and restart it, but for some reason, it still doesn't work. Maybe MySQL Administrator / Query Browser don't use the IE proxy settings? We can only connect through a proxy at school which runs on 10.101... or something. Direct connections don't work.

START OT

Your dad can actually stop the mySQL service, edit the my.cnf file and change in it the port 3306 to port 80? Whoa! I envy you your dad

END OT

My Dad can also program C++, VB, and Lotus.

Are you sure :80 traffic doesn't go through a proxy which requires the actual traffic to be, you know, HTTP?

Also, have you tried port 443 (SSL)? No proxy can intercept that correctly, so you're likely to get better chances.

1. No idea.
2. Port 443 is blocked - I can't seem to visit any HTTPS sites.

Wow, your school must be pretty anal - they should be allowing SSL...

It's quite normal actually - we have everything blocked but 80 for students to stop backdoors.

It's just more and more sites are using SSL, and not allowing access to those legit sites...

Also, every school I've ever been at has allowed HTTPS, too.

Well, our school doesn't expect that we do online banking or other stuff that requires a secure connection. The Internet access is there so we can look up stuff in Wikipedia or search with Google.

But that's the thing, SSL isn't only for online banking and other stuff similar.

Everything from GMail to some BB's - more and more stuff is using SSL.

So they get blocked? Big deal. Sorry for almost hijacking your topic, Sebastian, but at my school we have to request every single site we go to for it to be allowed or denied to a member of staff. Every single sudomain of a site - the entirety of things like geocities are banned because parts of it are suspect. I don't like the system from a student point of view, but I won't deny it works, and the school aren't likely to get hacked with all the ports blocked and only approved websites viewable.

oh ok i got you know

but yeah sorry dont know of such a tool atm

It's probably too late to help Sebastian, but if anyone else is looking for such a service, check out: MySQL Web Query.