操作系统:Microsoft Windows 10 21H1
MySQL版本:MySQL Community Server 8.0.26
Java环境:
Java™ SE Runtime Environment (build 15.0.1+9-18)
Java HotSpot™ 64-Bit Server VM (build 15.0.1+9-18, mixed mode, sharing)
安装过程:
Java环境搭建:
看一看龙龙之前写过的吧,不过多赘述了呦~~(主要是比较懒,嘿嘿):
https://blog.csdn.net/weixin_46056304/article/details/108987409?spm=1001.2014.3001.5502
网址:
https://dev.mysql.com/downloads/mysql/
一、安装:
C:\Windows\system32>d: #切换到D盘
D:>cd MySQL\SQL\bin #切换到MySQL文件夹
D:\MySQL\SQL\bin>mysqld --initialize --console #初始化MySQL
2021-07-26T11:51:37.672431Z 0 [System] [MY-013169] [Server] D:\MySQL\SQL\bin\mysqld.exe (mysqld 8.0.26) initializing of server in progress as process 6024
2021-07-26T11:51:37.679627Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-07-26T11:51:37.695772Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-26T11:51:38.187110Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-26T11:51:39.493894Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-07-26T11:51:39.494483Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-07-26T11:51:39.594086Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: havj1rP#5Xct #初始密码
D:\MySQL\SQL\bin>mysqld install #安装MySQL
The service already exists!
The current server installed: D:\MySQL\SQL\bin\mysqld MySQL
D:\MySQL\SQL\bin>net start mysql #启动服务
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
D:\MySQL\SQL\bin>mysql -u root -p #登录
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.26
Copyright © 2000, 2021, Oracle and/or its affiliates.
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>
二.修改密码:
C:\Users\ASUS\Desktop>mysql -u root -p #使用初始密码登录
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 8.0.26 MySQL Community Server - GPL
Copyright © 2000, 2021, Oracle and/or its affiliates.
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> use mysql;
Database changed
mysql> update user set authentication_string=‘’ where user=‘root’; #清空authentication_string
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> alter user ‘root’@‘localhost’ identified by ‘newpassword’; #设置新的密码,newpassword就是新的密码
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges; #刷新MySQL的系统权限相关表,此过程是必要过程, 否则会出现拒绝访问
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye
三.修改密码(忘记密码的操作):
1.先以管理员身份打开一个DOS窗口:
C:\Users\ASUS\Desktop> stop mysql #停止MySQL服务
最后
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长,自己不成体系的自学效果低效漫长且无助。
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,不论你是刚入门Java开发的新手,还是希望在技术上不断提升的资深开发者,这些资料都将为你打开新的学习之门!
如果你觉得这些内容对你有帮助,需要这份全套学习资料的朋友可以戳我获取!!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
识点,不论你是刚入门Java开发的新手,还是希望在技术上不断提升的资深开发者,这些资料都将为你打开新的学习之门!**
如果你觉得这些内容对你有帮助,需要这份全套学习资料的朋友可以戳我获取!!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!