Access denied for user with GRANT priviliege
Clash Royale CLAN TAG #URR8PPP Access denied for user with GRANT priviliege I have a DB named abc_products , with various tables. One of them is named table1 . abc_products table1 I created a new DB user named abc_user , and want to restrict its DB access only to that table. abc_user I logged to SSH Terminal as root user, and typed: root root@host [~]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5721225 Server version: 5.6.39 MySQL Community Server (GPL) mysql> use abc_products Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> GRANT SELECT ON `table1` TO 'abc_user'@'localhost'; Query OK, 0 rows affected (0.00 sec) But when I try to connect to MySQL with this user, I get an access denied error in my Chrome Console XHR response: Connect failed: Access denied for user 'abc_user'@'localhost' (using pa...