How to check mysql connection or login to your Database using shell
=========================
root@hostdens[#] mysql -u username -p
=========================
it will ask for password then provide the correct password.

Create Database on the Mysql Server
=========================
mysql> create database [databasename];
=========================
ex : mysql>create database Dresses;

List all databases on the sql server.
===========================
mysql> show databases;
===========================

To List all tables in the Database.

==========================
mysql> show tables;
==========================

To check the table Constraints or Describe table
==========================
mysql> describe [table name];
==========================

To Delete a Database
==========================
mysql> drop database [database name];
==========================

To delete a table.
==========================
mysql> drop table [table name];
==========================

Command to give privileges to the user

root@server[#]mysql

grant all privileges on hostdens_wrdp1.* to hostdens_wrdp1@localhost identified by ‘hostdens123′;

database name = hostdens_wrdp1
db user name = hostdens_wrdp1
db pass = hostdens123

Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostdens, a company that aims to provide reliable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.

View all posts