1.初始密码

??? #?cat /etc/mysql/debian.cnf

?

打印如下

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host???? = localhost
user???? = debian-sys-maint
password = jgOaVkxkgDrOq0uS
socket?? = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host???? = localhost
user???? = debian-sys-maint
password = jgOaVkxkgDrOq0uS
socket?? = /var/run/mysqld/mysqld.sock
basedir? = /usr
??

??? #mysql -udebian-sys-maint -pjgOaVkxkgDrOq0uS

??? #grant all privileges on *.* to root@'localhost(或者远程用%)' identified by '密码' with grant option;

??? #flush privileges;

?

?

2.远程连接

??? #grant all privileges on *.* to root@'%' identified by '密码' with grant option;

??? #sudo vi /etc/mysql/my.cnf
???

bind-address?????????? = 127.0.0.1 这一行要注释掉

#bind-address?????????? = 127.0.0.1

????