nginx putty commands

Putty -

su root (switches user to root)

have to put a semi-col after each command so that it recognizes it ;

service php-fpm restart;  (restarts any new php-fpm docs or edits)

service nginx restart;      (restarts nginx)

mysql;  (opens mysql)

create database typedatabasename;  (replace type databasename with your own database name - creates a new database)

grant all privileges on typedatabasename.* to 'typeusername'@'localhost' identified by "typepassword";   (creates a username and password for the named database)

flush privileges; (restarts mysql)

exit (quits mysql)

chown -R default.co.uk:default.co.uk /var/www/vhosts/default.co.uk (changes ownership of the route listed in the command)


If on the magneto installation wizard under the configuration tab you get: Database connection error. as a message use the following command:
grant all privileges on yourdatabasename.* to 'yourusername'@'localhost' identified by "yourpassword";
if the local host part hasnt been picked up it wont work.