I'm managing a wordpress site for a university organisation but it is
hosted under another person's name. I want to upgrade the wordpress
installation so I need access to the database. Usually I would just
use phpmyadmin to back up the databases but because the account is not
owned by myself, I only have access to the database itself.

How can I connect to the database from my computer? Can I set up
phpmyadmin to do this or do I need to use a different program?

Thanks very much for your help!

Fluffy654 wrote:
MySQL can accept connections from other systems. But it has to be set
up to accept connections from external systems, there must be no
firewall blocking the MySQL port, your MySQL signon must be allowed to
sign on from other hosts, and it must have the authority do do what you
need.

Security conscious installations will not allow such access, especially
via PHPMyAdmin. It is a huge security exposure.

Additionally, although you could change the tables, you would not be
able to upgrade the WordPress files.

If you're managing the site, you should have the authority do do what
you need.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Jul 5, 7:27*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
Heya Jerry,
Thanks very much for your reply. Yes it is quite locked down. However,
I am assuming that I do have the necessary permissions otherwise I
would not have been asked to access it in this way.

So just to clarify:
If I have the password, username and host of the mysql server, can I
not create new databases etc from a remote location? If we assume that
the security will let me through, how do I go about actually
establishing a connection? Thus far I have only ever accessed a
database via phpmyadmin on a local server and using the online tools
of various hosts. When I google a remote connection, the only results
are on how to set up a database to allow remote access but how do I
actually do the remote access bit? Sorry if this is a really basic
question.

Thanks!

Fluffy654 wrote:
If all of the above are true, yes. But that is NOT something you can
assume.

For how to do it in PHPMyAdmin, try the PHPMyAdmin support forums. It
has nothing to do with MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Jul 5, 11:56*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
Cool thank you!

A. Dischner wrote:
But it doesn't matter if you're using MySQLAdministrator, PHPMyAdmin,
the CLI or any other tool. The problem is going to be with the server's
security.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================