MySQL创建用户及授权

#连接本地MySQL，默认3306端口，root 账号登录
mysql -u root -p

#创建 phpmyadmin 账号，授权最大权限给phpmyadmin
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phpmyadmin';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
#刷新 将用户信息/权限设置从mysql库(MySQL数据库的内置库)中提取到内存里
FLUSH PRIVILEGES;