Wordpress tips

Instalar:

sudo apt-get install apache2
sudo apt-get install php
sudo apt-get install php-mysql php-curl php-gd phpzip
sudo apt-get install mysql-server
sudo apt-get install git

Cambiar password database

sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';

Create ''/var/www/html/php.info'' con el texto:

<?php phpinfo(); ?>

Cambio de contraseña root

mysql -u root -p

Para entrar como root a mysql usando: 'sudo mysql'

ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;

Usuarios

CREATE USER '<your-user-name>'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON *.* TO '<your-user-name>'@'localhost';
create database wpdb;
FLUSH PRIVILEGES;

Descargar e instalar:

wget <url-for-download/filename>.tar.gz
tar xvfz <downloaded-file-name>.tar.gz
cp -R /home/<your-username>/tmp/wordpress/* /var/www/html
mv index.html index.html.bk
mv wp-config-sample.php wp-config.php
vi wp-config.php   # Actualizar valores

Abrir http://public-ip/wp-admin/install.php
Abrir http://public-ip