I have been learning Java for about 2 months getting acquainted in various technologies like Servlets , JSPs, HTML etc... I was looking for a IDE to work in and found NETBEANS.. awesome, today I somehow even started up MYSQL! in KUBUNTU! how so ever I still could'nt find anything similar to a Dreamweaver to create HTML pages in Linux... that has left me sulking...and m well aware Linux is not the IN THING with lot of people today.. I will be adding some snapshots at the end..now Installing MySQL had been a piece of cake in Windows.. In Linux I had to research a bit to find it, but found it has become very easy indeed nowdays...
I don't know about other Distributions m using a Ubuntu Linux so m gonna brief using it as a medium
So first of all you need to install a server
type this in a terminal ( in GNOME its Terminal and in KDE its' Konsole similar to a command prompt in Windows but yet much powerful)
sudo apt-get install mysql-server
it will install the mysql server , during installation it will ask for password for the root user, type in 1234 or anything you may like
Now since we all have become so much accustomed to using Gui's for almost anything we definitely would'nt want to type every time some commands in terminal to work with it.. besides it's time consuming too..
so now we'll install the GUI for MYSQL feeling Happy??
so what we need to do is type in the command
sudo apt-get install mysql-gui-tools-common
this will install (MySQL Admin+MySQL Query Browser+MySQL Migration Toolkit)
now to start the MYSQL go to MYSQL Query Browser from your menu
on clicking it will give the following window.
type in root in the user field and the password (Whatever you gave during Server Installation...)
and voila it connects happy SQLING in LINUX!!!
I am searching how to connect MYSQL with java programs in netbeans.. as soon as I know that I will post it..
Thanks for stopping by... Do leave a comment if it helped CYAO!!!:)