new kich at the cat
Posted: Sat Aug 06, 2016 7:53 am
Config files have changed with Ubuntu 16.04 which made it harder than necessary to operate a web appliance.
https://hardcoregames.azurewebsites.net/?p=29892
I have a draft for another document on bolting on storage, but I am now going to use the basic A0 box to attempt to get a MySQL server up and on the internet so I can use that
I run 2 sites, so I installed the local console in addition to the server, this way I can manually make SQL commands
Now that I can log in, the permissions are needed for each site, one is obvious my gaming site, the other is my vegan site
now for security, I think permissions should be restricted to *azurewebsites.net on principle so that hacker and spammers cannot attack my server as easily?
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%.example.com' IDENTIFIED BY 'some_characters' WITH GRANT OPTION; FLUSH PRIVILEGES;
is obviously not what I want, I wanted to have specific user/password for each site, I may up a new site or 2 over time
but the idea I want is a new database with user and password, and if possible hard coded to the URL of the web site so that its secure as possible?
what I was thinking is
GRANT ALL PRIVILEGES ON *.* TO 'siteuser'@'%.azurewebsites.net' IDENTIFIED BY 'secure password' WITH GRANT OPTION; FLUSH PRIVILEGES;
so how can i manually add a user to the database?
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
is main idea, but I want to generate secure passwords for the sites so that hackers cannot spam my site etc
keep in mind all database uses are remote in the cloud but locatable by URL
https://hardcoregames.azurewebsites.net/?p=29892
I have a draft for another document on bolting on storage, but I am now going to use the basic A0 box to attempt to get a MySQL server up and on the internet so I can use that
I run 2 sites, so I installed the local console in addition to the server, this way I can manually make SQL commands
Now that I can log in, the permissions are needed for each site, one is obvious my gaming site, the other is my vegan site
now for security, I think permissions should be restricted to *azurewebsites.net on principle so that hacker and spammers cannot attack my server as easily?
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%.example.com' IDENTIFIED BY 'some_characters' WITH GRANT OPTION; FLUSH PRIVILEGES;
is obviously not what I want, I wanted to have specific user/password for each site, I may up a new site or 2 over time
but the idea I want is a new database with user and password, and if possible hard coded to the URL of the web site so that its secure as possible?
what I was thinking is
GRANT ALL PRIVILEGES ON *.* TO 'siteuser'@'%.azurewebsites.net' IDENTIFIED BY 'secure password' WITH GRANT OPTION; FLUSH PRIVILEGES;
so how can i manually add a user to the database?
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
is main idea, but I want to generate secure passwords for the sites so that hackers cannot spam my site etc
keep in mind all database uses are remote in the cloud but locatable by URL