MariaDB[databaseName]> select * from tableName INTO OUTFILE 'order.txt';
Error 1045 (28000): Access denied for user 'userName'@'%' (using password: YES)
How do I fix this please?
Asked
Active
Viewed 59 times
0
-
What do you have for `SHOW GRANTS FOR 'userName'@'%';`? (but leave out the pwd.) – Rick James Feb 19 '17 at 23:17
-
http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold – Georg Richter Feb 20 '17 at 07:59
-
GRANT USUAGE ON *.* TO 'userName'@'%' IDENTIFIED BY PASSWORD 'xxx" WITH MAX_USER_CONNECTIONS 200 – yaris Feb 22 '17 at 14:26
-
GRANT ALL PRIVILEGES ON 'datasbaseName'.* TO 'userName'@'%' – yaris Feb 22 '17 at 14:27
-
Can somebody help,please? – yaris Feb 23 '17 at 21:51