Actually a stain rather than a paint (sometimes there's confusion between the two).
A stain actually permeates the wood, and allows the color to sink in. You can go to any local furniture place (preferably an unfinished store, since they have more products), and find really cool colors in stains. Try not to purchase any products that contain stain and sealer in one. The sealer sometimes prevents the stain from completely absorbing into the wood.
A good white, or off-white can be achieved using a "white wash" stain. The first coat is usually very light, but with multiple coats, the color will become more bold. And when your finished, top-coat with 2 to 3 coats of polyurethane. It's a hard finish which will help with nicks and dings. It also make the wood completely sealed, so water won't make it swell. It will take a little time to do all these steps, but it's worth it.
What color are you looking for?
And keep in mind, you worked hard on the stand, so don't sell yourself short on the finishing. The better the finish job, the better it will look and last.