Check permission of user 'teal1dwd_teal' DK Sent from Phone
> On 19-Sep-2014, at 8:13 pm, Don Wieland <d...@pointmade.net> wrote: > > 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 > d...@pointmade.net > http://www.pointmade.net > https://www.facebook.com/pointmade.band > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
