[realme]JDBCRealm MySQL Server.xml

<?xml version="1.0" encoding="UTF-8"?>
<Server
	port="8105"
	shutdown="SHUTDOWN">

	<Listener
		SSLEngine="on"
		className="org.apache.catalina.core.AprLifecycleListener" />

	<Listener className="org.apache.catalina.core.JasperListener" />
	<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
	<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
	<Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" />

	<GlobalNamingResources>
		<!-- conf/tomcat.xml -->
		<Resource
			auth="Container"
			name="UserDatabase"
			factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
			pathname="conf/tomcat-users.xml"
			type="org.apache.catalina.UserDatabase" />
	</GlobalNamingResources>
	.
	<Service name="Catalina">

		<Connector
			connectionTimeout="20000"
			port="8180"
			protocol="HTTP/1.1"
			redirectPort="8443" />

		<Engine
			defaultHost="localhost"
			name="Catalina">

			<!-- conf/tomcat.xml -->
			<Realm
				className="org.apache.catalina.realm.UserDatabaseRealm"
				resourceName="UserDatabase" />
				
			<!-- jdbc:mysql://localhost/base2 -->
			<Realm
				resourceName="MySqlUserDatabase"
				className="org.apache.catalina.realm.JDBCRealm"
				connectionName="base2"
				connectionPassword="base2"
				connectionURL="jdbc:mysql://localhost/base2"
				driverName="com.mysql.jdbc.Driver"
				userTable="tbuser"
				userNameCol="account"
				userCredCol="password"
				userRoleTable="tbuser"
				roleNameCol="role" />

			<Host
				appBase="webapps"
				autoDeploy="true"
				name="localhost"
				unpackWARs="false">

				<Context
					docBase="struts2.app"
					path="/struts2.app"
					reloadable="true"
					source="org.eclipse.jst.j2ee.server:struts2.app">
				</Context>
			</Host>
		</Engine>
	</Service>
</Server>

CREATE TABLE `tbuser` (
   `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
   `account` varchar(50) NOT NULL,
   `role` varchar(50) NOT NULL,
   `password` varchar(50) NOT NULL,
   `created` datetime NOT NULL,
   `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `deleted` date
);