Installation for mysql is similar to installing apache server and php on Ubuntu.
Step1:- Open terminal window and type the below command(install mysql-server)
sudo apt-get install mysql-server
- Add root password in the dialog box after installation.
- Incase any pop up comes during installation just accept the default and continue the installation process.
Step2:- Install workbench(IDE) to work with MySql
sudo apt-get install mysql-workbench
Step3:- Start mysql workbench
a)Type the below command in terminal
b)Open the default localhost instance and add “root” password.
Note:- You can add workbench to launcher and open it from terminal as well from launcher.
Step4:- Create schema(database) in workbench.
a)Databases > New
b)Add schema name, select collation value say “utf8” > Apply > Close
c)Now we can create our tables inside the database.
So now we have Apache, MySQL, and PHP running on Linux, the complete LAMP stack.