spring mysql datasouce

mysql> create user testuser;

Query OK, 0 rows affected (0.00 sec)

mysql> create user testuser@localhost identified by 'testuser';

Query OK, 0 rows affected (0.00 sec)

mysql> create schema test default character set utf8;

Query OK, 1 row affected (0.00 sec)

mysql> select host, user, password from user;

+-----------------------+----------+-------------------------------------------+

| host                  | user     | password                                  |

+-----------------------+----------+-------------------------------------------+

| localhost             | root     |                                           |

| skp1002428mn001.local | root     |                                           |

| 127.0.0.1             | root     |                                           |

| ::1                   | root     |                                           |

| localhost             |          |                                           |

| skp1002428mn001.local |          |                                           |

| %                     | testuser |                                           |

| localhost             | testuser | *3A2EB9C80F7239A4DE3933AE266DB76A7846BCB8 |

+-----------------------+----------+-------------------------------------------+

8 rows in set (0.00 sec)

mysql> grant all privileges on test.* to testuser@localhost;

Query OK, 0 rows affected (0.00 sec)

mysql> grant select, insert, update, delete on test.* to testuser@localhost;

Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql -utestuser -ptestuser

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  

        <property name="driverClassName" value="com.mysql.jdbc.Driver" />

        <property name="url" value="jdbc:mysql://localhost:3306/test" />

        <property name="username" value="testuser" />

        <property name="password" value="testuser" />

    </bean>