源码安装mysql

安装linux通用版本

[root@localhost ~]# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

[root@localhost ~]# ls
anaconda-ks.cfg  mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

移动到/usr/local/

anaconda-ks.cfg  mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
[root@localhost ~]# mv ./mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz /usr/local/

解压

[root@localhost ~]# cd /usr/local/
[root@localhost local]# tar -xvf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz 

[root@localhost local]# mv mysql-8.0.20-linux-glibc2.12-x86_64 mysql
[root@localhost local]# cd mysql
[root@localhost mysql]# ls
bin  docs  include  lib  LICENSE  man  README  share  support-files

创建运行mysql的组和用户

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

默认在mysql目录下,没有data目录,需要手动创建

[root@localhost mysql]# mkdir data

修改data目录的,用户和组

[root@localhost mysql]# chown mysql:mysql data

初始化数据

[root@localhost mysql]# bin/mysqld --initialize --user=mysql --datadi/mysql/data/
2020-05-02T11:19:27.030513Z 0 [System] [MY-013169] [Server] /usr/locamysqld (mysqld 8.0.20) initializing of server in progress as process 
2020-05-02T11:19:27.043549Z 1 [System] [MY-013576] [InnoDB] InnoDB in has started.
2020-05-02T11:19:28.198086Z 1 [System] [MY-013577] [InnoDB] InnoDB in has ended.
2020-05-02T11:19:29.761294Z 6 [Note] [MY-010454] [Server] A temporary generated for root@localhost: ru>7+_HoF;ry

拷贝

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

删除my.cnf文件

现在使用mysql默认的参数启动,不需要指定参数

[root@localhost mysql]# rm -rf /etc/my.cnf

启动mysql

[root@localhost mysql]# /etc/init.d/mysql.server start
Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'.
. SUCCESS! 

查看启动进程

[root@localhost mysql]# ps -ef | grep mysql

尝试连接

[root@localhost mysql]# mysql -uroot -p
-bash: mysql: command not found

:/usr/local/mysql/bin

修改环境变量

[root@localhost mysql]# cd
[root@localhost ~]# vim .bash_profile 
在path环境变量的后面添加   :/usr/local/mysql/bin

[root@localhost ~]# source .bash_profile 

再次尝试连接

密码使用初始化时输出到屏幕的密码

[root@localhost ~]# mysql -uroot -p
Enter password: 
mysql> 

必须要重置密码才能使用,重置为mysql

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> alter user user() identified by 'mysql';
Query OK, 0 rows affected (0.01 sec)

mysql> exit;
Bye

再次测试

[root@localhost ~]# mysql -uroot -p
Enter password: 

mysql> show databases\G
*************************** 1. row ***************************
Database: information_schema
*************************** 2. row ***************************
Database: mysql
*************************** 3. row ***************************
Database: performance_schema
*************************** 4. row ***************************
Database: sys
4 rows in set (0.00 sec)