MySQL is one of the most popular free database for websites. To start developing any website with dynamic content, one needs a database. A MySQL database can be created either from Command-line or with a free to use web interface, phpMyAdmin.
Creating Database from Command-line
1. Assuming that MySQL is installed, first step is to login with root user.
mysql -u root -p
-p switch is for the user password for ‘root’ user.
2. Create database
mysql> create database refulz;
3. Its better not to use the root user as the database user, so we are required to create a user ‘sql_user’ and allow the user to be able to login to the localhost with password ‘pass’
mysql> grant usage on refulz.* to sql_user@localhost identified by ‘pass';
4. Now, we may assign all privileges on database refulz to the sql_user.
mysql> grant all privileges on refulz.* to sql_user@localhost ;
Thats all the new database is ready.
Alternatively, the simple interface of phpMyAdmin can be used to perform above 4 steps. The screens are attached below:
1. Create Database
2. Assign Privileges
3. Assign Database privileges
The interface makes it really simple to create tables and perform other operations. For commands, I will cover more commands in next posts.