Home arrow Java arrow Page 4 - Installing MySQL With MySQLGraphic
JAVA

Installing MySQL With MySQLGraphic


Sure, you've used PHPMyAdmin, but have you heard of MySQLGraphic? In this article Peter shows us what it is and what it can do for us...

Author Info:
By: Peter Lavin
Rating: 5 stars5 stars5 stars5 stars5 stars / 7
June 23, 2003
TABLE OF CONTENTS:
  1. · Installing MySQL With MySQLGraphic
  2. · Configuring MySQL Java
  3. · Installing MySQLGraphic
  4. · Downloading and Installing the Demo Database
  5. · Conclusion

print this article
SEARCH DEVARTICLES

Installing MySQL With MySQLGraphic - Downloading and Installing the Demo Database
(Page 4 of 5 )

Go to the MySQLGraphic home page – that’s probably where you got this file. Click on the Demo Database link. Download the demodb.sql file. If double-clicking this link opens the file in your browser right-click instead and choose Save Target As. You should now have a file called demodb.sql in your download directory.

You now need to return to the command line for one last time. Open a DOS window in your download directory and start mysql. When the mysql prompt appears type CREATE DATABASE demodb; You typed the semi-colon, right? Type quit to return to the DOS prompt. Load the file, demodb.sql, into this database by typing, mysql demodb < demodb.sql. Start MySQLGraphic and open the demodb database. You’ll find numerous tables already populated with data.

Look at the contents of demodb.sql in a text editor. Soon you’ll be creating databases for yourself.

Troubleshooting

Mysql

Error 2003: Can’t connect to mysql server on ‘localhost’ (10061)

If you have this error be sure to run winmysqladmin.exe before attempting to connect to the database.

mysql is not recognized as an internal or external command

Set your PATH variable to the bin directory where mysql is installed. See the instructions above on setting the PATH variable.

Driver

MySQLGraphic starts up but you receive the error message “Error org.gjt.mm.mysql.Driver

This error means that Java cannot find the driver file. If you have installed the driver in the ext directory as described above then the problem may be that you have more than one runtime environment on your computer.

Do a search for the directory ext as pictured below being sure to include the quotation marks:

Place a copy of the driver file in those other ext directories. If this fails to solve the problem add the following line to your autoexec.bat file:

CLASSPATH=%CLASSPATH%;C:\<path to driver>\ mysql-connector-java-3.0.8-stable-bin.jar

Replace the <path to driver> with the actual path. Reboot your machine and try again.

MysqlGraphic

Nothing happens when you try to run the MySQLGraphic programme.

Perhaps there is no path to the directory that contains the Java binary files. Search for the file java.exe. Add the directory that contains this file to the PATH variable. See the instructions above for altering the PATH variable. Make sure that MySQLGraphic1.2.5.jar is in the current directory.

You receive the error message “Error- Server connection failure during transaction. Attempted connection 3 times. Giving up …

Check the information that you typed into the log-in screen. Is it correct? If it is then make sure that winmysqladmin is running. Look for the stoplight icon in the start-up tray.


blog comments powered by Disqus
JAVA ARTICLES

- Java Too Insecure, Says Microsoft Researcher
- Google Beats Oracle in Java Ruling
- Deploying Multiple Java Applets as One
- Deploying Java Applets
- Understanding Deployment Frameworks
- Database Programming in Java Using JDBC
- Extension Interfaces and SAX
- Entities, Handlers and SAX
- Advanced SAX
- Conversions and Java Print Streams
- Formatters and Java Print Streams
- Java Print Streams
- Wildcards, Arrays, and Generics in Java
- Wildcards and Generic Methods in Java
- Finishing the Project: Java Web Development ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials