New and need some help, please - mysql

Hi,

I have a .php site which uses a mysql database. I would like some info
on how I can download (preferably free and simple) and use a GUI. As
in, I know they exist, but do I need to put it into the server (plesk
interface), or use it on my pc, and then how do I access the site's
database to modify entries.

And all this because I'm tired of my web-designer's unresponsiveness.

Any help appreciated.

Thanks,

Jay

Re: New and need some help, please - mysql

nurcan.kurtoglu@gmail.com wrote:
> Hi,
>
> I have a .php site which uses a mysql database. I would like some info
> on how I can download (preferably free and simple) and use a GUI. As
> in, I know they exist, but do I need to put it into the server (plesk
> interface), or use it on my pc, and then how do I access the site's
> database to modify entries.
>
> And all this because I'm tired of my web-designer's unresponsiveness.
>
> Any help appreciated.
>
> Thanks,
>
> Jay
>
Your database GUI of choice will usually be phpMyAdmin
http://www.phpmyadmin.net/home_page/index.php

If I understand correctly that you want a copy of the site on your local
machine as well, the easiest thing is to install XAMPP:

http://www.apachefriends.org/en/xampp.html

Re: New and need some help, please - mysql

Matt C wrote:
> nurcan.kurtoglu@gmail.com wrote:
> > Hi,
> >
> > I have a .php site which uses a mysql database. I would like some info
> > on how I can download (preferably free and simple) and use a GUI. As
> > in, I know they exist, but do I need to put it into the server (plesk
> > interface), or use it on my pc, and then how do I access the site's
> > database to modify entries.
> >
> > And all this because I'm tired of my web-designer's unresponsiveness.
> >
> > Any help appreciated.
> >
> > Thanks,
> >
> > Jay
> >
> Your database GUI of choice will usually be phpMyAdmin
> http://www.phpmyadmin.net/home_page/index.php
>
> If I understand correctly that you want a copy of the site on your local
> machine as well, the easiest thing is to install XAMPP:
>
> http://www.apachefriends.org/en/xampp.html

Hi Matt,

Thanks for your reply.

I really don't know (sorry). I have a database which can be accessed
through plesk (but I haven't ever opened it). I want to be able to
change some of the data on the site. Do I need to put the GUI onto the
server to do this? I know the guy who designed the site had a data
base reader, but further to that, Dunno!

Any suggestions?

Thanks

Re: New and need some help, please - mysql

nurcan.kurtoglu@gmail.com wrote:
> Matt C wrote:
>> nurcan.kurtoglu@gmail.com wrote:
>>> Hi,
>>>
>>> I have a .php site which uses a mysql database. I would like some info
>>> on how I can download (preferably free and simple) and use a GUI. As
>>> in, I know they exist, but do I need to put it into the server (plesk
>>> interface), or use it on my pc, and then how do I access the site's
>>> database to modify entries.
>>>
>>> And all this because I'm tired of my web-designer's unresponsiveness.
>>>
>>> Any help appreciated.
>>>
>>> Thanks,
>>>
>>> Jay
>>>
>> Your database GUI of choice will usually be phpMyAdmin
>> http://www.phpmyadmin.net/home_page/index.php
>>
>> If I understand correctly that you want a copy of the site on your local
>> machine as well, the easiest thing is to install XAMPP:
>>
>> http://www.apachefriends.org/en/xampp.html
>
> Hi Matt,
>
> Thanks for your reply.
>
> I really don't know (sorry). I have a database which can be accessed
> through plesk (but I haven't ever opened it). I want to be able to
> change some of the data on the site. Do I need to put the GUI onto the
> server to do this? I know the guy who designed the site had a data
> base reader, but further to that, Dunno!
>
> Any suggestions?
>
> Thanks
>

If you have the credentials to use/change data, you can just do it on a
command line, e.g. thus:

(I don't know what plesk is)

get PuTTY or some other client for remote access; connect to the server
and find the mysql program (usually named "mysql"). Suppose it's
/var/mysql ... type
/var/mysql -u [username that can edit the database] -p

should prompt for your password, type
USE [whatever the dB is called]

and you can now edit things with normal SQL statements on the command line.

Do this if you just want to change a couple of things. If you're going
to be the new administrator of the database, you will almost certainly
want to install phpmyadmin on the server. Download it, edit
config.php.inc so that it works on the server, then FTP it in there.

Re: New and need some help, please - mysql

nurcan.kurtoglu@gmail.com wrote:
> Hi,
>
> I have a .php site which uses a mysql database. I would like some info
> on how I can download (preferably free and simple) and use a GUI. As
> in, I know they exist, but do I need to put it into the server (plesk
> interface), or use it on my pc, and then how do I access the site's
> database to modify entries.
>

Are you looking for phpmyadmin? It is easy to install just upload using
FTP and you will be able to access the websites database.

> And all this because I'm tired of my web-designer's unresponsiveness.
>
> Any help appreciated.
>
> Thanks,
>
> Jay