Scribd
Upload
6 views1 page

MySQL User Creation and Privileges

The document creates a MySQL user account with full privileges, updates the authentication and host IP addresses for the root user, and creates a superadmin user account with full privileges.

Uploaded by

Azein Rajib
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views1 page

MySQL User Creation and Privileges

The document creates a MySQL user account with full privileges, updates the authentication and host IP addresses for the root user, and creates a superadmin user account with full privileges.

Uploaded by

Azein Rajib
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

CREATE USER 'root'@'172.

% 'IDENTIFIED BY
'*BF4DE39506F4FAAF47C95CCE0C0146F2EA2B98FE';
GRANT ALL PRIVILEGES ON *.* TO 'root'@172.%' WITH GRANT OPTION;
UPDATE [Link] SET authentication_string=PASSWORD('password') WHERE User='root';
UPDATE [Link] SET host='112.%' WHERE host='172.%';
UPDATE [Link] SET host='172.%' WHERE host='10.%';
GRANT ALL PRIVILEGES ON *.* TO 'superadmin'@'localhost' IDENTIFIED BY 'superadmin'
WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'superadmin'@'localhost' WITH GRANT OPTION;
CREATE USER 'superadmin'@'172.%' IDENTIFIED BY 'superadmin' WITH GRANT OPTION;

You might also like