image.png
- 配置服務(wù)器
S
- 開(kāi)機(jī)啟動(dòng)
image.png
- 顯示之前的配置
image.png
配置環(huán)境變量
C:\Program Files\MySQL\MySQL Server 5.7\bin查看服務(wù)器是否啟動(dòng)
netstat -ano | findstr 3306命令進(jìn)入mysql
mysql -u root -p
image.png
- 別的機(jī)器連接報(bào)錯(cuò)
image.png
1130 - Host 'xxx' is not allowed to connect to this MySQL server
解決方式：
myuser使用mypassword從任何主機(jī)連接到mysql服務(wù)器
grant all privileges on . to 'root'@'%' identified by 'Establishedxxx.' with grant option;
如果你想允許用戶(hù)myuser從ip為192.168.1.3的主機(jī)連接到mysql服務(wù)器，并使用mypassword作為密碼
grant all privileges on . to 'root'@'192.168.1.3' identified by 'Establishedxxx.' with grant option;
flush privileges;
