MySQL Database Administration Commands

To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the MySQL server. mysql> create database [databasename]; List all databases on the MySQL server. mysql> show databases; To delete a database. mysql> drop database [database name]; To delete a table. mysql> drop table... Continue Reading →

Installing MySQL 5.6 on Ubuntu 14.04

Ubuntu 14.04 defaults to MySQL 5.5, but also has MySQL 5.6 available for installation from the  universe archive. Step 1: Install MySQL Server 5.6 Install mysql-server 5.6 with apt-get command : sudo apt-get update sudo apt-get install mysql-server-5.6 To install MySQL 5.6, install the mysql-server-5.6 package instead. sudo apt-get install mysql-server-5.6 There are two ways to install MySQL.... Continue Reading →

Install MySQL Server 5.6 (CentOS/Redhat)

Introduction In October 2013, the MySQL development team officially launched support for yum repositories. This means that you can now ensure that you have the latest and greatest version of MySQL installed directly from the source!.In this guide we will install MySQL 5.6 on a fresh installation of Centos 6. Installing MySQL The yum repository... Continue Reading →

Powered by WordPress.com.

Up ↑