# 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);
...