Analysis tool for mysql?

I just learned mysql course and still have no feel how one better use MySQL. When I learn SAS (statistical analysis system) MySQL lets me quickly understand lots of concepts there since SAS does use a similar concept in its proc SQL. I wonder if there is an analytic tool to analyze MySQL? how will a data analyst use mysql?