{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11520","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11520/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11520/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11520/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11520","id":109107405,"number":11520,"title":"Incorrect syntax creating an user using mysql_native_password with MariaDB","user":{"login":"hurrycaner","id":2671143,"avatar_url":"https://avatars.githubusercontent.com/u/2671143?v=3","gravatar_id":"","url":"https://api.github.com/users/hurrycaner","html_url":"https://github.com/hurrycaner","followers_url":"https://api.github.com/users/hurrycaner/followers","following_url":"https://api.github.com/users/hurrycaner/following{/other_user}","gists_url":"https://api.github.com/users/hurrycaner/gists{/gist_id}","starred_url":"https://api.github.com/users/hurrycaner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hurrycaner/subscriptions","organizations_url":"https://api.github.com/users/hurrycaner/orgs","repos_url":"https://api.github.com/users/hurrycaner/repos","events_url":"https://api.github.com/users/hurrycaner/events{/privacy}","received_events_url":"https://api.github.com/users/hurrycaner/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-09-30T14:46:41Z","updated_at":"2015-10-01T17:04:27Z","closed_at":null,"body":"According to MariaDB docs (https://mariadb.com/kb/en/mariadb/development-pluggable-authentication/), the correct syntax to create an user with mysql_native_password plugin is:\r\n```\r\nCREATE USER asd IDENTIFIED VIA mysql_native_password USING '***';\r\n```\r\nAnd today phpMyAdmin 4.5.0.2 is using this syntax:\r\n```\r\nCREATE USER 'asd'@'%' IDENTIFIED WITH mysql_native_password BY '***';\r\n```\r\n\r\nThis is generating errors \"1065 - Query was empty\" error above the printed query and \"The selected user was not found in the privilege table.\" right on top of the user creation wizard.\r\n\r\nI was able to create the user directly in SQL Query with the syntax pointed at MariaDB docs. (got password hash using `select PASSWORD('test');`).\r\n\r\nVersions:\r\nphpMyAdmin 4.5.0.2\r\nMariaDB 10.0.20-MariaDB"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/144787657","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11520#issuecomment-144787657","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11520","id":144787657,"user":{"login":"devenbansod","id":5762808,"avatar_url":"https://avatars.githubusercontent.com/u/5762808?v=3","gravatar_id":"","url":"https://api.github.com/users/devenbansod","html_url":"https://github.com/devenbansod","followers_url":"https://api.github.com/users/devenbansod/followers","following_url":"https://api.github.com/users/devenbansod/following{/other_user}","gists_url":"https://api.github.com/users/devenbansod/gists{/gist_id}","starred_url":"https://api.github.com/users/devenbansod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devenbansod/subscriptions","organizations_url":"https://api.github.com/users/devenbansod/orgs","repos_url":"https://api.github.com/users/devenbansod/repos","events_url":"https://api.github.com/users/devenbansod/events{/privacy}","received_events_url":"https://api.github.com/users/devenbansod/received_events","type":"User","site_admin":false},"created_at":"2015-10-01T17:04:27Z","updated_at":"2015-10-01T17:04:27Z","body":"Please see : #11525 "}}