Frequently Asked Questions

The NearlyFreeSpeech.NET FAQ (*)

MySQL (*)

Q. Where can I find more information on properly creating MySQL users?

The official documentation is here:

MariaDB: https://mariadb.com/kb/en/mariadb/create-user/

phpMyAdmin: http://wiki.phpmyadmin.net/pma/user_management

On our system, whatever method you choose needs to boil down to two SQL commands:

Do not specify a hostname when creating users; since we use a clustered hosting network, you cannot predict from what host a connection will originate. Also, attempts to "GRANT ALL ON *.*" will typically fail due to the lack of the FILE permission by default on admin users, and it is bad practice to grant administrative privileges to a website user. Finally, try to avoid granting ALL if you can; security is always enhanced by minimizing the privileges of website users.