# Added to allow websites from /opt/websites For this reason, I create a new configuration file /etc/apache2/conf-available/nf (you can change the file name, of course), with the following content (again you can change the actual directory): Mysql> GRANT PROCESS, SELECT, LOCK TABLES ON *.* TO I will use the same DB dump user for all my databases (websites), I've granted permissions for all the databases ( ON *.*), not only for drupal_db database as I've did previously ( ON drupal_db.*).īy default, Apache serves only websites which reside in /var//opt/websites), so I need to perform some additional configuration. Mysql> CREATE USER IDENTIFIED WITH mysql_native_password BY 'other_strong_password' So we can create this user by executing something like: DB dumps are used not only for backups but also in staging environments to copy the data from one stage to another (from production to test/dev server), meaning that this user should be able to access the DB from other machines, so we should use suffix. I usually create another user that will be used for executing DB dumps. We're granting permissions only to a specific database, so I don't think that granting all privileges is a big deal, but I'll leave the decision to you. Honestly speaking, I usually use the latter option, but many DB admins don't like to see GRANT ALL. Mysql> GRANT ALL PRIVILEGES ON drupal_db.* TO WITH GRANT OPTION Mysql> GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on drupal_db.* TO WITH GRANT OPTION we need to grant permissions on the new database to the new user by executing something like: or you can specify any host by using a wildcard (i.e. Alternatively, you can specify some other specific host (i.e. Some other options are also available, like WITH authentication_plugin and WITH caching_sha2_password (which is the default one, and used if WITH part is omitted completely), but mysql_native_password is probably the best choice for PHP applications, including Drupal.Īlso, note that I've specified the user with suffix It means that the user will access the database from the local machine, of course. Note that here I've used WITH mysql_native_password option, which is a bit older, but still very secure authentication mechanism. Mysql> CREATE USER IDENTIFIED WITH mysql_native_password BY 'some_strong_password' We definitely don't want to use root user to access the database, so we will create a new one by executing something like: Now we can create a new database for the new Drupal site by executing: Note! If you've installed MySQL earlier, not by following this tutorial, and if you've enabled password authentication for the root user, you should enter the shell by executing: $ mysql -u root -p "Remove test database and access to it?" - Yes."Please set the password for root here." - my_super_secure_password."Would you like to setup VALIDATE PASSWORD component?" - No. Here I'll provide my answers only as a reference, but your's may be different, of course: The script will guide you through the configuration by asking several questions that are easy to understand and answer. Let's first update it by executing:įor fresh MySQL installations, it's a good idea to execute the included security script which will change some less secure default options. We will start with the clean Ubuntu 20.04.1 machine. But it will be easy to adapt this procedure for a multi-server environment. Running FindImageDupes afterwards still found 2 duplicate images/gifs that DupeGuru didn’t find.īut DupeGuru offers A) a simple GUI and B) right away the option to delete duplicates (I didn’t find this option with FindImageDupes but I think it’s possible with easy scripting).For websites that don't have a huge amount of visitors I am usually deploying both the database and web server on the same machine, and this is what I will do here. Then I tried DupeGuru and it even detected my GIF duplicate files right away. I tried installing Py-Image-Dedup but the whole thing with elasticsearch backed feels above my skill (and the installation from pypi also failed). Py-Image-Dedup is Build up on the Image-Match library that compares pHash‘s.ĭoes DupeGuru use a simper detection algorithm for images? public IP addresses or hostnames, account numbers, email addresses) before posting!ĭoes this sidebar need an addition or correction? Tell me here Note: ensure to redact or obfuscate all confidential or identifying information (eg. If you fix the problem yourself, please post your solution, so that others can also learn. ✻ Smokey says: suggest green changes to the products of big companies on their Twitter to fight climate change! If you're posting for help, please include the following details, so that we can help you more efficiently: Any distro, any platform! Explicitly noob-friendly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |