Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Create a new user restricted to localhost CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'StrongP@ssw0rd!'; -- Create a user that can connect from any host (less secure) CREATE USER 'report_user'@'%' IDENTIFIED BY 'AnotherStr0ng!'; -- Change a user's password ALTER USER 'app_user'@'localhost' IDENTIFIED BY 'NewP@ssword2025'; -- Remove a user DROP USER IF EXISTS 'old_user'@'localhost';
Result
Open