Linux下安装mysql-8

//设置数据库存储文件夹的用户权限
[root@root mysql]# chown -R root:root ./
[root@root mysql]# chown -R mysql:mysql data

//修改etc/my.cnf配置文件
[root@root ~]# vim /etc/my.cnf

//修改为以下内容：
[mysqld]
server-id                      = 1
port                           = 3306

bind-address                    =0.0.0.0 
mysqlx_port                    = 33060
mysqlx_socket                  = /tmp/mysqlx.sock
basedir                   = /usr/local/mysql
datadir                        = /usr/local/mysql/data
socket                         = /tmp/mysql.sock
pid-file                       = /tmp/mysqld.pid
log-error                      = error.log
slow-query-log                 = 1
slow-query-log-file            = slow.log
long_query_time                = 0.2
log-bin                        = bin.log
relay-log                      = relay.log
binlog_format                 =ROW
relay_log_recovery            = 1
character-set-client-handshake = FALSE
character-set-server           = utf8mb4
collation-server               = utf8mb4_unicode_ci
init_connect                   =‘SET NAMES utf8mb4’
innodb_buffer_pool_size        = 1G
join_buffer_size               = 128M
sort_buffer_size               = 2M
read_rnd_buffer_size           = 2M
log_timestamps                 = SYSTEM
lower_case_table_names         = 1
default-authentication-plugin  =mysql_native_password

保存退出。

[root@root mysql]# chmod 777 /etc/my.cnf 
//设置开机自启动
[root@root mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@root mysql]# chmod +x /etc/init.d/mysql 
//注册查看服务
[root@root mysql]# chkconfig --add mysql
[root@root mysql]# chkconfig --list mysql
mysql              0:关闭    1:关闭    2:启用    3:启用    4:启用    5:启用    6:关闭

//    /etc/ld.so.conf 这个文件记录了编译时使用的动态链接库的路径，告诉链接器去哪个路径下寻找链接时需要用到的库，如果找不到，就会提示链接错误。

如果我们安装了第三方的库，而没有将它放在链接器可以找到的目录，则运行使用这些第三方库的程序时，会提示找不到库。

[root@root mysql]# vim /etc/ld.so.cnf

添加如下内容：

include ld.so.conf.d/*.conf

/usr/local/mysql/lib

//配置环境变量
[root@root mysql]# vim /etc/profile

添加如下内容：

export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib

//让配置文件立马生效
[root@root mysql]# source /etc/profile

//启动MySQL服务
[root@root mysql]# service mysql start

//使用生成的密码登陆MySQL数据库
[root@root mysql]# mysql -u root -p
mysql: [Warning] World-writable config file ‘/etc/my.cnf’ is ignored.
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.13

Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

//修改密码
mysql> alter user ‘root’@‘localhost’ identified by ‘123456’;
Query OK, 0 rows affected (0.13 sec)

mysql> exit
Bye

//退出重登录mysql
[root@root mysql]# mysql -u root -p
mysql: [Warning] World-writable config file ‘/etc/my.cnf’ is ignored.
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.13 MySQL Community Server - GPL

Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> show databases;
±-------------------+
| Database           |
±-------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
±-------------------+
4 rows in set (0.01 sec)

到此安装完成！

这里设置的 /etc/my.cnf 权限是777 ，就是任何人都可读可写，my.cnf 会被忽略掉，mysql的安全机制，也可以不要my.cnf配置文件。

下面设置一下MySQL的远程访问

简单写一下命令，自己写的时候忘了记录，网上也是一大堆。

登陆mysql
mysql -u root -p