# Create user
CREATE USER user IDENTIFIED BY 'password';
# Create and user (if doesn´t exist) and grant permissions
GRANT ALL ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password';
# Update
UPDATE [table] SET [table_field]=[new_value] WHERE [id]=[id];
# Change user password
SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass');
CREATE USER user IDENTIFIED BY 'password';
# Create and user (if doesn´t exist) and grant permissions
GRANT ALL ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password';
# Update
UPDATE [table] SET [table_field]=[new_value] WHERE [id]=[id];
# Change user password
SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass');
No comments:
Post a Comment