一 用户管理 1.1 创建新用户 CREATE USER username@'主机' IDENTIFIED BY 'password'; docker用户权限、username@'localhost' 用户只能从本地主机进行连接 username@'192.168.199.101' 用户可以从主机192.168.199.101进行连接 u
安装MySQL 通过Homebrew安装,执行brew install mysql即可。 MySQL数据库修改密码,安装完成后会显示Caveats警告,如下所示: We've installed your MySQL database without a root password. To secure it run:mysql_secure_installationMySQL is con
-- 服务器级别的权限selecta.GRANTEE,GROUP_CONCAT(a.PRIVILEGE_TYPE),concat("grant",GROUP_CONCAT(a.PRIVILEGE_TYPE),"ON*.*to",a.GRANTEE)fromUSER_PRIVILEGESaGROUPBYGRANTEE;mysql 添加用户。-- db 级别的权限selectGRANTEE,TABLE_SCHEMA,GROUP_CONCAT(
查看MYSQL数据库中所有用户mysql>SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;+---------------------------------------+| query |+--------------