I’ll work with MySQL on Ubuntu Server 18.04. Creating a database The first thing to do is to create a database. I’m going to demonstrate by creating a database called TECHREPUBLIC.

If MySQL is up and running, you have all the necessary software. To pull off this task, you will need the password for the MySQL user that has permissions to access the database (s) in question.

For example, type "mysql -u root -p" (without the quote marks) and enter your password when prompted. Create a MySQL SELECT query to select the data you want to output to CSV.