gousername

thank you that was helpful but right now i’m trying to extract the datas, its working on other database but for wordpress datas in mysql it says Access denied for user ‘username’@’localhost(using password: YES), why is that? and is there anyway i can make a seperate database in mysql add input user details from wp_users and order details from woocommerce orders?

But i wanna link the user email from wp_users to order_id in woocommerce order items so i can extract the customer details and order details together in the system im developing, can you help me with this please?

Thank you. that works but how do i extract the woocommerce order information from mysql including the user’s email address?