Creating users is routine job generally used everyday. How to memorize those commands is important to for private server administrator, like me :)
MySQL:
create a user name is gamestore and password is ****
1 |
CREATE USER 'gamestore'@'localhost' IDENTIFIED BY '****';
|
Then offer this user special security level to access to assigned database, for example:osc_sea_glenn_2030
1 |
GRANT ALL ON osc_sea_glenn_2030.* TO gamestore@localhost IDENTIFIED '****';
|
if you want to remotely access to mysql database, change above to:
1 |
GRANT ALL ON osc_sea_glenn_2030.* TO gamestore@'%' IDENTIFIED '****';
|
In addition to do that, we have to add or modify the line in "/etc/mysql/my.cnf" to "bind_server: 200.39.29.12", if the server public ip is 200.39.29.12.
Ubuntu(Linux):
That will be pretty simple to add a system user in terminal:
1 |
sudo useradd -d /home/testuser -m testuser |



Content + 1 Column