MySQL 终端:登录、用户和权限
原文英文,约600词,阅读约需3分钟。发表于: 。Access MySQL sudo mysql -u root -p The sudo mysql -u root -p command is used to access MySQL as the root user with administrative privileges. After running the command, you will be prompted...
使用 `sudo mysql -u root -p` 以管理员权限访问 MySQL。创建用户:`CREATE USER '用户名'@'localhost' IDENTIFIED BY '密码';`。授予权限:`GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@'localhost';`。更新权限:`FLUSH PRIVILEGES;`。查看权限:`SHOW GRANTS FOR '用户名'@'localhost';`。撤销权限:`REVOKE ALL PRIVILEGES ON 数据库名.* FROM '用户名'@'localhost';`。查询用户列表:`SELECT User, Host FROM mysql.user;`。查看当前用户:`SELECT USER();`。