进行命令行安装【root角色】
1.安装MySQL服务端和客户端:
apt-get install mysql-server-5.7
2.安装依赖:
apt install libmysqlclient-dev
3.检查状态
apt install net-tools
netstat -tap | grep mysql
4、设置mysql的密码
(1)进入mysql,在命令行直接输入"mysql"
(2)show databases;
(3) use mysql;
(4)show tables;
(5)修改root的plugin和密码
select user,plugin,authentication_string from user;
update user set plugin = 'mysql_native_password' where user='root';
update user set authentication_string=PASSWORD('admin') where user='root';
flush privileges;
(6)退出mysql命令行,"exit"
(7)重启数据库服务
service mysql restart
(8) 正常登录mysql
mysql -u root -p
(9) 查看mysql状态、开启、停止数据库服务
service mysql status # 查看mysql状态
service mysql start # 启动mysql服务
service mysql stop # 停止mysql服务
service msyql restart # 重启mysql服务
(10)安装mysql的图形化管理软件
apt-get install mysql-workbench
(11)从软件中心打开即可