Install the MySQL5.6 service on the CentOS Virtual Machine of Win7

Install the MySQL5.6 service on the CentOS Virtual Machine of Win7
1. Download the installation package

Mysql5.6:

Http://dev.mysql.com/downloads/mysql/

Select the linux version here:

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

-------------------------------------- Split line --------------------------------------

2 mysql Installation

Download the rpm64-bit installation package from the official website:

MySQL-5.6.16-1.linux_glibc2.5.x86_64.rpm-bundle.tar,

(1) run the following command:

Tar xvf MySQL-5.6.16-1.linux_glibc2.5.x86_64.rpm-bundle.tar

Decompress the package. The decompressed file directory is:

When you look at the file name, you will know what each package is.

(2) Check whether MySQL is installed in the system. Run the following command:

# Rpm-qa | grep mysql

Run the following command to uninstall an installed MySQL instance:

# Rpm-e-nodeps mysql-libs-5.1.61-4.el6.x86_64

Delete all files in the/var/lib/mysql folder.

(3) run the following command to install the Server and Client:

Rpm-ivh MySQL-server-5.6.16-1.linux_glibc2.5.x86_64.rpm

Rpm-ivh MySQL-client-5.6.16-1.linux_glibc2.5.x86_64.rpm

(4) run the following command to view the current mysql status:

Service mysql status

If it is running, the following message is displayed:

(5) If it is not running, run the following command to start it:

Service mysql start

By the way, you can add the startup command to the linux Startup item to start the mysql service upon startup. The command is as follows:

Chkconfig -- add mysql

Chkconfig mysql on

Run the command chkconfig-list to view the root permission.

(6) set the root password for mysql by using the following command:

Mysql-u root-p

Enter the password. The initial root password is saved in the '/root/. mysql_secret' file.

Enter mysql> set password = PASSWORD ('20140901 ');

(7) after logging in, run the following command to check the effect:

The following are the three main directories after mysql installation and their functions:

/Var/lib/mysql database file

/Usr/share/mysql command and configuration file

/Usr/bin mysqladmin, mysqldump, and other commands

3 navicat Installation

The above mysql is installed on my local VMWare, CentOS version of the system, I want to operate mysql on the local win7, you need a graphical client, this is more convenient. Navicat can be used directly. My local machine is 64-bit. If I fail to find the 64-bit cracked version on the internet, I will get a 32-bit version without affecting the usage.

For more details, please continue to read the highlights on the next page:

1 2 Next Page