Is there a GUI tool for MySQL?

[hkBattousai]

Hello,

I am going to study MySQL on my web server.
I would like to ask if there is a useful GUI tool for MySQL to create/delete tables and browse entries on my database.

[jbennet]

Linux or windows?

[hkBattousai]

Linux or windows?

Windows XP is installed my computer, but I don't know about the server.

[jbennet]

http://www.mysql.com/products/tools/administrator/

[peter_budo]

jbennet unfortunately I have to corect you.

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.

For MySQL to create/delete tables and browse entries in database you are more likely looking for phpMyAdmin http://www.phpmyadmin.net/home_page/index.php. However because of this little tool you will need to install Apache server and PHP on your pc(if working at home/work with limited resources). Many hosting companies have included this tool in their basic package, or you may request from them to include it.
In case you are learning on your home/work computer you may do separate instalation with help of this tutorial http://apacheguide.org/prerequisites.php, which take you step-by-step trough whole process, or you can go for whole solution from XAMPP http://www.apachefriends.org/en/xampp-windows.html which will install everything for you in one go.
Separate instalation = you may learn something new :eek:
XAMPP solution = have everything setup in one go :twisted:

[pty]

jbennet unfortunately I have to corect you.

For MySQL to create/delete tables and browse entries in database you are more likely looking for phpMyAdmin http://www.phpmyadmin.net/home_page/index.php. However because of this little tool you will need to install Apache server and PHP on your pc(if working at home/work with limited resources). Many hosting companies have included this tool in their basic package, or you may request from them to include it.
In case you are learning on your home/work computer you may do separate instalation with help of this tutorial http://apacheguide.org/prerequisites.php, which take you step-by-step trough whole process, or you can go for whole solution from XAMPP http://www.apachefriends.org/en/xampp-windows.html which will install everything for you in one go.
Separate instalation = you may learn something new :eek:
XAMPP solution = have everything setup in one go :twisted:

Yeah but MySQL Administrator and MySQL Query Browser are better if have straight access to the database. PHPMyAdmin is ok for the odd job if you don't have access on 3306 or whatever.

[hkBattousai]

Everybody says PHPMyAdmin is how a useful program. I installed it on my computer. And it gave an error like this :

cannot load mysql extension,
please check PHP Configuration
Documentation

I couldn't solve the problem, so I gave up on it.

Now I installed MySQL Administrator on my PC.
Opening screen asks for some date about the server.
Screenshot :
[IMG]http://img92.imageshack.us/img92/7362/fieldskx8.jpg[/IMG]
How should I fill in these fields?

PS : Database is not on my computer. It is on a real web server.

[pty]

Everybody says PHPMyAdmin is how a useful program. I installed it on my computer. And it gave an error like this :
I couldn't solve the problem, so I gave up on it.

Now I installed MySQL Administrator on my PC.
Opening screen asks for some date about the server.
Screenshot :
[IMG]http://img92.imageshack.us/img92/7362/fieldskx8.jpg[/IMG]
How should I fill in these fields?

PS : Database is not on my computer. It is on a real web server.

Is the MySQL server on your computer? If to leave host as 127.0.0.1

Then put your login name and password in. On windows it should have asked you for an admin password when installing; if so leave login as 'root' and put in that password

Click ok and it should connect. If not post the error back here