2020-04-16 17:08:35 来源：admin 点击：822
操作步骤
1.通过以下命令匿名登录mariadbmysqld_safe --skip-grant-tables &
2.匿名登录后输入如下命令
使用mysql系统数据库user mysql;
插入一个名为test的新用帐号为test，密码为123，可根据自身需要自行修改insert into user(Host,User,Password) values('%','test',PASSWORD('123'));
将root密码改为123，作为重置root密码之用Update user set Password=PASSWORD('123') where User='root'
查看用户是否加入select * from user;
3.赋予创建用户所有权限
先输入命令flush privileges;
之后再输入命令grant all privileges on *.* to test@localhost identified by '123';
INSERT INTO `mysql`.`user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`) VALUES ('%', 'root', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', '0', '0', '0', '0', '', '');