MySQL 8.0 password syntax error when creating a replication issue

[scorobo]

Describe the bug

I get error when change user password.

To Reproduce

Steps to reproduce the behavior:

1. Go to Accounts
2. Choose an account
3. Click on Change password
4. Generate new password and click on Forward (Apply)
5. See error - on my Print Screen:

1. Go to Accounts
2. Choose an Account Information
3. Click on Change some information
4. Click forward (apply) om button in area "Create new user ...."
5. Generate new password and click on Forward (Apply)
6. See error - on my Print Screen:

Server configuration

• Operating system: Ubuntu 18.04.1 LTS
• Web server: nginx/1.14.0 (Ubuntu)
• Database version: mysql 8.0.15-6
• PHP version: PHP 7.2.17-0ubuntu0.18.04.1
• phpMyAdmin version: 4.8.5 and 5.0.0-dev (tested on both)

Client configuration

• Browser: Firefox latest
• Operating system: Ubuntu

I found only two errors, but I think, that it is incompatibility of phpmyadmin and mysql 8.
How can I fix it?

[williamdes]

@scorobo can you paste the query here (without the password) ?

[scorobo]

@scorobo can you paste the query here (without the password) ?

1. SET PASSWORD FOR 'username'@'x.x.x.x' = PASSWORD('****************')
2. GRANT USAGE ON . TO 'username'@'x.x.x.x'

P.S.
We upgraded mysql to 8th version and got this errors. After that I installed new versions of PHPMyAdmin. It is very strange, because I logged in PHPMyAdmin with root login. I can create users, clone users. But I got errors on the simple requests, listed above.

[williamdes]

@scorobo Can you try with the next patch version (8.0.16) of MySQL ?

[scorobo]

@scorobo Can you try with the next patch version (8.0.16) of MySQL ?

No, we can't, because it (8.0.15-6) is production server already.

[williamdes]

@scorobo Can you try the latest versions we have available on our website ?

[d2inco]

This issue is still present with PMA 5.0.1 and Mysql 8.0.17

[williamdes]

@d2inco could you please give detailed instructions to reproduce this issue?

[d2inco]

• Build a new lab machine with CentOS 8.0, and upgrade to CentOS 8.1.
• dnf install mysql-server, enable it, start the server.
• run mysql_secure_installation to set root account password.
• Grant access to root on remote box so that I can access via phpmyadmin.
• Log into PhpMyAdmin v.5.0.1, on the remote box.
• Add User Account: 'david', '%', (password), all admin privileges, GO.
  --> This does work.
• Go to replication menu, Add Slave User. "slaveuser", any host, (password):
  --> complete patch for #4279 ctrl + up/down #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY 'password'' at line 1
  --> CREATE USER 'slaveuser'@'%' BY '***';GRANT REPLICATION SLAVE ON . TO 'slaveuser'@'%';

[williamdes]

Thank you so much I will try ASAP

[williamdes]

Thank you for your patience and help
This issue will be fixed in next 5.0 release
Patch: e671ee3