Window下mysql環境配置問題整理

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#window%E4%B8%8Bmysql%E7%8E%AF%E5%A2%83%E9%85%8D%E7%BD%AE%E9%97%AE%E9%A2%98%E6%95%B4%E7%90%86 Window下mysql環境配置問題整理

參考如下連結。

無需安裝解壓版mysql包 建立選項配置 首次啟動服務 用mysqld初始化目錄 安裝後設定和測試

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E5%90%AF%E5%8A%A8%E6%9C%8D%E5%8A%A1%E9%94%99%E8%AF%AF%E4%BF%A1%E6%81%AF 啟動服務錯誤資訊

管理者模式打開cmd

mysqld install

net start mysql

MYSql服務正在啟動

MYSql服務無法啟動

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E8%A7%A3%E5%86%B3%E5%8A%9E%E6%B3%95 解決辦法

删除mysql安裝主目錄下的data目錄下所有檔案

mysqld --initialize --console

C:\WINDOWS\system32> mysqld --initizlize --console
mysqld: Can't change dir to 'D:\Program Files\mysql-8.0.12-winx64\data\' (OS errno 2 - No such file or directory)
2018-08-17T01:54:27.145772Z 0 [System] [MY-010116] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) starting as process 17876
2018-08-17T01:54:27.148482Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\Program Files\mysql-8.0.12-winx64\data\DESKTOP-SET72RE.lower-test
2018-08-17T01:54:27.148571Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\Program Files\mysql-8.0.12-winx64\data\DESKTOP-SET72RE.lower-test
2018-08-17T01:54:27.149798Z 0 [ERROR] [MY-010172] [Server] failed to set datadir to D:\Program Files\mysql-8.0.12-winx64\data\
2018-08-17T01:54:27.169994Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-08-17T01:54:27.172048Z 0 [System] [MY-010910] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12)  MySQL Community Server - GPL.
           

如上述報錯的話，加上user，并記錄初始密碼

mysqld --initialize --user=root --console

C:\WINDOWS\system32>mysqld --initialize --user=root --console
2018-08-17T03:06:51.636920Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) initializing of server in progress as process 7832
2018-08-17T03:06:54.218851Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: yacuOdqg/6Mn
2018-08-17T03:06:55.288246Z 0 [System] [MY-013170] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) initializing of server has completed
           

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E5%AE%89%E8%A3%85%E6%9C%8D%E5%8A%A1 安裝服務

C:\WINDOWS\system32>mysqld install
Service successfully installed.
           

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E5%90%AF%E5%8A%A8%E6%9C%8D%E5%8A%A1 啟動服務

C:\WINDOWS\system32>net start mysql
MySQL 服務正在啟動 .
MySQL 服務已經啟動成功。
           

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E7%99%BB%E9%99%86%E7%B3%BB%E7%BB%9F 登陸系統

如登陸不上，需要運作net stop mysql,

然後重新運作下mysqld --initialize --user=root --console

mysql -u root -p

C:\WINDOWS\system32>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.12
Copyright (c) 2000, 2018, 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>
           

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E4%BF%AE%E6%94%B9%E5%AF%86%E7%A0%81 修改密碼

ALTER USER 'root'@'localhost' IDENTIFIED BY 'fjdoe13232';

mysql執行語句一定要以;結尾。切記。

mysql>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'fjdoe13232
';
Query OK, 0 rows affected (0.11 sec)
           

https://i.cnblogs.com/EditPosts.aspx?postid=9492807&update=1#%E5%B8%B8%E7%94%A8%E5%91%BD%E4%BB%A4 常用指令

show databases;

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

create database 資料庫;

mysql> create database ustest;
Query OK, 1 row affected (0.03 sec)
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| ustest             |
+--------------------+
5 rows in set (0.00 sec)
mysql> use ustest;
Database changed
           

以上是簡單環境配置。

作者：

從此啟程/範存威

出處：

http://www.cnblogs.com/fancunwei/

本文版權歸作者和部落格園共有，歡迎轉載，但未經作者同意必須保留此段聲明，且在文章頁面明顯位置給出原文連結。如文章對您有用，煩請點個推薦再走，感謝！ 本部落格新開通打賞，滑鼠移到右側打賞浮動處，即可賞部落客點零花錢，感謝您的支援！