MYSQL创建用户并指定权限

CREATE USER 'stock'@'%' IDENTIFIED WITH mysql_native_password AS 'stock@123';




GRANT USAGE ON *.* TO 'stock'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;


GRANT ALL PRIVILEGES ON `stock`.* TO 'stock'@'%';