{"action":"created","issue":{"url":"https://api.github.com/repos/major/MySQLTuner-perl/issues/268","repository_url":"https://api.github.com/repos/major/MySQLTuner-perl","labels_url":"https://api.github.com/repos/major/MySQLTuner-perl/issues/268/labels{/name}","comments_url":"https://api.github.com/repos/major/MySQLTuner-perl/issues/268/comments","events_url":"https://api.github.com/repos/major/MySQLTuner-perl/issues/268/events","html_url":"https://github.com/major/MySQLTuner-perl/issues/268","id":188348108,"number":268,"title":"User 'user_name@localhost' has no password set.","user":{"login":"karek314","id":9548618,"avatar_url":"https://avatars.githubusercontent.com/u/9548618?v=3","gravatar_id":"","url":"https://api.github.com/users/karek314","html_url":"https://github.com/karek314","followers_url":"https://api.github.com/users/karek314/followers","following_url":"https://api.github.com/users/karek314/following{/other_user}","gists_url":"https://api.github.com/users/karek314/gists{/gist_id}","starred_url":"https://api.github.com/users/karek314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karek314/subscriptions","organizations_url":"https://api.github.com/users/karek314/orgs","repos_url":"https://api.github.com/users/karek314/repos","events_url":"https://api.github.com/users/karek314/events{/privacy}","received_events_url":"https://api.github.com/users/karek314/received_events","type":"User","site_admin":false},"labels":[{"id":154179319,"url":"https://api.github.com/repos/major/MySQLTuner-perl/labels/bug","name":"bug","color":"e11d21","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-11-09T20:45:39Z","updated_at":"2016-11-12T22:08:57Z","closed_at":null,"body":"Latest version from mysqltuner.com\r\n\r\n`User 'user_name@localhost' has no password set.`\r\n\r\nGives this warning even when there IS password set, it happens after i have updated password for this user."},"comment":{"url":"https://api.github.com/repos/major/MySQLTuner-perl/issues/comments/260151721","html_url":"https://github.com/major/MySQLTuner-perl/issues/268#issuecomment-260151721","issue_url":"https://api.github.com/repos/major/MySQLTuner-perl/issues/268","id":260151721,"user":{"login":"karek314","id":9548618,"avatar_url":"https://avatars.githubusercontent.com/u/9548618?v=3","gravatar_id":"","url":"https://api.github.com/users/karek314","html_url":"https://github.com/karek314","followers_url":"https://api.github.com/users/karek314/followers","following_url":"https://api.github.com/users/karek314/following{/other_user}","gists_url":"https://api.github.com/users/karek314/gists{/gist_id}","starred_url":"https://api.github.com/users/karek314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karek314/subscriptions","organizations_url":"https://api.github.com/users/karek314/orgs","repos_url":"https://api.github.com/users/karek314/repos","events_url":"https://api.github.com/users/karek314/events{/privacy}","received_events_url":"https://api.github.com/users/karek314/received_events","type":"User","site_admin":false},"created_at":"2016-11-12T22:08:57Z","updated_at":"2016-11-12T22:08:57Z","body":"It shows the same users which has been displayed in mysqltuner output.\r\n\r\nBut\r\n`Select user, host from mysql.user where Password is NULL;` - Gives empty result\r\n\r\nand\r\n\r\n`Select user, host from mysql.user where Password = '';` - Display those users mentioned before\r\n\r\nWhich is more interesting\r\n`SELECT * FROM `user``\r\nShows that those users passwords are empty, but in fact i can not access databases with those users without providing correct password. Obviously password is set but not sure why `SELECT` returns wrong result. I have tried manually changing passwords via command line as well with phpmyadmin.\r\n\r\n```\r\nServer version: 10.0.28-MariaDB-1~trusty - mariadb.org binary distribution\r\nPhpmyadmin Version information: 4.5.4.1deb2ubuntu2\r\n```"}}
{"actor":{"display_login":"karek314"}}