MySql的安装及配置
安装命令:
sudo apt-get install mysql-server-5.7
不能下载(下载报错)(更换源163或者腾讯源)
换源操作:
备份:
sudo cp /etc/apt/sources.list /etc/apt/sources.list_bk
编辑:
sudo gedit /etc/apt/sources.list#或者 sudo vim /etc/apt/source.list
添加源(163源):
deb http://mirrors.163.com/ubuntu/ bionic main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ bionic-security main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ bionic-updates main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb http://mirrors.163.com/ubuntu/ bionic-backports main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ bionic main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ bionic-security main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ bionic-updates main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb-src http://mirrors.163.com/ubuntu/ bionic-backports main restricted universe multiverse
更新:
sudo apt-get update
参考链接:https://blog.csdn.net/rrrrr11111jjjjjj/article/details/117045738
安装完成:
mysql --version #查看版本
MySQL相关设置:
先查看密码:
sudo cat /etc/mysql/debian.cnf
登录MySQL:
mysql -h localhost -u debian-sys-maint -p
输入上述密码后登录:
设置账号密码(以root账号密码为123456为例)
update mysql.user set authentication_string=password('123456') where user='root' and host='localhost';
这步尤其重要:
update mysql.user set plugin='mysql_native_password';
更新:
flush privileges;
退出:
quit;
重启数据库:
sudo service mysql restart
以刚刚设置的账号密码登录数据库:
mysql -h localhost -u root -p123456
show variables like 'character_set_%';
退出:
quit;