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.
Next: Conclusion >>
More Java Articles
More By Peter Lavin
