Archlinux 下的 mariadb 和 jdbc

来源：互联网发布：安卓app源码编辑：程序博客网时间：2024/05/23 12:44

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

0 0