How to install mysql on centos 6.5?

How to install mysql on centos 6.5:

1. Upload related packages (*.tar.gz, etc.)

Use relevant software to upload or use Xshell to connect and download the command: yum install lrzsz

2. Install mysql5.7

1. Check whether mysql is installed locally: rpm -qa | grep mysql

2. Uninstall the local mysql: yum remove mysql package

3. Download the installation package from the official website yum repository : wget http://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm

or download manually And upload it to linux

Then select

I am using CentOS6.5 here, all download this

4. Install the downloaded rpm package

yum localinstall mysql80-community-release-el6-3.noarch.rpm

5. Check the available installation packages

yum repolist enabled|grep mysql

6. Next, you need to change the mysql version

vim /etc/yum.repos.d/mysql-community.repo

For example, to install version 5.7, change the enabled=1 of the 80 source into enabled=0. Then change the enabled=0 of the 5.7 source to enabled=1.

7. Install mysql

yum install mysql-community-server -y

8. Start mysql and change related configurations

1>Start mysql: service mysqld start

2>Check whether mysql starts automatically, and set it to enable automatic startup

chkconfig --list | grep mysqld

chkconfig mysqld on

3>View initial password: grep "password" /var/log/mysqld.log

4>Log in to mysql: mysql -u root -p

5>Change password: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

If the modified password is too simple, an error may be reported:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Execute the following statement:

set global validate_password_policy=0;

set global validate_password_length=4;

Execute the modify password statement again

6>Open root account remote access

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

7>Refresh permission table

FLUSH PRIVILEGES;

8>Modify the character set to UTF-8

linux: vim /etc/my.cnf

Add in the [mysqld] section:

port=3306

character-set-server=utf8

Add the [client] section at the end of the file and add in the [client] section:

port=3306
socket=/var/lib/mysql/mysql.sock

default-character-set=utf8

Add in the [mysql] section:

no-auto-rehash

default-character-set=utf8

After modification, restart the mysqld service:

　service mysqld restart

　(Import the sql script, first use the database, then source /home/sql/test.sql)

9>Use software to test remote connection to mysql

Recommended tutorial: "centos tutorial"

The above is the detailed content of How to install mysql on centos 6.5?. For more information, please follow other related articles on the PHP Chinese website!