Archlinux 下的 mariadb 和 jdbc

# pacman -S mariadb

# mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

# systemctl enable mysqld.service

# systemctl start mysqld.service

# mysql_secure_installation

遗忘root密码的话，类似windows下：

# systemctl stop mysqld.service

# mysqld_safe --skip-grant-tables &

# mysql -u root mysql

mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit

停止和重启mysqld守护进程。

设置文件：/etc/mysql/my.cnf；注意wiki.archlinux中提到的文件权限问题，包括utf-8的使用

安装 mysql workbench （navicat是用wine启动的）

# pacman -S mysql-workbench

安装jdbc

$ yaourt -S mariadb-jdbc

还需放入Web App Libraries中，:(

$ cp /usr/share/java/mariadb-jdbc/mariadb-java-client-1.1.8.jar /home/xxx/workspace/projectname/WebContent/WEB-INF/libs

然后，java中测试

	try {
		Class.forName("org.mariadb.jdbc.Driver");
	} catch (ClassNotFoundException e) {
		out.print(e);
	}

	String uri = "jdbc:mariadb://localhost:3306/" + dataSource;
	try {
		con = DriverManager.getConnection(uri, "user", "password");
		sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
				ResultSet.CONCUR_READ_ONLY);
		String s = "select * from " + tableName;
		rs = sql.executeQuery(s);
...