远程登陆mysql
来源:互联网 发布:矩阵计算法则 编辑:程序博客网 时间:2024/05/03 20:30
他帮我改错误,呵呵
update user set host = ’%’ where user = ’root’;
将权限改为ALL PRIVILEGES
mysql> use mysql;
Database changed
mysql> grant all privileges on *.* to root@'%' identified by "root";
Query OK, 0 rows affected (0.00 sec) www.2cto.com
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+-------------------------------------------+
| localhost | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| % | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
+--------------+------+-------------------------------------------+
3 rows in set (0.00 sec)
这样机器就可以以用户名root密码root远程访问该机器上的MySql.
3、实现远程连接(改表法)
use mysql;
update user set host = '%' where user = 'root';
将权限改为ALL PRIVILEGES
mysql> use mysql;
Database changed
mysql> grant all privileges on *.* to root@'%' identified by "root";
Query OK, 0 rows affected (0.00 sec) www.2cto.com
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+-------------------------------------------+
| localhost | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| % | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
+--------------+------+-------------------------------------------+
3 rows in set (0.00 sec)
这样机器就可以以用户名root密码root远程访问该机器上的MySql.
3、实现远程连接(改表法)
use mysql;
update user set host = '%' where user = 'root';
- mysql远程登陆
- mysql远程登陆
- 远程登陆mysql
- mysql远程登陆
- linux下mysql远程登陆
- mysql不允许从远程登陆
- mysql远程登陆设置
- mysql 允许远程登陆
- mysql的远程登陆设置
- MySQL远程登陆操作
- mysql 远程登陆不上
- Mysql远程登陆及常用命令
- 开启 MySQL 的远程登陆
- mysql 无法远程登陆解决办法
- Mysql 远程登陆配置
- Mysql 远程登陆用户权限设置
- MySQL 支持远程登陆设置
- Mysql远程登陆方法
- 解决MySql连接超时
- 安卓ksoap2获取.net webservice后返回DateSet型的数据的解析方法
- c# Json List<T> DataTable 数据相互转换
- 数学之路(3)-机器学习(3)-机器学习算法-欧氏距离(4)
- AndroidMenifest.xml中minSdkVersion、targetSdkVersion、targetApiLevel的区别
- 远程登陆mysql
- pkginfo、pkgadd和pkgrm命令的用法
- ubuntu下更改分辨率
- [Matlab]科研中的心得(updating)
- linux永久添加新路径
- 经典收藏 50个jQuery Mobile开发技巧集萃
- 4.3.1 位置变化动作
- Memcache相关
- CCMoveBy和CCMoveTo有什么区别?