Resveratrol (RSV) is a natural compound found in grapes and red wine. It has been well known for its beneficial effects as a dietary supplement in prevention of cardiovascular diseases and cancer. Recently, in vitro studies have reported the neuroprotective role of RSV in neurodegenerative process in Alzheimer’s disease (AD). However, in vivo effects of RSV on the decline of brain function accompanying the aging process, especially those on cognitive loss, have not been not investigated. Here we report that, after intraventricular injection of RSV for one week in 8–9 month-old mice, the long-term memory formation and the LTP induction from hippocampus CA1 were improved. The RSV enhancement effects were blocked in SIRT1 mutant mice. Additional experiments suggest that RSV effects are likely to be mediated through reduced expressions of miR-134 and miR-124, which may in turn up-regulate CREB levels to subsequently promote BDNF synthesis. These findings demonstrate a role for RSV in cognition and a microRNA-CREB-BDNF mechanism by which RSV regulates these processes, demonstrating its value as a potential therapeutic target against CNS disorders in aging.