Coin163

首页 > Ubuntu Server 11.10 安装 MySQL,简单配置,及图形化工具 - 博客频道 - CSDN.NET

Ubuntu Server 11.10 安装 MySQL,简单配置,及图形化工具 - 博客频道 - CSDN.NET

2021腾讯云限时秒杀,爆款1核2G云服务器298元/3年!(领取2860元代金券),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1062

2021阿里云最低价产品入口+领取代金券(老用户3折起),
入口地址https://www.aliyun.com/minisite/goods

相关推荐:Ubuntu 安装配置Mysql

Ubuntu安装配置Mysql 三种安装方式:   1. 从网上安装 sudo apt-get install mysql-server。装完已经自动配置好环境变量,可以直接使用mysql的命令。     注:建议将/etc/apt/source.list中的cn改成us,美国的服务器比中国的快很多。   2. 安装离线包

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 密码设为:mygreatsecret】
......



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软件中心“有售”。
如图:

 

安装后,在“应用程序 - 编程 - MySQL Administrator” ,和 “应用程序 - 编程 - MySQL Query Browser”

 

 

原文

1. 安装 devadm@devserver:~$ sudo apt-get install mysql-server ...... The following NEW packages will be installed:   libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlcli

------分隔线----------------------------