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 …
Category: MySql
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 …
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 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 …