Mac-mysql操作
打开关闭mysql
打开mysql:
sudo /usr/local/mysql/support-files/mysql.server start
关闭mysql:
sudo /usr/local/mysql/support-files/mysql.server stop
重启mysql:
sudo /usr/local/mysql/support-files/mysql.server restart
彻底删除mysql
1.打开终端
2.stop数据库服务器
4.依次执行以下命令
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /private/var/db/receipts/*mysql*
MySQL数据库驱动的连接方式
旧版本(5.x)的连接方式:
db.driverClassName=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/test?jdbc:mysql://localhost:3306/test?user=数据库用户&password=输入密码&useUnicode=true&characterEncoding=UTF-8
新版本(6.x及以上)的连接方式:
db.driverClassName=com.mysql.cj.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/test?user=数据库用户&password=输入密码&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT
注: 不同版本mysql对应使用的mysql-connector-java.jar包不同