A s a student or a developer, most of the time we have to create applications which can be for an assignment, a project or a prototype. Setting up a database can be time consuming. Most developers will argue that everything can be done easily in the Cloud nowadays and it can be free of cost if we are not using much data. However, this article is really to get you started real quick in 2 minutes without having the hassle to connect to the Cloud and avoid any configuration issues.
Moreover, one advantage to this solution is that you do not need to install anything on your PC. Everything is portable. Once you are done with your demo prototype you can swipe clean the whole database. This is also suitable for developers having administration rights restricted on their PC.
So here’s the list of steps to get started real quick.
## MySQL Installation and Configuration
# 1. Install mySQL standalone server Db
Download the zip package of [MySQL Server Community Edition](https://dev.mysql.com/downloads/mysql/).
#2. Once download completed, unzip and launch a Dos command prompt on the bin directory.
Run the following command as follows to start the server console.
>mysqld — initialize-insecure
>mysqld — console
This will run the Db as a daemon.
#3. Launch another Dos command prompt to set the root password.
>mysql -u root — skip-password
>Alter user ‘root’@’localhost’ identified by ‘mypassword’;
>\q
Note: You have to go to the bin directory to run the mysql command.
#4. Connect to the MySql using command promp to verify if the password is set correctly
>mysql -u root -p
#5.. Run MySQL SQL command to create Db or any other SQL manipulation.
Connect to MySql as per step above.
Run the following set of commands as listed below to setup the database.
>CREATE DATABASE sample;
>USE sample;
>CREATE USER ‘johndoe’@’localhost’ IDENTIFIED BY ‘123456’;
>GRANT ALL PRIVILEGES ON *.* TO ‘johndoe’@’localhost’;
This solution has helped get started real quick when having to create several applications runing on several database on my PC especially for development. Instead of installing differeny mySql versions each time or Postgres or Oracle on my PC, this solution helps to maintain a clean environment on my PC for my different projects. Hope this helps.
