飞翔的博客

1. 用户授权create user 'test'@'%' identified by 'test123456';grant all privileges on testdb.* to test@'%';flush privileges;2. 远程上传授权查询远程上传是否开启：show global variables like 'local_infile';远程上传授权：set global local_infile='ON';3. 远程登录启用mysql --lo

1. 下载软件https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz2. 创建不可登录mysql用户# groupadd mysql# useradd -r -g mysql -s /bin/false mysql3. 安装libaio# rpm -qa | grep libaio#

 一、连接MySQL数据库1.  MySQL JDBC四大参数private static String driver = "com.mysql.jdbc.Driver";private static String url = "jdbc:mysql://127.0.0.1:3306/local_test?characterEncoding=UTF-8&useSSL=false...