对刚启动的新实例,尚未设置初始密码,可如下操作:
mysql -S /data/mysqldata/mysql3307/mysql.sock -uroot
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
如果希望外部客户端方便访问:
mysql> grant all privileges on *.* to root@'%' identified by 'password';
mysql> FLUSH PRIVILEGES;