Darksurf: clean up

2010-04-14T19:14:48Z

clean up

New page

Remember to do all this as root! Meaning use sudo before every command or sudo su once before starting this guide.

1)
First install mysql using the package manager of your choice.
{{Console|
<pre class="clear">
equo install mysql jdbc-mysql dev-java/sun-jdk
</pre>}}
Now that we have the packages installed, the JDK needs mysql-jdbc.jar in the extensions folder to recoginize its installation so
{{Console|
<pre class="clear">
cp /usr/share/jdbc-mysql/lib/mysql-jdbc.jar /opt/sun-jdk-1.6.0.17/jre/lib/ext/
</pre>}}

2)
Then prepare the mysql database for use and start the mysql process. Run the following commands to prepare the database.
{{Console|
<pre class="clear">
/usr/bin/mysql_install_db; /etc/init.d/mysql start
</pre>}}

NOTE: some people have reported problems with mysql acting funny when these commands are ran. If you experience issues. Try
{{Console|
<pre class="clear">
/etc/init.d/mysql zap
</pre>}}
then try step 2 again to see if it works.

3)
Also prepare root for use by giving the administrator (root) a password using the following command.
{{Console|
<pre class="clear">
mysqladmin -u root password 'new-password'
</pre>}}

4) (optional)
If you want MySQL to start automatically everytime you bootup or turn on your computer then run
{{Console|
<pre class="clear">
rc-update add mysql
</pre> }}
If you don't mind starting the mysql server manually whenever you want to use it run (as root or superuser)
{{Console|
<pre class="clear">
/etc/init.d/mysql start
</pre>}}
and login using a terminal like usual (not in root terminal)
{{Console|
<pre class="clear">
mysql -u root -p
</pre>}}
Now download a java IDE to develop your java application. One preference is Netbeans. Its free and created by the people who developed java in the first place. I believe this is the best choice. You are welcome to use whatever you prefer, but this how to will use netbeans-6.8 ;)

go to [http://netbeans.org/] and download the latest version of netbeans. Make sure you pick the java version, or the ALL version.
Netbeans is an IDE for more than Java, but an IDE for Java SE, Java FX, (basically all of java), C++, PHP, and Ruby.

now right click the netbeans.sh file you downloaded and click properties, then click Permissions, and check box "is executable"
OR if you are using something other than KDE, type in root terminal
{{Console|
<pre class="clear">
chmod +X /Downloads/netbeans-6.8-ml-java-linux.sh
</pre>}}
Now that it is executable in a user terminal (non-root as root cannot access X sometimes) type
{{Console|
<pre class="clear">
cd ~/Downloads/
sudo ./netbeans-6.8-ml-java-linux.sh
</pre>}}
It should start an installation window. click customize and uncheck any checkboxes under "Runtimes".
You really don't need these unless you know what you are using them for.
Select OK, agree to license, and now you should see "Netbeans IDE installation folder"
It will want to install in "/usr/local/netbeans-6.8"
For simple reasons its not in the package manager we want to seperate it from the rest of the system
so we can have a clean uninstall when you wish to remove it later or upgrade.
So change that to "/opt/netbeans-6.8" and click install.

If you would like some code to look at to get a feel or an idea on how to write some java jdbc code. I would be happy to
send you some code I wrote while in my database class in college. Just email me [mailto:piroisl33t@yahoo.com]

Now you have netbeans, jdbc, and mysql installed! Happy coding!

HOWTO: Setup MySQL and JDBC for java to database programming - Revision history

Darksurf: clean up