Linux安装mysql

1、上传安装包

 2、解压安装包

tar -zxvf mysql-5.7.36-linux-glibc2.12-i686.tar.gz

3、重命名

mv mysql-5.7.36-linux-glibc2.12-i686 mysql

4、创建mysql用户组和用户并修改权限

groupadd mysql
useradd -r -g mysql mysql

5、配置 my.cnf

vim /etc/my.cnf
内容如下
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/software/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

6、初始化数据库

安装所有32位程序需要组件：
yum install xulrunner.i686

进入bin目录
cd /usr/local/software/mysql/bin/

yum install -y libaio.so.1
yum install -y libnuma.so.1

mkdir /data/mysql
sudo chown -R mysql:mysql /data/mysql

初始化
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/software/mysql/ --datadir=/data/mysql/ --user=mysql --initialize

7、查看密码

cat /data/mysql/mysql.err

 8、启动mysql,并更改root密码

先将mysql.server放置到/etc/init.d/mysql中

mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log

# 用户组及用户授权

chown -R mysql:mysql /var/log/mariadb/

启动mysql

service mysql start

首先登录mysql，密码是前面的那个是随机生成的。

./mysql -u root -p

设置密码和访问权限

SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;   

 

 设置全局登录

ln -s  /usr/local/mysql/bin/mysql    /usr/bin

报错：

Redirecting to /bin/systemctl start mysql.service
Failed to start mysql.service: Unit not found.

[root@localhost bin]# find / -name mysql.server
/usr/local/software/mysql/support-files/mysql.server
[root@localhost bin]# cp /usr/local/software/mysql/support-files/mysql.server /etc/init.d/mysql
[root@localhost bin]# service mysql start
Starting MySQL.. SUCCESS!