Linux安装mysql

1.下载

   地址：https://downloads.mysql.com/archives/community/

 

2.解压 

 上传到服务器 /usr/local/server目录

  

解压 

Tar –zxvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz

 

解压后重命名

mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/server/mysql

3.安装组件

yum search libaio
yum install libaio
yum -y install numactl
yum install libnuma
yum install ld-linux.so.2
yum install libaio.so.1
yum install libnuma.so.1
yum install libstdc++.so.6
yum install libtinfo.so.5

4.创建用户和用户组

 

groupadd mysql
useradd -r -g mysql mysql

 

 5.设置mysql用户目录

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

 添加权限

chown -R mysql:mysql ./

 6.创建相关文件

mkdir /var/log/mariadb/
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/

7.启动服务

[root@localhost mysql]# cd support-files
[root@localhost support-files]# ./mysql.server start
Starting MySQL.Logging to '/usr/local/server/mysql/data/localhost.localdomain.err'.
.. SUCCESS! 

8.配置mysql环境

[root@localhost ~]# vi /etc/profile

export MYSQL_HOME=/usr/local/server/mysql
export MYSQL_PATH=${MYSQL_HOME}/bin:${MYSQL_HOME}/lib
export PATH=$PATH:/usr/local/server/mysql/bin

 

9.配置my.cnf

vim /etc/my.cnf

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/server/mysql
datadir=/usr/local/server/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/server/mysql/mysql.err
pid-file=/usr/local/server/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

 10.初始化

cd /usr/local/server/mysql/bin/
./mysqld --defaults-file=/etc/my.cnf --user=mysql –initialize

查看密码
cat /data/mysql/mysql.err

11.系统配置

cp /usr/local/mysql/support-files/mysql.server   /etc/init.d/mysql   //拷贝mysql.server 
 
chmod +x  /etc/init.d/mysql           //添加可执行权限。
 
chkconfig  --add mysql               // 注册启动服务
chkconfig  --list   //查看是否添加成功

12.修改初始密码

[root@localhost ~]# mysql -uroot -p
Enter password:        //这里输入刚刚初始化操作时的初始密码

mysql> alter user 'root'@'localhost' identified by '你的新密码';
Query OK, 0 rows affected (0.02 sec)
#设置允许远程登录
mysql> update user set user.Host='%' where user.User='root';

 

 

13.授予权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

 

 14.成功连接