I'm not a heavy db user, but I touch it once or twice a day. I use mycli as my daily driver. I configured separate profiles for when I connect to prod, and added autocomplete for my db profiles.

I haven't found a gui I'm happy with on Linux, but I've been loving mycli for the last 4 years or so.