LIUNX Environment Installation MySQL

1.1 to view the installation path for MySQL:

[[email protected] ~]# Whereis MySQL

MySQL:/usr/bin/mysql/usr/lib/mysql/usr/share/mysql/usr/share/man/man1/mysql.1.gz

1.2 to view the installation package for MySQL:

[[email protected] ~]# rpm-qa|grep MySQL

mysql-community-client-5.6.26-2.el6.i686

Mysql-community-release-el6-5.noarch

mysql-community-common-5.6.26-2.el6.i686

mysql-community-libs-5.6.26-2.el6.i686

mysql-community-server-5.6.26-2.el6.i686

1.3 uninstall MySQL

[[email protected] ~]# Yum remove MySQL

to delete a MySQL database file :

Delete /var/llib/mysql Catalogue

1.4 install mysql

Step One: download the mysql yum source package for Linux from the official Oracle website .

The second step: upload the Yum source package to Linuxand install it.

[email protected] ~]# Yum Localinstall mysql-community-release-el6-5.noarch.rpm

[email protected] ~]# Yum install Mysql-server

Step three: Start MySQL

[[Email protected] ~]# service mysqld start

Fourth Step: set the password for the root user

[[email protected] ~]#/usr/bin/mysqladmin-u root password ' root '

Fifth step: Remote connection Authorization

GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;

Note:' myuser ',' mypassword ' need to be replaced with the actual user name and password.

Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT OPTION;

LIUNX Environment Installation MySQL