Am 19.09.2014 um 16:43 schrieb Don Wieland: > Trying to generate a CSV file using mySQL and I keep getting this error > below. The target folder has full permissions to write (777). I am not > certain why this is happening. Any answers? Thanks!
the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions > Database_Class error: DATABASE_ERROR: Access denied for user > 'teal1dwd_teal'@'localhost' (using password: YES) IN [SELECT u.user_id, > u.first_name AS u_first_name, > u.last_name AS u_last_name, > c.client_id AS c_client_id, > c.first_name AS c_first_name, > c.middle_name AS c_middle_name, > c.last_name AS c_last_name, > c.address AS c_address, > c.city AS c_city, > c.state AS c_state, > c.zip AS c_zip, > c.dob AS dob_ymd, > c.phone_home AS c_phone_home, > c.phone_cell AS c_phone_cell, > c.phone_work AS c_phone_work, > c.email AS c_email, > c.other_contacts AS c_other_contacts, > count(*) as apt_qty > > FROM tl_appt apt > > JOIN tl_clients c on c.client_id = apt.client_id > JOIN tl_rooms r on r.room_id = apt.room_id > JOIN tl_users u on u.user_id = apt.user_id > > WHERE > > apt.time_start between '1388552400' and '1420088399' > and r.location_id = '1' > > GROUP BY u.user_id, c.client_id > having count(*) > 1 > > ORDER BY u.first_name, u.last_name, c.last_name, c.first_name > INTO OUTFILE '/tmp/1_2031305738.csv' > FIELDS TERMINATED BY ',' > ENCLOSED BY '"']
signature.asc
Description: OpenPGP digital signature
