源码安装MySQL默认数据目录_源码安装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)