944,183 Members | Top Members by Rank

Web Development > Databases > MySQL > Is there a GUI tool for MySQL?
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 2373
  • MySQL RSS
Permalink
Feb 24th, 2007
0

Is there a GUI tool for MySQL?

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
hkBattousai is offline Offline
33 posts
since Nov 2006
Permalink
Feb 24th, 2007
0

Re: Is there a GUI tool for MySQL?

Linux or windows?
Moderator
Featured Poster
Reputation Points: 1800
Solved Threads: 575
Moderator
jbennet is offline Offline
16,534 posts
since Apr 2005
Permalink
Feb 24th, 2007
0

Re: Is there a GUI tool for MySQL?

Click to Expand / Collapse  Quote originally posted by jbennet ...
Linux or windows?
Windows XP is installed my computer, but I don't know about the server.
Reputation Points: 10
Solved Threads: 0
Light Poster
hkBattousai is offline Offline
33 posts
since Nov 2006
Permalink
Feb 24th, 2007
0

Re: Is there a GUI tool for MySQL?

http://www.mysql.com/products/tools/administrator/
Moderator
Featured Poster
Reputation Points: 1800
Solved Threads: 575
Moderator
jbennet is offline Offline
16,534 posts
since Apr 2005
Permalink
Feb 24th, 2007
0

Re: Is there a GUI tool for MySQL?

jbennet unfortunately I have to corect you.
Quote originally posted by http://www.mysql.com/products/tools/administrator/ ...
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
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 875
Code tags enforcer
peter_budo is offline Offline
6,659 posts
since Dec 2004
Permalink
Feb 25th, 2007
0

Re: Is there a GUI tool for MySQL?

Click to Expand / Collapse  Quote originally posted by peter_budo ...
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
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.
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005
Permalink
Feb 25th, 2007
0

Re: Is there a GUI tool for MySQL?

Everybody says PHPMyAdmin is how a useful program. I installed it on my computer. And it gave an error like this :
Quote ...
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 :
http://img92.imageshack.us/img92/7362/fieldskx8.jpg
How should I fill in these fields?

PS : Database is not on my computer. It is on a real web server.
Reputation Points: 10
Solved Threads: 0
Light Poster
hkBattousai is offline Offline
33 posts
since Nov 2006
Permalink
Feb 25th, 2007
0

Re: Is there a GUI tool for MySQL?

Click to Expand / Collapse  Quote originally posted by hkBattousai ...
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 :
http://img92.imageshack.us/img92/7362/fieldskx8.jpg
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
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: SELECT COUNT(*) Optimization
Next Thread in MySQL Forum Timeline: What's wrong with my query?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC