For MySQL console, it is easy to connect to the DB.
As I have already created the database allartist, I need only to execute the command:
mysql> connect allartist
Now I can do a select * from artist to display nicely the data in the table artist.
Note that you need to type in \g to execute the command.