<div class="remark yellow"> <p><b>Disclaimer</b>: Instructions for third-party software or third-party hardware are only intended as rough assistance or guidelines, are at your own risk and are not a substitute for professional assistance from the respective manufacturer. If you have any questions or details, always contact the respective manufacturer directly. </p> </div>
<p> If you get the following error message while adding the user account with phpMyAdmin: </p>
<p>"Your password does not satisfy the current policy requirements", </p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/ea8079ea90156ae174247c73ebf163416e9f5e515aeb250f02f42a2e99558350" alt="Error message when adding the user account">
</p>
<p>then you need to edit the my.cnf file from your MariaDB10 installation and add the following lines: <br> [mysqld]<br> strict_password_validation = OFF<br> synology_password_check = OFF<br>
<p> After editing and saving the file, you must restart the service for the changes to take effect. </p> <h3><b>Step by step instructions </b></h3> <p>1. Log in to your Synology NAS, then open "Control Panel" -> "Terminal & SNMP" and set checkmark next to "Enable SSH service" </p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/769ebb2db7e1add9824d35c4c87ae0dbcfefd32be99c7c1486865923ea27dc8a" alt="Enable SSH">
</p> <p>2. Open the Windows Command Prompt by pressing Windows + R. <br> Then enter "cmd" and click on "OK". (You can also use a tool like PuTTY) </p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/6e592d66b54e2d07db7a9fdadaf0683905aaa0db71322694589092f548ae04ef" alt="Open Windows command prompt"> </p> <p>3. Enter the following line to access your NAS using SSH (Note: these are the user and password credentials from your NAS) <br> ssh Your-Username@Your-IP<br> Example: ssh [email protected] </p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/50f5eb264abdd4052fd48304e53615e2f954ffca3b9dfde67367bc1f748d9b60" alt="Open Windows command prompt"> </p> <p>Confirm the connection with "Yes", then enter your password and press Enter.</p>
<p>4. Get admin rights </p> <p>Once you are in the active terminal, type this command: "sudo -i" and press enter. You will be asked for the password again. </p>
<p>5. Edit my.cnf-file </p> <p>To go to the my.cnf folder and edit the file, enter the following commands in sequence: </p> CD /<br> cd var/packages/MariaDB10/etc<br> vim my.cnf<br>
<p>The following figure should be visible:</p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/67ddb58da44af238ca4d4441af9dcf544884dc43e0d267e427b3047f6a0e2aa2" alt="Open SSH Client"> </p> <p>Now press the letter "i" to go to insert mode. <br> Add these lines <br> [mysqld]<br> strict_password_validation = OFF<br> synology_password_check = OFF<br>
<p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/8f33ddd4f5e16a4056e8221257cbde8874480ae411201601d5d1dbfdc5ec0f0f" alt="Entry in the SSH client"> </p> <p>Now press the ESC key to exit insert mode. <br> Now write the file by typing ":w" and exit by typing ":x" <br> </p> <p> You can now close the terminal.</p>
<p>6. Return to the NAS interface, stop and restart the MariaDB service <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/6034074cf78a4a8173da34045185e61de66146398edd35f7886e7ccff0403cb2" alt="Stop MariaDB service"> </p> <p>Confirm with yes</p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/6a331dfb04c6c13dd83fd7ecbe6c0a35fca632c674440bf733f69bee88c4afa1" alt="Start MariaDB service"> </p>
<p>7. Once the MariaDB service has restarted, you can add the database user using phpMyAdmin </p> <p> <img src="https://api.paperoffice.ai/latest/knowledge/image/15/fc640602f7aaf62ed02068720af3bd2e70653b6d0026f4f765895b9320277d03" alt="Add users with phpmyadmin"> </p>