{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11500","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11500/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11500/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11500/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11500","id":108322007,"number":11500,"title":"Error when creating new user","user":{"login":"Moowalker","id":14836857,"avatar_url":"https://avatars.githubusercontent.com/u/14836857?v=3","gravatar_id":"","url":"https://api.github.com/users/Moowalker","html_url":"https://github.com/Moowalker","followers_url":"https://api.github.com/users/Moowalker/followers","following_url":"https://api.github.com/users/Moowalker/following{/other_user}","gists_url":"https://api.github.com/users/Moowalker/gists{/gist_id}","starred_url":"https://api.github.com/users/Moowalker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Moowalker/subscriptions","organizations_url":"https://api.github.com/users/Moowalker/orgs","repos_url":"https://api.github.com/users/Moowalker/repos","events_url":"https://api.github.com/users/Moowalker/events{/privacy}","received_events_url":"https://api.github.com/users/Moowalker/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-25T13:01:14Z","updated_at":"2015-09-25T14:21:34Z","closed_at":null,"body":"Hello,\r\n\r\nWhen trying to create a new user (User accounts -> Add user account) I get the following errors\r\n\r\n```\r\n#1065 - Query was empty\r\n```\r\n\r\nand then\r\n\r\n```\r\nThe selected user was not found in the privilege table.\r\n```\r\n\r\nRunning the following query generated my phpmyadmin\r\n\r\n```\r\nCREATE USER 'test_user'@'localhost' IDENTIFIED WITH mysql_native_password BY '***';GRANT ALL PRIVILEGES ON *.* TO 'test_user'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;\r\n```\r\n\r\ngets the following error\r\n\r\n```\r\nError\r\nStatic analysis:\r\n\r\n1 errors were found during analysis.\r\n\r\nUnrecognized statement type. (near \"WITH\" at position 47)\r\nSQL query:\r\n\r\nCREATE USER 'test_user'@'localhost' IDENTIFIED WITH mysql_native_password BY '***'\r\n\r\nMySQL said: Documentation\r\n\r\n#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY '***'' at line 1\r\n```\r\n\r\nIf I remove *WITH mysql_native_password* from the query, they query is executed fine.\r\n\r\nVersions: CentOS release 6.7 (Final)\r\nApache: Apache/2.2.15\r\nPHP: PHP 5.5.29\r\nPHP extension: mysqli\r\nDatabase: 10.0.21-MariaDB-log MariaDB Server\r\nDatabase client version: libmysql \r\n"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/143236777","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11500#issuecomment-143236777","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11500","id":143236777,"user":{"login":"holyfive","id":2778172,"avatar_url":"https://avatars.githubusercontent.com/u/2778172?v=3","gravatar_id":"","url":"https://api.github.com/users/holyfive","html_url":"https://github.com/holyfive","followers_url":"https://api.github.com/users/holyfive/followers","following_url":"https://api.github.com/users/holyfive/following{/other_user}","gists_url":"https://api.github.com/users/holyfive/gists{/gist_id}","starred_url":"https://api.github.com/users/holyfive/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/holyfive/subscriptions","organizations_url":"https://api.github.com/users/holyfive/orgs","repos_url":"https://api.github.com/users/holyfive/repos","events_url":"https://api.github.com/users/holyfive/events{/privacy}","received_events_url":"https://api.github.com/users/holyfive/received_events","type":"User","site_admin":false},"created_at":"2015-09-25T14:21:33Z","updated_at":"2015-09-25T14:21:33Z","body":"Same thing here. Perhaps it is an issue regarding the interaction with MariaDB? We are also using 10.0.21 on CentOS 6."}}