vogella.de

MySQL is a famous open source database which can be used free of charge. MySQL is a relational database. Web applications frequently are using MySQL for storing persistence data.

This article covers the installation of MySQL and the usage of the database.

To use MySQL with Java see MySQL and Java Tutorial .

Once MySQL is installed and running you can connect to your database and perform commands in MySQL.

MySQL offers the option to connect to the database via the command line. Under Window, select Start -> Programs -> MySQL -> "your version" ->MySQL Command Line Client. This will a console and ask you for the password of the DB admin.

Under Unix / Linux you can use the following command:

			
mysql db_name -u user -pmypassword
		

Start the MySQL command line client and paste the following SQL script into it to create a sample database which we can use as an example.

			
create database feedback;
use feedback;
CREATE USER sqluser IDENTIFIED BY 'sqluserpw'; 
grant usage on *.* to sqluser@localhost identified by 'sqluserpw'; 
grant all privileges on feedback.* to sqluser@localhost;

CREATE TABLE COMMENTS (
		id INT NOT NULL AUTO_INCREMENT, 
		MYUSER VARCHAR(30) NOT NULL,
		EMAIL VARCHAR(30), 
		WEBPAGE VARCHAR(100) NOT NULL, 
		DATUM DATE NOT NULL, 
		SUMMERY VARCHAR(40) NOT NULL,
		COMMENTS VARCHAR(400) NOT NULL,
		PRIMARY KEY (ID)
	);

INSERT INTO COMMENTS values (default, 'lars', 'myemail@gmail.com','http://www.vogella.de', '2009-09-14 10:33:11', 'Summery','My first comment' );

		

Please see SQL Tutorial for the usage of SQL commands.

Thank you for practicing with this tutorial.

Please note that I maintain this website in my private time. If you like the information I'm providing please help me by donating.

For questions and discussion around this article please use the www.vogella.de Google Group. Also if you note an error in this article please post the error and if possible the correction to the Group.

I believe the following is a very good guideline for asking questions in general and also for the Google group How To Ask Questions The Smart Way.

http://www.mysql.com MySQL homepage

http://dev.mysql.com/downloads/ Download link for MySQL

http://forums.mysql.com/ MySQL forum