linux 安装 mysql简单教程

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

# tar -xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
# mv -v mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql

# groupadd mysql
# useradd -r -g mysql mysql

# chown -R mysql:mysql /usr/local/mysql

# mkdir data

# /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

# /usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize

# yum -y install numactl
# yum search libaio
# yum install libaio

[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
# 取消密码验证
skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# skip-grant-tables
<p>[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

# chkconfig mysql on

# service mysql start

# mysql -u root -p

# /usr/local/mysql/bin/mysql -uroot -p

# export PATH=$PATH:/usr/local/mysql/bin

# use mysql;</p><h1>update user set authentication_string=password('你的密码') where user='root';</h1><h1>或者</h1><h1>set password=password("root");</h1><h1>flush privileges;</h1><h1>exit

# mysql -u root -p</h1><h1>alter user 'root'@'localhost' identified by '修改后的密码';</h1><h1>exit

# mysql -u root -p</h1><h1>use mysql;</h1><h1>update user set host='%' where user = 'root';</h1><h1>flush privileges;</h1><h1>exit