DEV Community

Cover image for Mysql database overview
ekholil
ekholil

Posted on

Mysql database overview

MySQL is an open-source relational database management system, typically used with PHP. But it can also be used with python, node and other languages. It is a database which is used for web based applications. It can be used in both small and large applications. Mysql called relational database management system (RDBMS)

Some features of mysql
It is fast and reliable.
It supports standard sql(structured query language)
Mysql is free to download and use.
Mysql is fully multithreaded.
Mysql works on different platforms.
It provides a transactional and non-transactional storage engine.
It can handle large applications.

Who uses mysql :
Mysql is the most popular web based database. Mysql used by
Large websites such as facebook, google, youtube, flickr etc.
Content management systems such as Wordpress, Drupal, Jumla etc.
A large number of web developers worldwide who uses mysql

How to use mysql:

If we want to use mysql it is necessary for us to have it installed whether it be on our local system or on a remote web host. However in order to connect to either we must firstly have an interface to use.
First we need to download mysql from this site : http://dev.mysql.com/downloads/.
After downloading mysql from their website we need to install it properly. The Installation process is simple.
Connecting to database :
After completing installation we need to connect with our database. For connect with mysql database open command prompt and write this following
Mysql [host] [port] username password database name
If everything is ok then mysql database will be connected. So explore the database and learn this amazing database so you can use this database in your dream project.

Top comments (0)