Connecting MySQL DB to Apple iWork Numbers?
There is no way to make Numbers get data from a database. (It's more of a consumer tool.) https://discussions.apple.com/thread/1827581
A workaround: you can use Excel to grab the data, and import the XLS file to Numbers for prettier chart-making.
If this is a one-time thing, you can export your data into a .csv file, and then open it with Numbers. Use a query similar to this to export the data:
SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'