使用root登录

mysql -h 127.0.0.1 -u root -p

创建数据库

CREATE DATABASE mydatabase;

创建一个新的用户

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

将用户与数据库关联

GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';

刷新权限

FLUSH PRIVILEGES;