Debian MySQL-Server安裝設定

• 安裝MySQL-Server
  
  debian:~# apt-get install mysql-server
  
  
• 啟動MySQL-Server
  
  debian:~# /etc/init.d/mysql start
  
  
• Client端連線到MySQL-Server
  
  本機
  
  debian:~# mysql -u root -p
  
  遠端
  
  debian:~# mysql -h 140.134.210.131 -u root- p
  
  
• 資料庫操作
  
  
  1. 在本機以client程式連線
     
     debian:~# mysql -u root -p
     
     
  2. 進入後以指令查詢
     mysql>show databases;
     mysql>create database fcu;
     mysql>show databases;
     
     
  3. 建立管理者(roor)遠端連線帳號
     mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED By "something" WITH GRANT OPTION;
     
     IDENTIFIED By "something" something為密碼
     
     
  4. 增加w01使用者可以使用資料庫wdb權限
     
     mysql>grant all privileges on wdb.* to w01@localhost IDENTIFIED By "1234"
     
     
  5. 刷新資料庫
     
     mysql> FLUSH PRIVILEGES;
     
     
• 設定my.cnf
  
  debian:~# vi /etc/mysql/my.cnf
  
  fix
  
  #bind-address = 127.0.0.1
  
  
• 設定mysql密碼
  
  msyql- u root -P
  mysql>set password for root@"%"=password('rootpwd');
  
  
• mysql語法教學網站
  
  http://www.hmes.kh.edu.tw/~jona/redhat/mysqlphp/mysqlsyntax.htm