creacion de usuarios en mysql

create_user

--Se crea el usuario
CREATE USER t3mp0r4lp57@localhost IDENTIFIED BY ‘############’;
--Se define limite consultas
GRANT USAGE ON *.* TO t3mp0r4lp57@localhost IDENTIFIED BY ‘############’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
--Se crea una base de datos [opcional]
CREATE DATABASE IF NOT EXISTS t3mp0r4lp57;
--Se otorgan privilegios sobre la base
GRANT ALL PRIVILEGES ON t3mp0r4lp57.* TO t3mp0r4lp57@localhost;