Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * INTO OUTFILE '/home/myacnt/docs/mysqlCSVtest.csv'
- FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '*'
- LINES TERMINATED BY 'n'
- FROM tbl_property
- WHERE managerGroupID = {$managerGroupID}
- Access denied for user 'asdfsdf'@'localhost' (using password: YES)
- > grant all privileges
- on YOUR_DATABASE.*
- to 'asdfsdf'@'localhost'
- identified by 'your_password';
- > flush privileges;
- > GRANT FILE ON *.* TO 'asdfsdf'@'localhost';
- echo "select * from employee" | mysql --host=HOST --port=PORT --user=UserName --password=Password DATABASE.SCHEMA > output.txt
- GRANT FILE ON *.* TO user;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement