1.修改用户初始密码
执行 cd /usr/local/mysql/bin
执行 sudo su
执行./mysqld_safe --skip-grant-tables &
执行 ./mysql
后出现mysql>
执行 flush privileges;
执行 alter user 'root'@'localhost' identified by 'newpassword';
2.新增用户
执行 cd /usr/local/mysql/bin
执行 sudo su
执行./mysqld_safe --skip-grant-tables &
执行 ./mysql
后出现mysql>
执行 flush privileges;
执行CREATE USER
newuser@
localhost` IDENTIFIED WITH caching_sha2_password BY ‘newuserpasssword’;
执行分配权限:
GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create User, Create View, Delete, Drop, Event, Execute, File, Grant Option, Index, Insert, Lock Tables, Process, References, Reload, Replication Client, Replication Slave, Select, Show Databases, Show View, Shutdown, Super, Trigger, Update ON *.* TO
newuser@
localhost;
分号都需要输入