mysql安装到centos

最新推荐文章于 2024-08-04 22:36:11 发布

newbieLCQ

最新推荐文章于 2024-08-04 22:36:11 发布

阅读量187

点赞数

分类专栏：环境搭建文章标签： mysql centos linux

本文链接：https://blog.csdn.net/newbieLCQ/article/details/113529549

版权

环境搭建专栏收录该内容

7 篇文章 0 订阅

订阅专栏

mysql安装到centos

1、准备mysql软件包

[root@localhost ~]# ls
mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

2、解压修改&文件目录名

[root@localhost ~]# tar -zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
[root@localhost ~]# mv /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64/ /usr/local/mysql-5.7.18

3、初始化mysql

[root@localhost ~]# cd /usr/local/mysql-5.7.18/
[root@localhost mysql-5.7.18]# mkdir data
[root@localhost mysql-5.7.18]# cd bin/
[root@localhost bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql-5.7.18/data/ --basedir=/usr/local/mysql-5.7.18

记录下初始密码

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-OZfbGtI6-1612184539104)(D:\study\文章\images\image-20210201204856137.png)]

4、加密传输

[root@localhost bin]# ./mysql_ssl_rsa_setup --datadir=/usr/local/mysql-5.7.18/data

5、启动mysql

[root@localhost bin]# ./mysqld_safe &
[root@localhost bin]# ps -ef | grep mysql
root       5183   4641  0 20:17 pts/1    00:00:00 /bin/sh ./mysqld_safe
mysql      5239   5183  3 20:17 pts/1    00:00:00 /usr/local/mysql-5.7.18/bin/mysqld --basedir=/usr/local/mysql-5.7.18 --datadir=/usr/local/mysql-5.7.18/data --plugin-dir=/usr/local/mysql-5.7.18/lib/plugin --user=mysql --log-error=/usr/local/mysql-5.7.18/data/localhost.localdomain.err --pid-file=/usr/local/mysql-5.7.18/data/localhost.localdomain.pid
root       5281   4641  0 20:17 pts/1    00:00:00 grep --color=auto mysql

6、登录mysql(密码就是第3步保存的密码）

[root@localhost bin]# ./mysql -uroot -p
Enter password:

7、修改初始密码

mysql> show databases;   #不修改初始密码会产生错误
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user 'root'@'localhost' identified by 'xxxxxx';
Query OK, 0 rows affected (0.00 sec)

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

8、如果需要开启远程访问

mysql> grant all privileges on *.* to root@'%' identified by '120317';

远程访问需要关闭防火墙

[root@localhost bin]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2021-02-01 19:16:04 CST; 1h 10min ago
     Docs: man:firewalld(1)
 Main PID: 888 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─888 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid

Feb 01 19:16:01 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
Feb 01 19:16:04 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
[root@localhost bin]# systemctl stop firewalld
[root@localhost bin]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: inactive (dead) since Mon 2021-02-01 20:27:13 CST; 4s ago
     Docs: man:firewalld(1)
 Main PID: 888 (code=exited, status=0/SUCCESS)

Feb 01 19:16:01 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
Feb 01 19:16:04 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
Feb 01 20:27:13 localhost.localdomain systemd[1]: Stopping firewalld - dynamic firewall daemon...
Feb 01 20:27:13 localhost.localdomain systemd[1]: Stopped firewalld - dynamic firewall daemon.

01 20:27:13 localhost.localdomain systemd[1]: Stopped firewalld - dynamic firewall daemon.