Hi gang,

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!


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 '"']


Don Wieland
donw@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band