Rectangle 27 0

Step 4 Add a Dedicated Diaspora User

Create a user account to run Diaspora. You can name this account whatever you like, but this tutorial will assume that this user is called diaspora.

sudo useradd diaspora
Applications Ruby on Rails Ruby Nginx MariaDB CentOS
Rectangle 27 0

Step 7 Create Diaspora User and Database

Next we will log in to MariaDB to create the diaspora user. When prompted, enter the root password you created above:

mysql -u root -p

Create a user for Diaspora. Change password in the command below to a real password. This should not be the same as the root password you provided during mysql_secure_installation.

CREATE USER 'diaspora'@'localhost' IDENTIFIED BY 'password';

Create the Diaspora production database:


Grant the MariaDB diaspora user the necessary permissions on the database:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `diaspora_production`.* TO 'diaspora'@'localhost';

Quit the database session.

Try connecting to the new database with the user diaspora (use the password you entered for IDENTIFIED BY 'password' above).

mysql -u diaspora -p -D diaspora_production

You should now see the prompt: MariaDB [diaspora_production]>. Quit the database session by entering:


We are now done installing the MariaDB database.

Next we'll grab the Diaspora source code and get it configured to run on your VPS.

Applications Ruby on Rails Ruby Nginx MariaDB CentOS
Rectangle 27 0

Step 20 Create Diaspora User

Let's create your first Diaspora user. Click the link in Start by creating an account.

Fill in the details to create a new Diaspora user. Then, you should be able to view your user's home page and start using the Diaspora social network.

Applications Ruby on Rails Ruby Nginx MariaDB CentOS