mysql create user

mysql create user


CREATE USER 'db_user'@'%' IDENTIFIED BY 'db_password';
GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'%';

OR:

grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';

Leave a Reply

Your email address will not be published. Required fields are marked *