Advertisement
Guest User

Untitled

a guest
Nov 5th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. SELECT * INTO OUTFILE '/home/myacnt/docs/mysqlCSVtest.csv'
  2. FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '*'
  3. LINES TERMINATED BY 'n'
  4. FROM tbl_property
  5. WHERE managerGroupID = {$managerGroupID}
  6.  
  7. Access denied for user 'asdfsdf'@'localhost' (using password: YES)
  8.  
  9. > grant all privileges
  10. on YOUR_DATABASE.*
  11. to 'asdfsdf'@'localhost'
  12. identified by 'your_password';
  13. > flush privileges;
  14.  
  15. > GRANT FILE ON *.* TO 'asdfsdf'@'localhost';
  16.  
  17. echo "select * from employee" | mysql --host=HOST --port=PORT --user=UserName --password=Password DATABASE.SCHEMA > output.txt
  18.  
  19. GRANT FILE ON *.* TO user;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement