Is there a GUI tool for MySQL?

Reply

Join Date: Nov 2006
Posts: 21
Reputation: hkBattousai is an unknown quantity at this point 
Solved Threads: 0
hkBattousai's Avatar
hkBattousai hkBattousai is offline Offline
Newbie Poster

Is there a GUI tool for MySQL?

 
0
  #1
Feb 24th, 2007
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.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,244
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 540
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: Is there a GUI tool for MySQL?

 
0
  #2
Feb 24th, 2007
Linux or windows?
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Nov 2006
Posts: 21
Reputation: hkBattousai is an unknown quantity at this point 
Solved Threads: 0
hkBattousai's Avatar
hkBattousai hkBattousai is offline Offline
Newbie Poster

Re: Is there a GUI tool for MySQL?

 
0
  #3
Feb 24th, 2007
Originally Posted by jbennet View Post
Linux or windows?
Windows XP is installed my computer, but I don't know about the server.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,244
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 540
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: Is there a GUI tool for MySQL?

 
0
  #4
Feb 24th, 2007
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,212
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 489
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Is there a GUI tool for MySQL?

 
0
  #5
Feb 24th, 2007
jbennet unfortunately I have to corect you.
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
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Oct 2005
Posts: 523
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: Is there a GUI tool for MySQL?

 
0
  #6
Feb 25th, 2007
Originally Posted by peter_budo View Post
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.
Note to self... pocket cup
Reply With Quote Quick reply to this message  
Join Date: Nov 2006
Posts: 21
Reputation: hkBattousai is an unknown quantity at this point 
Solved Threads: 0
hkBattousai's Avatar
hkBattousai hkBattousai is offline Offline
Newbie Poster

Re: Is there a GUI tool for MySQL?

 
0
  #7
Feb 25th, 2007
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 :
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.
Reply With Quote Quick reply to this message  
Join Date: Oct 2005
Posts: 523
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: Is there a GUI tool for MySQL?

 
0
  #8
Feb 25th, 2007
Originally Posted by hkBattousai View Post
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
Note to self... pocket cup
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MySQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC