On Tue, August 15, 2017 9:31 pm, Ivan Warren wrote:

MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by

...

pasword('test1234'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'pasword('test1234')' at line 1 MariaDB [test]>

A bit OT but...

It's either identified by 'YourPassword'; or Identified by password 'YourPasswordHash';

https://dev.mysql.com/doc/refman/5.7/en/create-user.html

Ivan, thanks!

syntax fixed, I'll try as root

MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by 'test1234'; ERROR 1142 (42000): GRANT command denied to user 'test'@'localhost' for table 'test' MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by password'*3D3B92F242033365AE5BC6A8E6FC3E1679F4140A'; ERROR 1142 (42000): GRANT command denied to user 'test'@'localhost' for table 'test'