配置
獲取默認(rèn)密碼
grep 'temporary password' /var/log/mysqld.log
開放遠(yuǎn)程訪問
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
找到
bind-address = 127.0.0.1
前面加#注釋掉哪替，wq!強(qiáng)制保存并退出庸娱，重啟服務(wù)拄养。
創(chuàng)建用戶
//創(chuàng)建用戶
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
//授權(quán)遠(yuǎn)程訪問
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
//修改默認(rèn)密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
//修改密碼
set password for 'root'@'localhost'=password('password');
創(chuàng)建庫
create database name character set utf8 collate utf8_general_ci;
重啟服務(wù)
ubuntu下
service mysql restart
centos下
//啟動(dòng)服務(wù)
systemctl start mysqld
//開機(jī)啟動(dòng)
systemctl enable mysqld
systemctl daemon-reload
連接時(shí)指定時(shí)區(qū)/編碼
//設(shè)置時(shí)區(qū)
&serverTimezone=UTC
//設(shè)置編碼
&characterEncoding=utf-8
//自動(dòng)重連
&autoReconnect=true
