Install and Configure MySql on Linux? – User friendly Tech help

Frank Herbert
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)
n
nsudo apt-get install mysql-server

n
nNote:-

n

    n

  • Add root password in the dialog box after installation. 
  • n

  • Incase any pop up comes during installation just accept the default and continue the installation process.
  • n

n

Step2:- Install workbench(IDE) to work with MySql
nsudo apt-get install mysql-workbench

n

Step3:- Start mysql workbench
na)Type the below command in terminal
nmysql-workbench 
nb)Open the default localhost instance and add “root” password.

nn

nNote:- You can add workbench to launcher and open it from terminal as well from launcher.
n
nStep4:- Create schema(database) in workbench.
na)Databases > New
nb)Add schema name, select collation value say “utf8” > Apply > Close

nn

c)Now we can create our tables inside the database.
n
nSo now we have Apache, MySQL, and PHP running on Linux, the complete LAMP stack. 

Was this article helpful?
YesNo

Similar Posts