Ubuntu19.10安装mysql及换源

最新推荐文章于 2025-03-14 20:31:14 发布

风吹我亦散

最新推荐文章于 2025-03-14 20:31:14 发布

阅读量353

点赞数 1

文章标签： ubuntu mysql

本文链接：https://blog.csdn.net/weixin_45468845/article/details/105233444

版权

本文介绍了在Ubuntu 19.10上安装MySQL的步骤，包括如何通过命令行安装，以及系统自动分配的密码。同时，详细讲解了如何修改MySQL的root用户密码。此外，还提供了Ubuntu 19.10系统换源的操作指南，包括备份源列表、替换新的源地址和更新系统。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

安装apache和php请点击
一.安装命令：

sudo apt-get install mysql-server

（没有换源时，执行命令可能出错，最后面会说如何换源）

二.登陆mysql
mysql装好之后系统是自动分配密码的，在/etc/mysql/debian.cnf中

vim /etc/mysql/debian.cnf

出现如下结果，可以查看用户和密码

[client]
host     = localhost
user     = debian-sys-maint
password = U0tkLbNnRhRL8vKY
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = U0tkLbNnRhRL8vKY
socket   = /var/run/mysqld/mysqld.sock

然后根据用户和密码登陆：（每个人密码不一样，下面这是我自己的）
登陆mysql的代码为：mysql -u用户名 -p密码

mysql -udebian-sys-maint -pU0tkLbNnRhRL8vKY

三.修改用户名和密码
登陆之后，使用数据库：

use mysql

将root用户密码置空

update user set authentication_string='' where user='root';

清空root用户默认的密码：

select user,authentication_string from user where user='root';

为root设置密码：

ALTER user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

修改密码时，可能因修改的密码太过简单而不能修改成功，可降低密码级别：

set global validate_password_policy=0;

查看MySQL是否启动

service mysqld status

现在登陆mysql就可以啦

Ubuntu 19.10换源
因为我的版本是19.10，所以就写的是19。10的，不同版本只是源地址不同，其他方式都是一样
一.备份
不备份弄错了的话不要怪我

sudo cp -v /etc/apt/sources.list /etc/apt/sources.list.bak

然后将下面内容复制粘贴到sources.list中，选一个就可以了

#阿里云源
deb http://mirrors.aliyun.com/ubuntu/ eoan main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ eoan main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ eoan-security main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ eoan-security main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ eoan-updates main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ eoan-updates main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ eoan-backports main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ eoan-backports main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ eoan-proposed main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ eoan-proposed main restricted universe multiverse

#中科大源
deb https://mirrors.ustc.edu.cn/ubuntu/ eoan main restricted universe multiverse
deb-src https://mirrors.ustc.edu.cn/ubuntu/ eoan main restricted universe multiverse
deb https://mirrors.ustc.edu.cn/ubuntu/ eoan-updates main restricted universe multiverse
deb-src https://mirrors.ustc.edu.cn/ubuntu/ eoan-updates main restricted universe multiverse
deb https://mirrors.ustc.edu.cn/ubuntu/ eoan-backports main restricted universe multiverse
deb-src https://mirrors.ustc.edu.cn/ubuntu/ eoan-backports main restricted universe multiverse
deb https://mirrors.ustc.edu.cn/ubuntu/ eoan-security main restricted universe multiverse
deb-src https://mirrors.ustc.edu.cn/ubuntu/ eoan-security main restricted universe multiverse
deb https://mirrors.ustc.edu.cn/ubuntu/ eoan-proposed main restricted universe multiverse
deb-src https://mirrors.ustc.edu.cn/ubuntu/ eoan-proposed main restricted universe multiverse

#163源
deb http://mirrors.163.com/ubuntu/ eoan main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ eoan-security main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ eoan-updates main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ eoan-proposed main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ eoan-backports main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ eoan main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ eoan-security main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ eoan-updates main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ eoan-proposed main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ eoan-backports main restricted universe multiverse

#清华源
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-updates main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-updates main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-backports main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-backports main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-security main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-security main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-proposed main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ eoan-proposed main restricted universe multiverse

安装好后更新即可
sudo apt-get update