4 回答

TA貢獻(xiàn)1813條經(jīng)驗(yàn) 獲得超2個(gè)贊
root
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES;
my.cnf
/etc/mysql/my.cnf
C:\Program Files\MySQL\MySQL Server 5.5\
my.ini
.
bind-address = 127.0.0.1
#bind-address = 127.0.0.1

TA貢獻(xiàn)1780條經(jīng)驗(yàn) 獲得超4個(gè)贊
root
3306
MySQL
select user, host, password from mysql.user;
MySQL
I root
.
use mysql;update user set password=PASSWORD("NEWPASSWORD") where User='root';flush privileges;

TA貢獻(xiàn)1812條經(jīng)驗(yàn) 獲得超5個(gè)贊
檢查端口是否接受連接:
telnet (mysql server ip) [portNo]
添加IP表規(guī)則以允許端口上的連接:
iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
在生產(chǎn)環(huán)境中不推薦這樣做,但是如果您的iptables配置不正確,添加規(guī)則可能仍然無法解決這個(gè)問題。在這種情況下,應(yīng)開展以下工作:
service iptables stop
添加回答
舉報(bào)