1.创建安全账户mysql
[root@dsrw ~]# cd /lnmp
[root@dsrw lnmp]# useradd mysql -M -s /sbin/nologin
2.解压mysql压缩包
[root@dsrw lnmp]# tar xvf mysql-8.0.18.tar.xz
[root@dsrw lnmp]# mv mysql-8.0.18-linux-glibc2.12-x86_64 /usr/local
3.创建存放实际数据库文件的data目录
[root@dsrw lnmp]# cd /usr/local/mysql
[root@dsrw mysql]# mkdir data
4.初始化MySQL服务程序,对目录进行授权,分配一个初始化的临时密码
[root@dsrw mysql]# chown -R mysql:mysql /usr/local/mysql
[root@dsrw mysql]# cd bin
[root@dsrw bin]# ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
2022-12-26T04:14:07.117997Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.18) initializing of server in progress as process 66898
2022-12-26T04:14:11.660667Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: lHd3lbldv,cW
4.配置/usr/local/mysql/bin路径加入到PATH变量中
[root@dsrw bin]# vim ~/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/nginx/sbin:/usr/local/mysql/bin
[root@dsrw ~]# source ~/.bash_profile
5.把启动脚本mysql.server复制到/etc/init.d目录中
让服务器每次重启后都能自动启动数据库,并设置可执行权限。libtinfo.so.5文件是MySQL数据库在8.0版本后新添加的重要的函数库文件,但默认不存在,需要将libtinfo.so.6.1文件复制或者作为链接文件才能正常启动
[root@dsrw bin]# cd /usr/local/mysql
[root@dsrw mysql]# cp -a support-files/mysql.server /etc/init.d/
[root@dsrw mysql]# chmod a+x /etc/init.d/mysql.server
[root@dsrw mysql]# ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
6.运行MySQL数据库服务启动程序,开始进行初始化工作,设置不少于20位密码。
[root@dsrw mysql]# /etc/init.d/mysql.server start
Starting MySQL.Logging to '/usr/local/mysql/data/dsrw.com.err'.
.. SUCCESS!
[root@dsrw mysql]# mysql -u root -p#输入临时密码
mysql> ALTER user 'root'@'localhost' identified by 'Dsrw.comDsrw.cnDsrw.com.cn';
Query OK, 0 rows affected (0.01 sec)
7.根据MySQL数据库8.0版本的新安全要求,看过修改user表密码值
mysql>USE mysql;
mysql> SHOW tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| component |
| default_roles |
| engine_cost |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
33 rows in set (0.00 sec)
mysql> ALTER user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Dsrw.comDsrw.cnDsrw.com.cn';
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE DATABASE dsrw;
mysql> exit
Bye
© 版权声明
文章版权归作者所有,未经允许请勿转载。
THE END
请登录后查看评论内容