8.2笔记

一、安装及初始化

1.官网下载或者wget

1. [root@mysql ~]# ls

2. anaconda-ks.cfg

3. initserver.sh

4. mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

5. mysql-community-client-8.0.33-1.el7.x86_64.rpm

6. mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm

7. mysql-community-common-8.0.33-1.el7.x86_64.rpm

8. mysql-community-debuginfo-8.0.33-1.el7.x86_64.rpm

9. mysql-community-devel-8.0.33-1.el7.x86_64.rpm

10. mysql-community-embedded-compat-8.0.33-1.el7.x86_64.rpm

11. mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm

12. mysql-community-libs-8.0.33-1.el7.x86_64.rpm

13. mysql-community-libs-compat-8.0.33-1.el7.x86_64.rpm

14. mysql-community-server-8.0.33-1.el7.x86_64.rpm

15. mysql-community-server-debug-8.0.33-1.el7.x86_64.rpm

16. mysql-community-test-8.0.33-1.el7.x86_64.rpm

2. 确定 mysql-community-server 正常安装之后就可以开始配置

3. 初始化 mysqld 服务 mysqld initeialize

4. 启动服务 systemctl start mysqld

5. 添加开机启动列表 systecmctrl enable mysqld

6. 在 /var/log/mysql.log 中找到初始密码，前后复制空格 7. 登录管理 mysql -uroot -p

将复制的密码粘贴到输入密码的区

域，实现登录

8. 设置新的密码

9. 退出登录

二、数据库的管理

1. 数据库操作

删除库

1. mysql> drop database test;

2. Query OK, 0 rows affected (0.01 sec)

3. mysql> show databases;

4. +--------------------+

5. | Database |

6. +--------------------+

7. | information_schema |

8. | mysql |

9. | performance_schema |

10. | sys |

11. +--------------------+

12. 4 rows in set (0.00 sec)

创建库

1. mysql> create datababse test charset utf8;

2. Query OK, 1 row affected, 1 warning (0.01 sec)

3. mysql> show databases;

4. +--------------------+

5. | Database |

6. +--------------------+

7. | information_schema |

8. | mysql |

9. | performance_schema |

10. | sys |

11. | test |

12. +--------------------+

13. 5 rows in set (0.00 sec)

查看库

1. mysql> show databases;

2. +--------------------+

3. | Database |

4. +--------------------+

5. | information_schema |

6. | mysql |

7. | performance_schema |

8. | sys |

9. +--------------------+

<