Install MySQL in Ubuntu

By Computer Geeks -

What is a Database?

Database is an organized collection of data stored electronically and managed by a software categorized as Database Management System (DBMS).  DBMS software assists the user to perform CRUD operation(Create, Read, Update and Delete) on data. Apart from that DBMS also helps user in control data access. Database is categorized as Relational and Non-Relational Database but not limited to.

MySQL is a Relational Database Management System which uses SQL.

SQL is a Structured Query Language is used to perform database operation.

Before installing MySQL be clear on the purpose of installation. 

MySQL server allows user to host multiple database and provides query interface.

MySQL client allows user to connect to the MySQL server to use the query interface.

Not everyone may need MySQL Server.

Install MySQL client

sudo apt-get install mysql-client

Install MySQL server

Note that installing mysql-server will also install mysql-client no need to install it seperately. 

sudo apt-get install mysql-server

To check MySQL installation

mysql --version

To connect to mysql server enter into root access

sudo mysql

Or you can also use the below commands
sudo bash

Then,

mysql

Then you can start creating users and databases as desired.

Create User

create user 'cg'@'localhost' identified by 'password';

Note : This user can only be accessed from 'localhost' as constrained while creating the user.

To quit 

exit

Authenticate using the created user

Kudos ! You have successfully created a user.


Comments

Post a Comment

Popular posts from this blog

How to install Apache Tomcat in Ubuntu

By Mystique writer -
This post will describe how to install and configure Apache Tomcat. Apache Tomcat is a Servlet Container for Java-based Web Application. It is an open source software developed by Apache Software Foundation. It has three major Components Catalina (Servlet Container) Coyote (HTTP connector) Jasper (JSP engine) Software Version used in this post were as follows: Tomcat v9.08, Ubuntu 18.04 and Java JDK Step 1  Install Java Step 2 Create Tomcat User Step 3 Install Tomcat Step 4 Configure Tomcat Step 5 Manage Credentails Step 6 Start Tomcat ----------------------------------- STEP 1 : INSTALLING JAVA If Java JDK is not available install it. First, update the package index $ sudo apt-get update Then install Java JDK $ sudo apt-get install default-jdk STEP 2 : CREATE TOMCAT USER Create new tomcat group $ sudo groupadd tomcat  Create tomcat user with a home directory where we can install tomcat(/opt/tomcat) $ sudo useradd -s /bin/false -g groupname -d direc...
Read more

How to install MRTG on UBUNTU

By Mystique writer -
How to install MRTG on UBUNTU ---------------------------------------------- This post will describe how to install and configure MRTG( Multi Router Traffic Grapher )  which is a free software for monitoring and measuring the traffic load on network links. It helps the use the network traffic load over time in a graphical form.  Software Version used in this post were as follows: Ubuntu 18.04 SNMP v3 MRTG-2.17.4 Step 1 Install SNMP Step 2 Configure SNMPD Step 3 Install MRTG Step 4 Configure MRTG Step 5 Configure Apache Server Step 6 Finishing the Installations --------------------------------------------- STEP 1 : INSTALLING SNMP sudo apt-get update sudo apt-get install snmp sudo apt-get install snmpd STEP 2  : CONFIGURE SNMPD sudo nano /etc/snmp/snmpd.conf Change # Listen for connections from the local system only agentAddress udp:127.0.0.1:161 # Listen for connections on all interfaces (both IPv4 *and* IPv6) #agentAddress udp:161,udp6:[::1]:161...
Read more

How to install MongoDB in Ubuntu

By Mystique writer -
How to install MongoDB in Ubuntu --------------------------------------------- This post will describe how to install and configure MongoDB. MongoDB is  an open source document database and of type no sql. It stores data in the form of JSON( JavaScript Object Notation ) as a combination of documents and collection. It is highly scable and performance Software Version used in this post were as follows: MongoDB v3.6 and Ubuntu 18.04 Step 1 Creating Source list file Step 2 Installing MongoDB Step 3 Start the Mongo Deamon Step 4 Configure User for MongoDB -------------------------------------------------------------- STEP 1 : CREATING SOURCE LIST FILE Importing the public key sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 Creating Souce list File echo "deb http://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.6 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.6.list STEP 2 : INSTALLING M...
Read more