Cacher is the code snippet organizer for pro developers

ssh -p 22 root@142.X.X.X
password

mysql -p
root_db_pasword
create database database_name;
grant all privileges on database_name.* to 'database_user'@'localhost' identified by "database_user_password";
flush privileges;
exit;


CREATE USER 'memberfituser'@'%' IDENTIFIED WITH mysql_native_password BY '***';
GRANT ALL PRIVILEGES ON *.* TO 'memberfituser'@'%' WITH GRANT OPTION;
ALTER USER 'memberfituser'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT ALL PRIVILEGES ON `memberfit`.* TO 'memberfituser'@'%';

CREATE USER 'memberfituser'@'192.168.112.4' IDENTIFIED WITH mysql_native_password BY 'memberfit123';
GRANT ALL PRIVILEGES ON *.* TO 'memberfituser'@'192.168.112.4' WITH GRANT OPTION;
ALTER USER 'memberfituser'@'192.168.112.4' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT ALL PRIVILEGES ON `memberfit`.* TO 'memberfituser'@'192.168.112.4';