XiYuJing|文章:MySQL安装

[[ slide_text ]]

[[item.c]]

MySQL安装

发布时间：2022年09月17日 作者：靖华来源：XiYuJing

SQL

##换源

vim /etc/apt/sources.list

>deb http://mirrors.aliyun.com/ubuntu/ focal main restricted universe multiverse
>deb-src http://mirrors.aliyun.com/ubuntu/ focal main restricted universe multiverse
>
>deb http://mirrors.aliyun.com/ubuntu/ focal-security main restricted universe multiverse
>deb-src http://mirrors.aliyun.com/ubuntu/ focal-security main restricted universe multiverse
>
>deb http://mirrors.aliyun.com/ubuntu/ focal-updates main restricted universe multiverse
>deb-src http://mirrors.aliyun.com/ubuntu/ focal-updates main restricted universe multiverse
>
>deb http://mirrors.aliyun.com/ubuntu/ focal-proposed main restricted universe multiverse
>deb-src http://mirrors.aliyun.com/ubuntu/ focal-proposed main restricted universe multiverse
>
>deb http://mirrors.aliyun.com/ubuntu/ focal-backports main restricted universe multiverse
>deb http://mirrors.aliyun.com/ubuntu/ bionic main universe restricted multiverse
>deb-src http://mirrors.aliyun.com/ubuntu/ bionic main universe restricted multiverse #Added by software-properties
>deb-src http://mirrors.aliyun.com/ubuntu/ focal-backports main restricted universe multiverse

##更新

sudo apt-get update

##安装MySQL

sudo apt-get install mysql-server

sudo apt-get install mysql-client

##远程登录

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

> bind-address            = 0.0.0.0

##查看mysql是否启动

service mysql status

##启动mysql服务

service mysql start

##初始化mysql

sudo cat /etc/mysql/debian.cnf

##登录debian-sys-maint用户    密码使用上面password的值

mysql -u debian-sys-maint -p

##创建root用户并设置密码为123123

> use mysql;

> select host, user, authentication_string, plugin from user;

> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123123';

> select host, user, authentication_string, plugin from user;

> flush privileges;

> quit;

##重启mysql

>sudo service mysql restart

##root 用户的远程登录权限

> use mysql;

> select host from user where user='root';
>
> update user set host = '%' where user ='root';
>
> select host from user where user='root';

> flush privileges;

你觉得文章怎么样

已浏览 226 次，0 条评论