CentOS 6.4 mysql rpm offline Install "Memo"

Use RPM's installation package for MySQL installation in offline mode, only as a memo

• Preparatory work:

　Download MySQL offline RPM installation package (not shown here, get ready to do Demo)

　　

• Uninstall and clean up the remnants of MySQL installation and uninstallation before

1, detect the native installation of MySQL and uninstall

rpm-qa| grep -I. mysql

One of the Noarch is the source address package, not the same as the installation

2, as shown, the system has been installed in MySQL, uninstall it:

Yum Remove MySQL

Then perform the first step again to see if there is an installed MySQL presence, and if so, you can directly add Yum remove plus the package name you just found to uninstall

3, check whether the/var/lib/mysql folder exists, if there is, please delete, which contains MySQL residue database, if not deleted, the new installation of MySQL will not create a new database

If there is, delete

RM -rf/var/lib/mysql

• Install MySQL

1. Download the RPM package to CentOS before uploading and install the server first.

RPM-IVH mysql-community-server-5.6. -2. el6.i686.rpm

is normal installation, please ignore the following problems

1.1 There may be problems , such as the situation, I was very tangled up a good while, and finally the Yum install add the package name is not installed, it is very strange how much traffic is installed ... The original package said 215M, the actual I this show less than 5M ... It's weird.

2, then should install client side, but I this reported the dependence is missing, let me first load other. On my installation method:

RPM-IVH mysql-community-common-5.6. 2-ivh mysql-community-libs-5.6. 2. el6.i686.rpm  -ivh mysql-community-client-5.6.  -2. el6.i686.rpm

3. After the installation is complete, start the MySQL service:

#别问我为什么加d, it may be a different version service mysqld restart

4. Modify the default password:

#-u behind is the user name, behind the root is the password, as appropriate, modify the 'root'

5. Open the MySQL command line:

#其中--uroot-p

6, Remote connection authorization (only local use can not be set):

' Root '@'%'root' with GRANT OPTION;

7. Use Navicat to connect to the MySQL experiment in the virtual machine:

8, if the 7th step appeared

Please turn off the firewall in CentOS and temporarily close the code:

Shutdown Firewall command: Service iptables stop permanently shuts down the firewall: chkconfig iptables off

The tutorial ends.

CentOS 6.4 mysql rpm offline Install "Memo"