Ubuntu Server 11.10 安裝 MySQL簡單配置及圖形化工具

1. 安裝

devadm@devserver:~$ sudo apt-get install mysql-server ...... The following NEW packages will be installed:   libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16   libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-client-core-5.1   mysql-common mysql-server mysql-server-5.1 mysql-server-core-5.1 0 upgraded, 12 newly installed, 0 to remove and 1 not upgraded. Need to get 23.8 MB of archives. After this operation, 61.2 MB of additional disk space will be used. Do you want to continue [Y/n]? ...... 【mysql root 密碼設為：www.bkjia.com】 ......

2. 伺服器配置
1)編輯設定檔

devadm@devserver:~$ sudo vim /etc/mysql/my.cnf

將 'bind-address = 127.0.0.1' 替換為: 
bind-address = 0.0.0.0

2)防火牆，別忘了防火牆！

devadm@devserver:~$ sudo ufw allow mysql Rule added Rule added (v6) devadm@devserver:~$ devadm@devserver:~$ sudo ufw status Status: active To                         Action      From --                         ------      ---- 22/tcp                     ALLOW       Anywhere 139/tcp                    ALLOW       Anywhere 445/tcp                    ALLOW       Anywhere 8080/tcp                   ALLOW       Anywhere 3306                       ALLOW       Anywhere 22/tcp                     ALLOW       Anywhere (v6) 139/tcp                    ALLOW       Anywhere (v6) 445/tcp                    ALLOW       Anywhere (v6) 8080/tcp                   ALLOW       Anywhere (v6) 3306                       ALLOW       Anywhere (v6) devadm@devserver:~$

3)本機串連，配置使用者和使用者資料庫

devadm@devserver:~$ mysql -h 127.0.0.1 -u root -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 43 Server version: 5.1.58-1Ubuntu1 (Ubuntu) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE DATABASE devcom; mysql> CREATE USER dev; mysql> GRANT ALL PRIVILEGES ON devcom.* TO 'dev'@'%' ; mysql> SET PASSWORD FOR 'dev'@'%' = PASSWORD('mylittlesecret'); mysql> mysql> quit; Bye devadm@devserver:~$

3.用戶端
1)安裝mysql-client
gt@gt-Dell:~$ sudo apt-get install mysql-client

串連，建立使用者表，插入測試資料

gt@gt-Dell:~$ mysql -h devserver -u dev -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 39 Server version: 5.1.58-1ubuntu1 (Ubuntu) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> USE devcom \Database changed mysql> CREATE TABLE devuser (dev_id int, dev_name char(20)); mysql> INSERT INTO devuser (dev_id,dev_name) VALUES(1001,'Pan Black'); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM DEVUSER; ERROR 1146 (42S02): Table 'devcom.DEVUSER' doesn't exist mysql> SELECT * FROM devuser; +--------+-----------+ | dev_id | dev_name  | +--------+-----------+ |   1001 | Pan Black | +--------+-----------+ 1 row in set (0.00 sec) mysql>

2) MySQL管理員（MySQL Administrator）圖形化工具在 Ubuntu軟體中心“有售”。

650) this.width=650;" border=0>

 

安裝後，在“應用程式 - 編程 - MySQL Administrator” ，和 “應用程式 - 編程 - MySQL Query Browser”