1 / 18

MySQL

MySQL. 建立資料庫. 資料庫切換. 資料庫權限管理. 登入 MySQL 權限管理. MySQL DBMS. 登入 MySQL 權限管理－修改 config.inc.php. 修改 phpmyadmin 中的 config.inc.php 檔 $cfg[‘Servers’][$i][‘auth_type’] = ‘ 登入模式 '; // Authentication method (config, http or cookie based)? $cfg[‘Servers’][$i][‘user’] = ‘ 帳號 '; // MySQL user

laurel-morales
Download Presentation

MySQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL

  2. 建立資料庫 資料庫切換 資料庫權限管理 登入MySQL權限管理

  3. MySQL DBMS

  4. 登入MySQL權限管理－修改config.inc.php • 修改phpmyadmin中的config.inc.php檔 • $cfg[‘Servers’][$i][‘auth_type’] = ‘登入模式'; // Authentication method (config, http or cookie based)? • $cfg[‘Servers’][$i][‘user’] = ‘帳號'; // MySQL user • $cfg[‘Servers’][$i][‘password’] = ‘密碼'; // MySQL password (only needed

  5. 登入MySQL權限管理－修改資料庫 • 權限

  6. 登入MySQL權限管理－修改資料庫 • 編輯

  7. 登入MySQL權限管理－修改資料庫 • 更改密碼

  8. 錯誤提示訊息已經消失

  9. 必須設定 $cfg['PmaAbsoluteUri'] 在設定檔內! • 修改phpmyadmin中的config.inc.php檔 • $cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

  10. 資料庫層

  11. 資料表結構 建立資料表

  12. 輸入執行SQL指令 匯入SQL指令

  13. 資料表層

  14. 資料內容

  15. 新增資料內容

  16. 管理資料表

More Related