ubuntu系统下MySQL安装以及测试
安装测试登录MySQL
本文直接选择apt安装,也可以去MySQL下载平台,下载对应的软件.
sudo netstat -tap | grep mysql
sudo apt-get install mysql-server mysql-client
上面代码的含义是第一句检查之前这台机器上有没有安装MySQL,第二句即安装MySQL.
检查是否安装成功,并且启动服务.
sudo netstat -tap | grep mysql
service mysql start
对应的界面应该类似如下
tcp 0 0 localhost:mysql 0.0.0.0:* LISTEN 4165/mysqld
然后选择进入
mysql
我显示的界面如下
ERROR 1045 (28000): Access denied for user 'lenovo'@'localhost' (using password: NO)
所以我去添加了密码
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
在最后一行添加
skip-grant-tables
然后重启mysql
sudo systemctl restart mysql.service
无密码进入mysql,并且修改密码
mysql
update mysql.user set authentication_string=password('12345671') where user='root';
flush privileges
quit;
在此过程中出现的输出为
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
Query OK, 0 rows affected (0.00 sec)
Bye
然后去刚刚修改的地方,删除或者注释最后一行上的skip-grant-tables
.,然后重启mysql.
sudo systemctl restart mysql.service
再次登录,按上面所写添加skip-grant-tables
,如果出现下面的问题,再来修改
mysql -u root -p
Enter password:
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
修改如下
select user,plugin from user;
+------------------+-----------------------+
| user | plugin |
+------------------+-----------------------+
| root | auth_socket |
| mysql.session | mysql_native_password |
| mysql.sys | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)
修改root对应的auth_socket
为mysql_native_password
update user set authentication_string=password("12345671"),plugin='mysql_native_password' where user='root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> select user,plugin from user;
+------------------+-----------------------+
| user | plugin |
+------------------+-----------------------+
| root | mysql_native_password |
| mysql.session | mysql_native_password |
| mysql.sys | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)
quit
Bye
再次登录
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.28-0ubuntu0.18.04.4 (Ubuntu)