Ubuntu下安装MySQL及Win10下Ubuntu子系统安装MySQL

以你之姓@ 2024-04-20 00:03 8阅读 0赞

一、下载

先去Mysql官网下载。附下载链接：[https://dev.mysql.com/downloads/repo/apt/][https_dev.mysql.com_downloads_repo_apt]

![70][]

下载完成后，打开终端输入：

sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

安装执行，选择MySQL8.0

二、安装

sudo apt update
    sudo apt install mysql-server

安装过程中出现如下界面要求用户输入MySQL密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70][]

输入后会有如下界面：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 1][]

OK确定后出现：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 2][]

这时候选择第二种Use Legacy Authentication Method(Retain MySQL 5.x Compatibility),等待安装完成。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 3][]

三、进入

mysql -uroot -p

5.1若直接进入则没有问题，安装成功

5.2若出现如下图所示问题（我用的是新安装的Ubuntu18.04Windows子系统出现了该问题，之前双系统时没有出现过该问题）

![20190920041509504.png][]

![20190920041532335.png][]

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

mysqld: unrecognized service

（1）报错原因（/var/run/mysqld中文件为空）

（2）解决办法（删除mysqld重新创建并授权）

1 cd /var/run/
    2 rm -rf mysqld
    3 mkdir -p mysqld
    4 chown mysql /var/run/mysqld/
    5 service mysql restart
    6 mysql -uroot -p

![20190920041255936.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 4][]

（3）如果未解决（卸载重新用以下方法安装）

1.卸载

sudo su
    apt-get remove mysql-*
    dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
    apt-get autoremove

2.安装

su root
    apt update
    apt install mysql-server
    mysql --version
    /etc/init.d/mysql start

若出现一下错误：

![20210324081605436.png][]

执行如下代码：

/etc/init.d/mysql stop 
    usermod -d /var/lib/mysql/ mysql
    /etc/init.d/mysql start

此时登录mysql是不知道密码的，需要修改如下文件配置跳过mysql密码登录

vi /etc/mysql/mysql.conf.d/mysqld.cnf

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 5][]

在skip-external-locking下面加上

skip-grant-tables

接着：

service mysql restart

之后就能进入mysql了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 6][]

3.进入mysql修改配置

(1)修改登录密码：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 7][]

use mysql;
    update user set authentication_string=password("密码") where user="root";
    #或者执行 set password for 'root'@'localhost' =password('password');
    #不需要（2）修改配置
    flush privileges;
    exit
    vi /etc/mysql/mysql.conf.d/mysqld.cnf  #注释掉skip-grant-tables
    service mysql restart

(2)修改配置

mysql -uroot -p  #登录密码是你刚刚修改的密码
    use mysql;
    select user,plugin from user;

出现如下图示：

![20210324082713429.png][]

在mysql中执行在退出重进就ok了：

update user set authentication_string=password("密码"),plugin='mysql_native_password' where user='root';

[https_dev.mysql.com_downloads_repo_apt]: https://dev.mysql.com/downloads/repo/apt/
[70]: https://img-blog.csdn.net/20180818173838204?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/86b8add4feef401f86a1ecce83907b72.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/21aadf6708fa42ab925f173abf410a65.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a1ec68b1c7334a4b9dd4262dd84d66aa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/5ca72ba78bab4a9785f84c510ed202c7.png
[20190920041509504.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f8cb440915664085bb6ae408ffe4eb6a.png
[20190920041532335.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/4be055e2ea0049639842b479d065d97d.png
[20190920041255936.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/bab69c756fda424ab4dbc038bb2110f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/5bf269f75bdb40c7bcd85eb808c5c99d.png
[20210324081605436.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/3a9299354198428687d91f4a502ad7dc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/aa4e4124f08e443a9c72940c2baa584b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/9f3d6fab696045c4a9e4f5cbcd5f840b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjAzOTY5OQ_size_16_color_FFFFFF_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c89993417baf4794be19973033f3087a.png
[20210324082713429.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/30e5c3c45da84d958129233748298f15.png