Ubuntu16.04上安装MySQL

Love The Way You Lie 2023-01-05 12:07 157阅读 0赞

### 文章目录 ###

*  Ubuntu16.04上安装MySQL
 *   *  1、安装
     *  2、启动和关闭mysql服务器：
     *  3、进入mysql shell
     *  4、解决乱码问题

# Ubuntu16.04上安装MySQL #

## 1、安装 ##

root@ubuntu:/# apt-get update
    #更新软件源
    
    root@ubuntu:/# apt-get install mysql-server
    #安装mysql

安装过程会提示设置mysql root用户的密码，设置完成后等待自动安装即可。默认安装完成就启动了mysql。

## 2、启动和关闭mysql服务器： ##

service mysql start
    service mysql stop

## 3、进入mysql shell ##

root@ubuntu:/# service mysql start
    root@ubuntu:/# mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 4
    Server version: 5.7.32-0ubuntu0.16.04.1 (Ubuntu)
    
    Copyright (c) 2000, 2020, 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>

## 4、解决乱码问题 ##

*  编辑配置文件。`sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf`
 *  在\[mysqld\]下添加一行`character_set_server=utf8`

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNDcyODc3_size_16_color_FFFFFF_t_70]

*  重启MySQL服务。`service mysql restart`
 *  登陆MySQL，并查看MySQL目前设置的编码。`show variables like "char%";`

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNDcyODc3_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNDcyODc3_size_16_color_FFFFFF_t_70]: /images/20221119/b41a93e2eaa94962ad7379a8826ed5bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNDcyODc3_size_16_color_FFFFFF_t_70 1]: /images/20221119/b6f6988ac0a445678b716806115469f9.png