Tag: Mysql

Installation, MySql

How to Install MySql on CentOS server

How to install MySql on CentOS server Please check whether MySql packages are available under yum. yum list mysql* If yes, then install mysql using below command. yum install mysql* Now install the Mysql database on the server using below command. mysql_install_db It will create mysql database on mysql server.  Now, we have to reset ...

MySql, Uncategorized

How to check if InnoDB engine is enabled in MySQL

How to check if InnoDB engine is enabled in MySQL If you want to check , if InnoDB is enabled on the server , you can check this via two methods : [email protected][#] mysqladmin variables | grep have_innodb If the above command show the output as below : | have_innodb | YES then it means InnoDB ...

MySql, Uncategorized

How to take Database Backup using phpMyAdmin

How to take Database Backup using phpMyAdmin. First you need phpMyAdmin which is a MySQL Database Administration Tool. 1 - Open phpMyAdmin 2 - Click on Export 3 - Under Export - Select the database you want to backup 4 - Select SQL 5 - Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add ...

MySql, Uncategorized

Mysql Commands

Mysql Commands: How to check mysql connection or login to your Database using shell ========================= [email protected][#] 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 ...