1.双机mysql-5.6.20-winx64.msi,按照提示安装完成。
2.在安装的目录下,比如安装目录是“D:\Program Files\mysql\MySQL Server 5.6”,复制目录下的my-default.ini,重命名为my.ini保存到相同路径下。修改my.ini,
my.ini内容中有提示。我更改的内容是下面这几个参数
# These are com...
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo...
查询是否可以远程访问:
select * from mysql.user where host=% and user=MysqlUserName;
1.允许远程访问
grant all privileges on *.* to MysqlUserName@'%' identified by 'MysqlPassword' with grant option;
flush...