1.下载mysql-apt的配置包,并安装
wget https:
/
/
dev.mysql.com
/
get
/
mysql
-
apt
-
config_0.
8.1
-
1_all
.deb
sudo dpkg
-
i mysql
-
apt
-
config_0.
8.1
-
1_all
.deb
在安装的过程中,会要求选择mysql版本,选择mysql5.7版本后,点击“OK”或者回车即可
2.更新apt-get索引
sudo apt
-
get update
3.
安装数据库,在安装过程中,会自动卸载已经安装的老版本数据
sudo apt
-
get install mysql
-
server
4.
重启mysql,并检测安装及配置
sudo service mysql restart
mysql
-
u root
-
p
5.查看mysql安装位置
whereis mysql
6.相关命令
#进入MySQL: mysql -u root -p
#启动: sudo service mysql start
#重启:sudo service mysql restart
#关闭: sudo service mysql stop
7.配置
vi /et/mysql/my.cnf
[client]
default_character_set=utf8
[mysql]
default_character_set=utf8
[mysqld]
character_set_server=utf8
8.修改密码
mysql -uroot -p进入mysql操作界面
show databases;
use mysql;
update user set authentication_string=PASSWORD("自定义密码") where user='root';
update user set plugin="mysql_native_password";
flush privileges;
quit;
然后重启登录service mysql restart
9.允许远程登录
vi /etc/mysql/mysql.conf.d/mysqld.cnf
然后注释掉 bind-address = 127.0.0.1
然后保存退出:wq
然后
grant all on *.* to root@'%' identified by '你的密码' with grant option;
然后即时生效
flush privileges;、
然后退出
quit
最后重启
service mysql restart