Preparar base de datos para Wordpress

Preparar base de datos para Wordpress

Me apunto los pasos sencillos para preparar la base de datos antes de instalar Wordpress.

Primero conectamos al servidor de mediante root y nos solicitará el password:

$ sudo mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 38
Server version: 5.5.46-0+deb7u1 (Debian)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Hasta aquí todo sencillo ahora vamos con los comentados a ejecutar. A tener en cuenta:

  • usuario: wpuser
  • password: wppassword
  • nombre de la base de datos: wordpress
mysql> CREATE DATABASE wordpress;
Query OK, 1 row affected (0.00 sec)
mysql> CREATE USER wpuser@localhost IDENTIFIED BY 'wppassword';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON wordpress.* TO wpuser@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

Se acabó!!!

mysql> exit
Bye