Install and Configure MySql on Linux? – User friendly Tech help
nInstallation for mysql is similar to installing apache server and php on Ubuntu.
nStep1:- Open terminal window and type the below command(install mysql-server)
nsudo 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
nsudo apt-get install mysql-workbench
Step3:- Start mysql workbench
na)Type the below command in terminal
nb)Open the default localhost instance and add “root” password.
nNote:- You can add workbench to launcher and open it from terminal as well from launcher.
nStep4:- Create schema(database) in workbench.
na)Databases > New
nb)Add schema name, select collation value say “utf8” > Apply > Close
c)Now we can create our tables inside the database.
nSo now we have Apache, MySQL, and PHP running on Linux, the complete LAMP stack.