MySQL8.0版本安装教程一步一步详细配图解答

心已赠人 2023-06-19 13:30 115阅读 0赞

![format_png][]

![format_png 1][]

![format_png 2][]

![format_png 3][]

![format_png 4][]

等待下载完成

双击运行

![format_png 5][]

![format_png 6][]

![format_png 7][]

![format_png 8][]

![format_png 9][]

![format_png 10][]

![format_png 11][]

![format_png 12][]

![format_png 13][]

![format_png 14][]

![format_png 15][]

![format_png 16][]

![format_png 17][]

如果有需要 我们可以新增一个用户出来

点击 Add User，不需要的话 直接 点击 next

![format_png 18][]

![format_png 19][]

![format_png 20][]

![format_png 21][]

![format_png 22][]

![format_png 23][]

![format_png 24][]

默认的MySQL安装在C盘

找到 可执行的 mysql的可执行程序

![format_png 25][]

查看 MySQL服务 是否 启动

![format_png 26][]

使用 DOS 命令 进行测试 是否 可正常使用

将 mysql 的可执行命令的路径配置到 path 中

![format_png 27][]

打开 cmd 命令 窗口

输入 msyql -V 能输入出 版本 即可正常使用

![format_png 28][]

在 cmd 中使用 mysql

![format_png 29][]

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

#进入 数据库
    mysql - u 用户名 -p 密码
    
    #查看当前用户的数据库
    show databases;
    
    #创建一个数据库
    create dabase demo;
    
    #使用哪一个数据库
    use demo;
    
    #创建一个表
    create table my_table(
    id int ,
    name varchar(20)
    )default charset=utf8;
    
    #............

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

## 用户跟权限 ##

用户跟权限的相关信息，都是保存在下面表中：

*  mysql.user
 *  mysql.db/host/table/priv…

`mysql.user` 是一个非常重要非常特殊的表，它保存了所有的账号信息，以及保存了账号的权限信息。

如果要操作用户和权限，有两种方式:

1.  使用相关的授权语句
2.  直接修改 mysql.user 表

## 第一种方式 ##

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

-- 查看用户
    select current_user(), user();
    select * from mysql.user;
    
    -- 创建与授权
    create user 'xxx'@'host' identified by '密码';
    grant all on ttt.* to 'user'@'host' with grant options;
    
    -- 查看授权情况
    show grants for 'user'@'host';
    
    -- 用户的管理，删除密码等
    set password for 'user'@'host' = password('新密码');
    drop user vip;
    
    -- 授权的相对完整语法为:
    grant all/alter/create/drop/select/update/delete
          on *.* -- db.*/db.table
          to 'user'@'host'
          identified by '密码'
          with max_user_connections 2
               max_connections_pser_hour 5;

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

## 第二种方式 ##

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

-- 增加用户
    insert into mysql.user(host, user, password) values (xx, yy, zz);
    
    -- 修改密码
    update mysql.user set password=password('新密码') where user='vip' and host='%';
    
    -- 修改权限
    update mysql.user set event_priv='Y' where user='vip' and host='%';
    
    -- 注意，使用 sql 语句修改用户跟权限之后，需要手动刷新权限表
    flush privileges;

![复制代码][aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]

## 使用 **MySQL-Workbench 可视化工具** ##

![format_png 30][]、

点开 Local instance MySQL57 进行测试连接已存在的数据库

![format_png 31][]

![format_png 32][]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjEzMTIzNTc1NC0xMjU1NTA1ODY5LnBuZw?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjEzMTQyNjEyNy04MTkzMDkxMzUucG5n?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzIyMjEyNi0yMTIyODU2NTU4LnBuZw?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzMwMTAzOS04NTk1NzY5NDMucG5n?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzMyOTEyMi0yMDA2MzgzODg2LnBuZw?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzM1OTY3My0xMTkyNjE2MzEwLnBuZw?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE0MjAzMTIzMi0xMDAxMTA3MDkucG5n?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzYxNDczNC02MTkwMzY1MDQucG5n?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MTAwODc1Ny0xOTEyNDM4NTA3LnBuZw?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzgzMTI5Mi03NDY0ODc4MDEucG5n?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1MzkwMjI4MC01MTI0NzI1MDgucG5n?x-oss-process=image/format,png
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MTcwMDY1MS0xMzMxNDE0MDIxLnBuZw?x-oss-process=image/format,png
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MTc0NjE2NC0xMjI1OTkwMjUucG5n?x-oss-process=image/format,png
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MTk1NDA1MS0xNDMxNjM5MjY0LnBuZw?x-oss-process=image/format,png
[format_png 14]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MjAyNzc1OC0xMTY4MjYwODgwLnBuZw?x-oss-process=image/format,png
[format_png 15]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1NDA0NzkyOC0xNDU3ODkyNDE1LnBuZw?x-oss-process=image/format,png
[format_png 16]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1NDE0ODAwMS0xNjA5OTMwODUyLnBuZw?x-oss-process=image/format,png
[format_png 17]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1NDQ0NzcyMi0xMjM4NDk2ODM3LnBuZw?x-oss-process=image/format,png
[format_png 18]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1NDU1MzkxOS0xMjQwMDA3Nzc3LnBuZw?x-oss-process=image/format,png
[format_png 19]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1NDc0MjA2My0zOTM2OTI1OTIucG5n?x-oss-process=image/format,png
[format_png 20]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE1NDkwMzAzNS0xODE2MjEwMzQ2LnBuZw?x-oss-process=image/format,png
[format_png 21]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MjcyMzg2OS0xMDY1NTg2ODI0LnBuZw?x-oss-process=image/format,png
[format_png 22]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2Mjc0MzU4OC0xMzQxNjI3NDIzLnBuZw?x-oss-process=image/format,png
[format_png 23]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2Mjc1NjA2Ny0xODA1NDM0MjU4LnBuZw?x-oss-process=image/format,png
[format_png 24]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2Mjk0NzYzMy04MjQ2Nzk3MDEucG5n?x-oss-process=image/format,png
[format_png 25]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MzMyMDY2Mi0xMDg1MDA3NDQyLnBuZw?x-oss-process=image/format,png
[format_png 26]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MzQzNDcyNi0xOTMxMDIwOTAwLnBuZw?x-oss-process=image/format,png
[format_png 27]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2MzkxNTI0Mi0xMDQ1NjQ0MDY3LnBuZw?x-oss-process=image/format,png
[format_png 28]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE2NDAzNzE4OC0xMTQ0ODQ3MjU1LnBuZw?x-oss-process=image/format,png
[format_png 29]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE3MTAyNjY0OS0yNjkzMDcxNTAucG5n?x-oss-process=image/format,png
[aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jb21tb24uY25ibG9ncy5jb20vaW1hZ2VzL2NvcHljb2RlLmdpZg
[format_png 30]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE3MzIxNDIxOS05NTc2NTkzODgucG5n?x-oss-process=image/format,png
[format_png 31]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE3MzMyNDMxOC0xMjgzMzE5OTMxLnBuZw?x-oss-process=image/format,png
[format_png 32]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTQ0MzU3Ni8yMDE5MDQvMTQ0MzU3Ni0yMDE5MDQwMjE3NDA1MjQ2Mi0xODAzNjM3MTc3LnBuZw?x-oss-process=image/format,png