linux下MySQL授权其他机器访问的问题?报错

                    <p>grant all privileges on *.* to ‘root’@'%' identified by 'root1';  加上引号</p>

                

                        好了,谢谢
                    

                        https://www.cnblogs.com/xyabk/p/8967990.html，这篇文章会帮到你
                    

                        mysql 版本为8.0.11
                    

                        mysql> grant all privileges on *.* to 'root'@'%' identified by 'root';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the

                    <p>mysql8改变很大.不少语句的管理方法都不一样了,看看官方文档吧.</p>

讲真,不是必要,暂时不要升级到8

                        弄好了,谢谢
                    

                    <p>设置远程访问（使用root密码）：</p>

grant all privileges on *.* to 'root' @'%' identified by '123456';

flush privileges;

                        解决了,谢谢