创建除root外的超级用户
CREATE USER 'lbin'@'localhost' IDENTIFIED BY '12qwaszx';
GRANT ALL PRIVILEGES ON *.* TO 'lbin'@'localhost' WITH GRANT OPTION;
CREATE USER 'lbin'@'%' IDENTIFIED BY '12qwaszx';
GRANT ALL PRIVILEGES ON *.* TO 'lbin'@'%' WITH GRANT OPTION;
修改my.ini中的bind-address
ubuntu
如果需要远程能够访问mysql,需要将127.0.0.1为0.0.0.0
mysql中的配置文件位于/etc/mysql/my.cnf
centos
如果是centos,则无需配置bind-address