Description of problem: I cannot create a new user using phpMyAdmin no matter which Authentication Plugin or password I use. For example, when I use "Native MySQL authentication" I get the following error: "#1290 - The MariaDB server is running with the --strict-password-validation option so it cannot execute this statement". I don't understand this. Even when I hit "generate [password]" I get this error although the password is fairly complex. Version-Release number of selected component (if applicable): phpMyAdmin: 4.6.3 MariaDB: 10.1.14 Apache: 2.4.20 How reproducible: Make sure you have set a password for the root user of the database (e. g. by using SET PASSWORD=password('new_password'); ) after the installation and make sure you can access phpMyAdmin with your browser (e. g. create a link like this: ln -s /usr/share/phpmyadmin/ /var/www/html/pma). Then open the phpMyAdmin interface in your browser and follow the steps below: 1. Login to your phpMyAdmin installation as root user. 2. Click on: User accounts (4th tab) | Add user account 3. Enter user name and password (or generate a password) 4. Select any Authentication Plugin (e. g. Native MySQL authentication) 5. Click on 'Ok' at the bottom P. S. I've set a password for the root user of the database (using ).
CC: (none) => marja11Assignee: bugsquad => lists.jjorge
Status: NEW => ASSIGNED
This is a bug to report upstream : MariaDB now defaults to reject the way phpmyadmin tries to create users. So please, report it upstream. For now, I suppose you have found how to do it in CLI, or changed MariaDB settings to allow weak passwords. I don't see a good way to better package phpmyadmin against this bug, so I am closing as INVALID.
Status: ASSIGNED => RESOLVEDResolution: (none) => INVALID