在Linux下源码安装MySQL数据库

安装MySQL数据库

1.源码安装

1.去官网下载MySQL5.7.33通用离线安装包,或使用wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

2.添加用户组及用户信息；

[root@localhost ~]# groupadd mysql  
​
[root@localhost ~]# useradd -g mysql mysql

3.下载的文件进行解压处理：

[root@localhost ~]# tar -xzvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

4.将解压出来的文件mysql文件目录移动到/usr/local目录下，并重命名为mysql,切换到/usr/local/mysql目录，并 在mysql目录下创建data目录

[root@localhost ~]# mv mysql-5.7.33-linux-glibc2.12-x86_64 /usr/local/mysql 
​
[root@localhost ~]#cd /usr/local/mysql  [root@localhost mysql]# mkdir data

5.更换mysql目录文件的属主、属组及文件权限；

[root@localhost mysql]# chown -R mysql:mysql /usr/local/mysql/  
​
[root@localhost mysql]# chmod -R 755 /usr/local/mysql/

6.执行数据库初始化操作

a.切换到bin目录下：[root@localhost ~]# cd /usr/local/mysql
​
b.执行初始化语句：./bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize   

7.查看初始密码：

8.开启mysql服务

[root@localhost mysql]# ./support-files/mysql.server start

9.将mysql进程放入系统进程中。

[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysqld

10.添加配置文件信息 vim /etc/my.cnf

[mysqld]
port=3306
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=rootmax_connections=151
symbolic-links=0
lower_case_table_names=1
character-set-server=utf8
collation-server=utf8_general_ci
​
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
​
[client]
socket=/usr/local/mysql/mysql.sock
default-character-set=utf8

11.重新启动mysql服务

[root@localhost ~]# service mysqld restart

12.设置mysql环境变量

[root@localhost ~]# export PATH=$PATH:/usr/local/mysql/bin  
​
[root@localhost ~]# source /etc/profile

13.修改密码

[root@localhost ~]# mysql –u root –p
​
输入例登录密码：    
​
mysql>alter user ‘root’@’localhost’ identified by ‘要设置的新密码’;    
​
mysql>flush privileges;          (刷新服务)

14.为mysql数据库添加远程登录

mysql>grant all privileges on *.* to ‘root（用户名）’@’%’ identified by ‘root(用户密码)’ with grant option;
​
mysql>exit;            （退出mysql登录）