Ubuntu 16.04 安装 MySQL

最新推荐文章于 2024-02-09 10:08:10 发布
最新推荐文章于 2024-02-09 10:08:10 发布
阅读量642 收藏
点赞数
分类专栏： ubuntu
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Android_XiuChou/article/details/77943533
版权 
jhczz@vaio:~/work/MySQL$ sudo apt-get install mysql-server
[sudo] password for jhczz: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  chromium-codecs-ffmpeg-extra linux-headers-4.8.0-36
  linux-headers-4.8.0-36-generic linux-image-4.8.0-36-generic
  linux-image-extra-4.8.0-36-generic snap-confine
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7
  mysql-common mysql-server-5.7 mysql-server-core-5.7
Suggested packages:
  libipc-sharedcache-perl mailx tinyca
The following NEW packages will be installed:
  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7
  mysql-common mysql-server mysql-server-5.7 mysql-server-core-5.7
0 upgraded, 8 newly installed, 0 to remove and 16 not upgraded.
Need to get 17.8 MB of archives.
After this operation, 161 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://hk.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-common all 5.7.19-0ubuntu0.16.04.1 [15.7 kB]
Get:2 http://hk.archive.ubuntu.com/ubuntu xenial/main amd64 libaio1 amd64 0.3.110-2 [6,356 B]
Get:3 http://hk.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.19-0ubuntu0.16.04.1 [6,020 kB]
Get:4 http://hk.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.19-0ubuntu0.16.04.1 [1,654 kB]
Get:5 http://hk.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.19-0ubuntu0.16.04.1 [7,588 kB]
Get:6 http://hk.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server-5.7 amd64 5.7.19-0ubuntu0.16.04.1 [2,463 kB]
Get:7 http://hk.archive.ubuntu.com/ubuntu xenial/main amd64 libhtml-template-perl all 2.95-2 [60.4 kB]          
Get:8 http://hk.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server all 5.7.19-0ubuntu0.16.04.1 [10.8 kB]
Fetched 17.8 MB in 14s (1,224 kB/s)                                                                             
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 247417 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.7.19-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-common (5.7.19-0ubuntu0.16.04.1) ...
Selecting previously unselected package libaio1:amd64.
Preparing to unpack .../libaio1_0.3.110-2_amd64.deb ...
Unpacking libaio1:amd64 (0.3.110-2) ...
Selecting previously unselected package mysql-client-core-5.7.
Preparing to unpack .../mysql-client-core-5.7_5.7.19-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-client-core-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.19-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-server-core-5.7.
Preparing to unpack .../mysql-server-core-5.7_5.7.19-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Processing triggers for libc-bin (2.23-0ubuntu9) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-common (5.7.19-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-5.7.
(Reading database ... 247580 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.19-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../libhtml-template-perl_2.95-2_all.deb ...
Unpacking libhtml-template-perl (2.95-2) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.19-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.19-0ubuntu0.16.04.1) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for ureadahead (0.100.0-19) ...
ureadahead will be reprofiled on next reboot
Processing triggers for systemd (229-4ubuntu19) ...
Setting up libaio1:amd64 (0.3.110-2) ...
Setting up mysql-client-core-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Setting up mysql-client-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Setting up mysql-server-core-5.7 (5.7.19-0ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.19-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Setting up libhtml-template-perl (2.95-2) ...
Setting up mysql-server (5.7.19-0ubuntu0.16.04.1) ...
Processing triggers for libc-bin (2.23-0ubuntu9) ...
Processing triggers for systemd (229-4ubuntu19) ...
Processing triggers for ureadahead (0.100.0-19) ...
jhczz@vaio:~/work/MySQL$ ll
total 8
drwxrwxr-x 2 jhczz jhczz 4096 Sep 12 11:35 ./
drwxrwxr-x 9 jhczz jhczz 4096 Sep 12 11:35 ../
jhczz@vaio:~/work/MySQL$ ps -aux|grep mysql
mysql    12775  0.4  3.4 1246820 139868 ?      Ssl  11:41   0:00 /usr/sbin/mysqld
jhczz    12873  0.0  0.0  14224  1076 pts/20   S+   11:42   0:00 grep --color=auto mysql
jhczz@vaio:~/work/MySQL$ netstat -nlt|grep 3306
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN     
jhczz@vaio:~/work/MySQL$ sudo /etc/init.d/mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2017-09-12 11:41:39 HKT; 1min 34s ago
 Main PID: 12775 (mysqld)
   CGroup: /system.slice/mysql.service
           └─12775 /usr/sbin/mysqld

Sep 12 11:41:37 vaio systemd[1]: Starting MySQL Community Server...
Sep 12 11:41:39 vaio systemd[1]: Started MySQL Community Server.
jhczz@vaio:~/work/MySQL$ service mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2017-09-12 11:41:39 HKT; 1min 48s ago
 Main PID: 12775 (mysqld)
   CGroup: /system.slice/mysql.service
           └─12775 /usr/sbin/mysqld

Sep 12 11:41:37 vaio systemd[1]: Starting MySQL Community Server...
Sep 12 11:41:39 vaio systemd[1]: Started MySQL Community Server.
jhczz@vaio:~/work/MySQL$ mysql
ERROR 1045 (28000): Access denied for user 'jhczz'@'localhost' (using password: NO)
jhczz@vaio:~/work/MySQL$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.19-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.07 sec)

mysql> use information_schema
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| OPTIMIZER_TRACE                       |
| PARAMETERS                            |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLESPACES                           |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
| INNODB_LOCKS                          |
| INNODB_TRX                            |
| INNODB_SYS_DATAFILES                  |
| INNODB_FT_CONFIG                      |
| INNODB_SYS_VIRTUAL                    |
| INNODB_CMP                            |
| INNODB_FT_BEING_DELETED               |
| INNODB_CMP_RESET                      |
| INNODB_CMP_PER_INDEX                  |
| INNODB_CMPMEM_RESET                   |
| INNODB_FT_DELETED                     |
| INNODB_BUFFER_PAGE_LRU                |
| INNODB_LOCK_WAITS                     |
| INNODB_TEMP_TABLE_INFO                |
| INNODB_SYS_INDEXES                    |
| INNODB_SYS_TABLES                     |
| INNODB_SYS_FIELDS                     |
| INNODB_CMP_PER_INDEX_RESET            |
| INNODB_BUFFER_PAGE                    |
| INNODB_FT_DEFAULT_STOPWORD            |
| INNODB_FT_INDEX_TABLE                 |
| INNODB_FT_INDEX_CACHE                 |
| INNODB_SYS_TABLESPACES                |
| INNODB_METRICS                        |
| INNODB_SYS_FOREIGN_COLS               |
| INNODB_CMPMEM                         |
| INNODB_BUFFER_POOL_STATS              |
| INNODB_SYS_COLUMNS                    |
| INNODB_SYS_FOREIGN                    |
| INNODB_SYS_TABLESTATS                 |
+---------------------------------------+
61 rows in set (0.00 sec)

mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.02 sec)

mysql>

雙重底
关注
专栏目录
ubuntu18.04无法安装mysql_Ubuntu18.04中安装mysql,及安装过程中遇到的问题解决
weixin_39747975的博客
01-28 613
1、执行更新命令：sudo apt upgrade2、执行mysql安装命令，出现[Y/n]时输入Y：sudo apt install mysql-server3、执行查看mysql服务状态命令,如下图所示是运行状态：sudo service mysql status4、此时安装的mysql是没有设置密码的，执行sudo mysql，进入mysql命令行，如下5、设置密码为 localsense,...
Ubuntu - 安装、卸载 MySQL 5.7
你的笑忘书
01-05 2508
Ubuntu 安装 MySQL 5.7 安装步骤 $ sudo apt-get update $ sudo apt-get install mysql-server 查看服务是否开启、登录 MySQL $ sudo service mysql status $ mysqladmin -u root -p version $ mysql -u root -p 具体图示步骤： 1. $ ...
firefly如何安装mysql_安装指南 – Flint OS for Firefly-RK3288
weixin_42120563的博客
02-06 930
Flint OS for Firefly-RK3288 安装指南注意！Flint OS需要被烧写到Firefly-RK3288的机载高速闪存(eMMC)里才能保证正常稳定运行，这一操作将抹去现eMMC里所有的数据且不可逆。如需继续，请事先做好数据备份工作。如需恢复原始系统，请使用官方提供的恢复工具。我们无法对潜在的数据丢失以及安装中可能出现的各种问题负责或者提供及时的技术支持。请三思而后行！Lin...
linux 系统不支持mysql_提示不支持mysql的解决方法
weixin_35880510的博客
01-19 672
提示不支持mysql的解决方法发布时间:2007-11-14 00:01:33来源:红联作者:vdnuiv照我这里做了(X:\Server_Core) 这里是你安装的目录第一步:(1) 测试MySQL工作是否正常。打开cmd命令提示符窗口，输入命令：mysql -u root -p输入密码后，如果能够正常进入MySQL控制台则说明MySQL安装正常。(2) 更改MySQL数据库目录a) 打开cmd...
linux系统不支持mysql,提示不支持mysql的解决方法
weixin_42125867的博客
05-04 830
提示不支持mysql的解决方法发布时间:2007-11-14 00:01:33来源:红联作者:vdnuiv照我这里做了(X:\Server_Core) 这里是你安装的目录第一步:(1) 测试MySQL工作是否正常。打开cmd命令提示符窗口，输入命令：mysql -u root -p输入密码后，如果能够正常进入MySQL控制台则说明MySQL安装正常。(2) 更改MySQL数据库目录a) 打开cmd...
ubunto安装mysql8.13,无法在Ubuntu 16.04上安装mysql
weixin_34184444的博客
01-30 970
I ran the following commandwget http://repo.mysql.com/mysql-apt-config_0.8.9-1_all.debsudo dpkg -i mysql-apt-config_0.8.9-1_all.debsudo apt-get updateall goes well but when i hitsudo apt-get install m...
Ubuntu16.04安装mysql5.7.22的图文教程
09-09
在这个例子中，假设你已经下载了名为`mysql-server_5.7.22-1ubuntu16.04_amd64.deb-bundle.tar`的文件，并将其放在 `/usr/local/mysql` 文件夹中。使用`cp`命令将其复制到指定位置，然后使用`tar`命令解压缩文件。 ...
ubuntu16.04安装mysql5.7脚本
05-14
在Ubuntu 16.04上安装MySQL 5.7是一项常见的系统管理任务，尤其对于开发者和运维人员来说。MySQL 5.7是该数据库管理系统的一个稳定版本，提供了许多性能改进和新特性。以下是关于使用脚本在Ubuntu 16.04上自动安装...
ubuntu16.04安装Mysql8.0.25
最新发布
03-01
mysql安装配置包
Ubuntu Server 16.04下mysql8.0安装配置图文教程
01-10
Ubuntu Server 16.04下mysql8.0安装配置图文教程 1.从Mysql官网上下载安装文件。有两种方式可供选择： 使用APT安装方式安装 使用完整的安装包进行安装 sudo dpkg -i mysql-apt-config_0.8.6-1_all.deb 2.更新系统...
Ubuntu16.04安装MySQL5.7的教程
09-09
例如，你可以下载`mysql-server_5.7.16-1ubuntu16.04_amd64.deb-bundle.tar`，然后解压： ```bash wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-server_5.7.16-1ubuntu16.04_amd64.deb-bundle.tar tar -xvf ...
Ubuntu使用mysql时报错:Unit mysql.service could not be found.
qq_45846022的博客
02-09 1768
当用命令去查看mysql服务的状态时会提示我们。
ubuntu装mysql错误_Ubuntu下安装MySQL出现FATAL ERROR: Could not find mysqld的解决方法
weixin_31710909的博客
02-11 437
错误信息:#./bin/mysql_install_db –user=mysqlFATAL ERROR: Could not find mysqldThe following directories were searched:-/usr/libexec/usr/sbin/usr/binIf you compiled from source, you need to run ‘make insta...
debain php 不支持mysql_Mysql在debian系统中不能插入和显示中文的解决方法
weixin_39804631的博客
01-19 68
在debian环境下，彻底解决mysql无法插入和显示中文的问题 Linux下Mysql插入中文显示乱码解决方案 mysql -uroot -p 回车输入密码 进入mysql查看状态如下： 默认的是客户端和服务器都用了latin1，所以会乱码。 解决方案: mysqluser mydb; mysqlalter database在debian环境下，彻底解决mysql无法插入和显示中文的问题Linu...
docker运行ubuntu22.04出现异常（转载）
qq_43808467的博客
08-29 3067
Problem executing scripts APT::Update::Post-Invoke 'rm -f /var/cache/apt/archives/*.deb /var/cache/apt/archives/partial/*.deb /var/cache/apt/*.bin || true' E: Sub-process returned an error code
在Ubuntu 22.04 LTS Jammy Linux 系统上安装MySQL
itigoitie的博客
05-17 1459
本教程将展示使用命令终端在Ubuntu 22.04 LTS Jammy 上安装MySQL数据库服务器的简单步骤。
VMware虚拟机ubuntu安装Mysql
jianglz的博客
03-10 2052
ubuntu版本 16.04首先通过 apt-get install mysql-server 自动安装mysql服务端期间需要设置mysql的root用户的密码通过 netstate -tap 查看是否有mysql相关服务在监听 如果没有 可能是安装不成功设置ubuntu静态ip（虚拟机以后都不需要关机，只需挂起，也可以不设静态IP）尝试在windows用navicat连接 mysql 端口为3...
ubuntu基本环境配置及mysql8.0.32和mysql workbench安装
海贼王的博客
04-16 1865
初次使用ubuntu系统，进行各种环境配置。
Debian 11安装mysql 5.7.41
OceanWaves1993的博客
05-11 3390
至此安装MySQL 5.7.41成功，查看MySQL服务状态，在安装时已经设置了开机自启动，不需要可以禁用。此次安装是mysql数据库基本安装方式，只安装了这些包。登录数据库root账户 密码是安装MySQL时设置的root账户密码。本次安装失败 是因为依赖关系缺少的依赖包未安装导致导致安装失败。apt-get -f install 修复上述问题。安装过程会自动创建MySQL的systemd服务。此步骤会进行设定mysql的root账户密码。按tab键 选中ok 回车。下载文件 然后解压。
ubuntu16.04安装mysql
03-16
Ubuntu 16.04 安装 MySQL 的步骤如下: 1. 更新软件包列表: `sudo apt-get update` 2. 安装 MySQL: `sudo apt-get install mysql-server` 3. 运行安全设置: `sudo mysql_secure_installation` 4. 启动 MySQL 服务: `...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值