進來到這邊以後輸入帳密登入
先關服務 開始下指令
service mysql stop
cd /usr/bin
mysqld_safe --skip-grant-tables &
意思切去 /usr/bin根目錄 啟動mysql不啟動權限表
意思就是略過root
mysql -u root
mysqladmin -u root password 'csiecsie'
上面那行就是你要讓你的root密碼變成什麼這裡是把root的帳號密碼變成csicsie
左邊可以看到可以選擇哪個資料庫如果這選項是空白那就是所有資料庫，現在來用看看怎麼導出一個資料庫
選擇一個資料庫叫做mysql
現在點選匯出 這邊會把資料庫的所有表倒出
這邊我們選擇為存檔 並存成.sql檔
成功的話會看到這畫面
點選匯入選檔案
然後執行
這邊會出錯因為已經有個資料庫叫做mysql了
or
or
By clicking below, you agree to our terms of service.
Sign in with Wallet
New to HackMD? Sign up
| Syntax | Example | Reference | |
|---|---|---|---|
| # Header | Header | 基本排版 | |
| - Unordered List |
|
||
| 1. Ordered List |
|
||
| - [ ] Todo List |
|
||
| > Blockquote | Blockquote |
||
| **Bold font** | Bold font | ||
| *Italics font* | Italics font | ||
| ~~Strikethrough~~ | |||
| 19^th^ | 19th | ||
| H~2~O | H2O | ||
| ++Inserted text++ | Inserted text | ||
| ==Marked text== | Marked text | ||
| [link text](https:// "title") | Link | ||
|  | Image | ||
| `Code` | Code |
在筆記中貼入程式碼 | |
| ```javascript var i = 0; ``` |
|
||
| :smile: |  |
Emoji list | |
| {%youtube youtube_id %} | Externals | ||
| $L^aT_eX$ | LaTeX | ||
| :::info This is a alert area. ::: |
This is a alert area. |
On a scale of 0-10, how likely is it that you would recommend HackMD to your friends, family or business associates?
Please give us some advice and help us improve HackMD.
Syncing
-
Any changes
Be notified of any changes
-
Mention me
Be notified of mention me
-
Unsubscribe
Subscribe