is not allowed to connect to this MySql server
来源:互联网 发布:信用卡可以在淘宝套现 编辑:程序博客网 时间:2024/04/28 01:27
在其他机子上链接到mac上的mysql的时候报错:is not allowed to connect to this MySql server
userdeMacBook-Pro:~ user$ mysql -h localhost -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 785
Server version: 5.6.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, 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'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
userdeMacBook-Pro:~ user$
如此即可连接上了
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- C语言之辅助循环手段continue和break
- 关于Opengl各种矩阵变换的理解
- 【伤逝版 红颜劫】
- 控制执行流程
- cocos2dx[3.2] ——核心类Director/Scene/Layer/Sprite详细讲解
- is not allowed to connect to this MySql server
- java 集合类学习笔记
- 十七、斐波那契数列 【递推思想(迭代思想)解决】
- 关于“性能计数器注册表单元配置一致性”检测失败解决办法
- LeetCode Container With Most Water
- iOS-内存管理就这么简单2
- 泰勒公式(泰勒展开式,泰勒中值定理)使用基本技巧
- SQL数据库“正在恢复”,解决和查看方法
- apache django 配置