linux连接windows的数据库
1、首先在windows上的数据库操作；点击连接管理-->点击-->新建
如果之前就有连接，只是想加入数据库，可以导入数据了；
2、linux上连接windows
安装好mysql后：
[[email protected] html]# mysql -uroot -p
Enter password:O#E1Bui_i(ey
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.7.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, 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.
Your MySQL connection id is 23
Server version: 5.7.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, 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> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyNewPass4!' WITH GRANT OPTION;
解释一下：
- 第一个*是数据库，可以改成允许访问的数据库名称
- 第二个 是数据库的表名称，代表允许访问任意的表
- root代表远程登录使用的用户名，可以自定义
- %代表允许任意ip登录，如果你想指定特定的IP，可以把%替换掉就可以了
- password代表远程登录时使用的密码，可以自定义
- flush privileges;这是让权限立即生效
出现这个就好了Query OK, 0 rows affected (0.00 sec)
mysql> exit;退出mysql；