mysql> grant all privileges on*.* to 'root'@'%'identified by'root'with grant option;
ERROR 1064 (42000): You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version forthe right syntax to use near 'identified by 'root' with grant option'at line 1
mysql> create user 'brady'@'%'identified by'brady';
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is9
Server version: 8.0.13 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle isa registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;'or '\h'forhelp. Type '\c'to clear the current input statement.
mysql> grant all privileges on*.* to 'root'@'%'identified by'root'with grant option;
ERROR 1064 (42000): You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version forthe right syntax to use near 'identified by 'root' with grant option'at line 1
先创建一个其他用户
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<br>mysql> create user 'brady'@'%'identified by'brady';
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql>
mysql> grant all privileges on*.* to 'brady'@'%'identified by'brady'with grant option;
ERROR 1064 (42000): You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version forthe right syntax to use near 'identified by 'brady' with grant option'at line 1
mysql> GRANT ALL PRIVILEGES ON *.* TO 'brady'@'%';
Query OK, 0 rows affected (0.04 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'brady'@'%'IDENTIFIED WITH mysql_native_password BY 'brady';
之前一直用mysql5.7 远程授权登录,后来换mysql8.0原来的授权方式报错 mysql> grant all privilegeson*.* to'root'@'%'identifiedby'root'with grant option; ERROR 1064 (42000): You have an errorinyour SQL syntax; check the manual that correspon...