前言:
之前数据库接触的较少,最近需要在服务器保存一些数据。建立数据库之后发现:
使用 mysql -h 172.16.0.... -uroot -p 登录报错
解决方案如下:
step1:修改服务器mysql数据库的访问IP设置
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 127.0.0.1表示只接受本机操作数据库,不允许使用-h 来远程登录mysql
#注销此行
step2:修改数据库远程访问权限
ssh 登录服务器
本地登录数据库 :
mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.30-0ubuntu0.16.04.1 (Ubuntu)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
...@TVM2:~$ service mysql restart
step3:重启数据库
service mysql restart