* Apache with mod-rewrite enabled and "Options All" so you can use a local `.htaccess` file
* PHP 7.3+ (PHP8 is not fully supported yet)
* PHP *command line* access with register_argc_argv set to true in the php.ini file
- * Curl, GD, PDO, mbstrings, MySQLi, hash, xml, zip and OpenSSL extensions
+ * Curl, GD, GMP, PDO, mbstrings, MySQLi, hash, xml, zip and OpenSSL extensions
* The POSIX module of PHP needs to be activated (e.g. [RHEL, CentOS](http://www.bigsoft.co.uk/blog/index.php/2014/12/08/posix-php-commands-not-working-under-centos-7) have disabled it)
* Some form of email server or email gateway such that PHP mail() works.
If you cannot set up your own email server, you can use the [phpmailer](https://github.com/friendica/friendica-addons/tree/develop/phpmailer) addon and use a remote SMTP server.
### Create a database
-Create an empty database and note the access details (hostname, username, password, database name).
+Create an empty database and note the access details (hostname, username, password, database name).
+Generate a strong password, then enter mysql with:
+
+ mysql
+
+Then use the following script using the password you just generated:
+
+ CREATE DATABASE friendicadb;
+ CREATE USER 'friendica'@'localhost' IDENTIFIED BY '<<your mysql password here>>';
+ GRANT ALL ON friendicadb.* TO 'friendica'@'localhost';
+ FLUSH PRIVILEGES;
+ EXIT;
Friendica needs the permission to create and delete fields and tables in its own database.