Linux安装Mysql步骤_dmysql 目录下没有debian.cnf文件-优快云博客

本文链接：https://blog.youkuaiyun.com/lu__lala/article/details/122120251

本文详细介绍了在Ubuntu Linux上安装MySQL的过程，包括更换阿里云镜像源、升级系统、安装MySQL、设置初始密码、允许远程访问等关键步骤，是Linux初学者安装MySQL的实用指南。

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

所有操作全部在虚拟机控制台执行，每一步复制执行即可

1.因为国外源下载不了，把源更新为国内的
sudo gedit /etc/apt/sources.list

2.
deb http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse

3.刷新源
sudo apt-get update
sudo apt-get upgrade

4.更新源
sudo apt update

5.在线下载mysql
sudo apt-get install mysql-server

6.测试mysql服务是否安装成功
service mysql start 启动

   service mysql status

   service mysql stop停止

7.如果忘了初始密码
可以cd etc/mysql下有一个配置文件
debian.cnf 可以用gedit debian.cnf打开

8.然后用文件中的账号密码登录
mysql -udebian-sys-maint -puHJWAzEiOjtm3Ikl

9.登陆进去
   use mysql;
   use mysql;
   update user set authentication_string=PASSWORD("自定义密码") where user='root';
   update user set plugin="mysql_native_password";
   flush privileges;
   quit;
10.再重启服务就行了

11.如果要windows连接linux中的mysql 则要突破防火墙设置多用户访问
   先找到/etc/mysql/mysql.conf.d/ 目录下有一个mysqlld.conf的文件
       sudo gedit mysqld.cnf
   注释掉其中 bind-address这一行
   然后service mysql restart重启服务
   就可以了

grant all privileges on *.* to 'root'@'%' identified by '123123' with grant option;