下載地址:https://dev.mysql.com/downloads/mysql/
1赢笨、下載得到zip壓縮包
然后就開(kāi)始下載,下載完成蟋字,得到了壓縮包
2、解壓到要安裝的目錄
3、添加環(huán)境變量
我的電腦–>屬性–>高級(jí)–>環(huán)境變量
選擇path添加:mysql安裝目錄下的bin文件夾地址
4、新建mysql 配置文件
在你的mysql安裝目錄下纯丸,新建my.ini文件,編輯 my.ini文件静袖,注意替換路徑位置
[mysqld]
basedir=D:\JAVA_Environment\MySQL\mysql-8.0.21\
datadir=D:\JAVA_Environment\MySQL\mysql-8.0.21\data\
port=3306
5觉鼻、安裝mysql服務(wù)
啟動(dòng)管理員模式下的cmd,并將路徑切換至mysql安裝目錄下的bin目錄勾徽,輸入以下命令
cd \d D:\JAVA_Environment\MySQL\mysql-8.0.21\bin
mysqld -install
6滑凉、初始化數(shù)據(jù)文件
輸入以下命令
mysqld --initialize-insecure --user=mysql
7、啟動(dòng)mysql
net start mysql
此時(shí)cmd的窗口命令如下
Microsoft Windows [版本 6.1.7601]
版權(quán)所有 (c) 2009 Microsoft Corporation喘帚。保留所有權(quán)利畅姊。
C:\Users\Administrator>d:
D:\>cd D:\software\mysql-8.0.22-winx64\bin
D:\software\mysql-8.0.22-winx64\bin>mysqld -install
Service successfully installed.
D:\software\mysql-8.0.22-winx64\bin>mysqld --initialize-insecure --user=mysql
D:\software\mysql-8.0.22-winx64\bin>net start mysql
MySQL 服務(wù)正在啟動(dòng) .
MySQL 服務(wù)已經(jīng)啟動(dòng)成功。
D:\software\mysql-8.0.22-winx64\bin>
8吹由、進(jìn)入mysql管理界面修改密碼(第一次輸入密碼回車(chē)即可)
mysql -u root -p
9若未、初始密碼不能登錄或者忘記密碼解決辦法
9.1 打開(kāi)命令窗口cmd,輸入命令:net stop mysql倾鲫,停止MySQL服務(wù)
9.2 開(kāi)啟跳過(guò)密碼驗(yàn)證登錄的MySQL服務(wù)
mysqld --console --skip-grant-tables --shared-memory
9.3 再新打開(kāi)一個(gè)cmd粗合,進(jìn)行無(wú)密碼登錄MySQL
mysql -u root -p
9.4 修改密碼
9.4.1 密碼置為空
use mysql
update user set authentication_string='' where user='root' and host='localhost';
9.4.2 解決 The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement 錯(cuò)誤,刷新下權(quán)限
1
flush privileges;
9.4.3 修改自己的密碼
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '111111'; // 111111就是自己
設(shè)置的密碼
9.5 開(kāi)啟服務(wù)乌昔,net start mysql
9.6 登錄驗(yàn)證即可
10隙疚、添加用戶(hù)并授權(quán)
10.1 創(chuàng)建允許外網(wǎng)IP訪問(wèn)的用戶(hù)test001,密碼為Mim@123456
create user 'test001'@'%' identified by 'Mim@123456';
10.2授予用戶(hù)通過(guò)外網(wǎng)IP對(duì)于全部數(shù)據(jù)庫(kù)的全部權(quán)限
grant all privileges on *.* to 'test001'@'%';
5.3 刷新權(quán)限
flush privileges;
11、客戶(hù)端使用navicat for mysql 連接mysql
11.1 用root登錄進(jìn)客戶(hù)端磕道,需要navicat連接的賬號(hào),更改加密方式為mysql_native_password
ALTER USER 'test001'@'%' IDENTIFIED BY 'Mim@123456' PASSWORD EXPIRE NEVER;
11.2 更改密碼
ALTER USER 'test001'@'%' IDENTIFIED WITH mysql_native_password BY 'Mim@123456';
6.3 結(jié)果
Microsoft Windows [版本 6.1.7601]
版權(quán)所有 (c) 2009 Microsoft Corporation供屉。保留所有權(quán)利。
D:\software\mysql-8.0.22-winx64\bin>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.22 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
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> update user set authentication_string='' where user='root' and host='loca
lhost';
ERROR 1046 (3D000): No database selected
mysql> use mysql
Database changed
mysql> update user set authentication_string='' where user='root' and host='loca
lhost';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql>
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'hytc2020';
Query OK, 0 rows affected (0.00 sec)
mysql> net start mysql
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'net start mysql' at line 1
mysql> show database;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'database' at line 1
mysql> show tables;
+----------------------------------------------+
| Tables_in_mysql |
+----------------------------------------------+
| columns_priv |
| component |
| db |
| default_roles |
| engine_cost |
| func |
| general_log |
| global_grants |
| gtid_executed |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| password_history |
| plugin |
| procs_priv |
| proxies_priv |
| replication_asynchronous_connection_failover |
| role_edges |
| server_cost |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+----------------------------------------------+
34 rows in set (0.01 sec)
mysql>