Can not create a user following https://proxysql.com/documentation/ProxySQL-Configuration/

[Jose Cabrera]

I am following:

https://proxysql.com/documentation/ProxySQL-Configuration/

While trying to create the stnduser I got:

ProxySQL Admin> CREATE USER 'stnduser'@'%' IDENTIFIED BY 'stnduser';
ERROR 1045 (28000): ProxySQL Admin Error: near "USER": syntax error

Later, I run the next cmd:

ProxySQL Admin>  INSERT INTO mysql_users(username,password,default_hostgroup) VALUES ('stnduser','stnd                                                                       user',1);
Query OK, 1 row affected (0.001 sec)

ProxySQL Admin>  SELECT * FROM mysql_users;
+----------+----------+--------+---------+-------------------+----------------+---------------+-------                                                                       -----------------+--------------+---------+----------+-----------------+------------+---------+
| username | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transa                                                                       ction_persistent | fast_forward | backend | frontend | max_connections | attributes | comment |
+----------+----------+--------+---------+-------------------+----------------+---------------+-------                                                                       -----------------+--------------+---------+----------+-----------------+------------+---------+
| stnduser | stnduser | 1      | 0       | 1                 | NULL           | 0             | 1                                                                                             | 0            | 1       | 1        | 10000           |            |         |
+----------+----------+--------+---------+-------------------+----------------+---------------+-------

So, I tried to grant all privileges stnduser using:

ProxySQL Admin> GRANT ALL PRIVILEGES ON . TO 'stnduser'@'%';
ERROR 1045 (28000): ProxySQL Admin Error: near "GRANT": syntax error

Is the guide wrong?

Thanks

[René Cannaò]

Hi Jose,

No, the guide is not wrong.

Please pay attention to the guide.
Right above the line you copy/paste it shows:

"To create the user in MySQL connect to the PRIMARY and execute"

... that is clearly not what you did.
Please read carefully.

Thanks

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/proxysql/87fed4c6-fbee-4986-8bbd-c610ed78bd71n%40googlegroups.com.