•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 402,961 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,741 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1679 | Replies: 7
 |
•
•
Join Date: Nov 2006
Posts: 19
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
Is there a GUI tool for MySQL? 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.
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.
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 268
•
•
Join Date: Nov 2006
Posts: 19
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by jbennet 
Linux or windows?
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 268
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,243
Reputation:
Rep Power: 10
Solved Threads: 270
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
•
•
•
•
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)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 31
Posting Pro in Training
•
•
•
•
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.
Note to self... pocket cup
•
•
Join Date: Nov 2006
Posts: 19
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
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.
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.
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 31
Posting Pro in Training
•
•
•
•
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
Note to self... pocket cup
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Apache (Linux Servers and Apache)
- very newbie (mysql) question (MySQL)
- new to mySQL (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: SELECT COUNT(*) Optimization
- Next Thread: What's wrong with my query?
