$sudo su # 进入root账户 # mysql # 输入mysql,进入mysql服务 ;root账户下分隔符是#,普通用户是$
mysql> select user, plugin from mysql.user; +------------------+-----------------------+ | user | plugin | +------------------+-----------------------+ | root | auth_socket | | mysql.session | mysql_native_password | | mysql.sys | mysql_native_password | | debian-sys-maint | mysql_native_password | +------------------+-----------------------+ 4 rows in set (0.00 sec) mysql> update mysql.user set authentication_string=PASSWORD('renrenren'), plugin='mysql_native_password' where user='root'; # 修改root账户密码 mysql> flush privileges; # 刷新权限 mysql> exit # 退出msyql服务 Bye # exit # 退出root账户,进入普通账户(第一个星号不是注释) $ sudo /etc/init.d/mysql restart # 重启msyql服务 $ mysql -uroot -p # 进入mysql服务中,接下来输入上面步骤中设置的密码 Enter password: (上面的密码)
3.4 配置远程登录
默认的MySQL服务是只允许本地服务的,但是大部分时候需要远程服务,下面进行配置:
$sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf # 进入配置文件,注释掉bind-address = 127.0.0.1
保存退出,进入MySQL服务,执行授权命令:
$sudo -uroot -p Enter password: (上面的密码) mysql> grant all on *.* to root@'%' identified by 'renrenren' with grant option; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql>flush privileges; mysql> exit Bye