{"action":"created","issue":{"url":"https://api.github.com/repos/tencent-wechat/phxsql/issues/34","repository_url":"https://api.github.com/repos/tencent-wechat/phxsql","labels_url":"https://api.github.com/repos/tencent-wechat/phxsql/issues/34/labels{/name}","comments_url":"https://api.github.com/repos/tencent-wechat/phxsql/issues/34/comments","events_url":"https://api.github.com/repos/tencent-wechat/phxsql/issues/34/events","html_url":"https://github.com/tencent-wechat/phxsql/issues/34","id":178260617,"number":34,"title":"phxbinlogsvr_tools设置管理员密码问题","user":{"login":"coding-chenkaikai","id":19203057,"avatar_url":"https://avatars.githubusercontent.com/u/19203057?v=3","gravatar_id":"","url":"https://api.github.com/users/coding-chenkaikai","html_url":"https://github.com/coding-chenkaikai","followers_url":"https://api.github.com/users/coding-chenkaikai/followers","following_url":"https://api.github.com/users/coding-chenkaikai/following{/other_user}","gists_url":"https://api.github.com/users/coding-chenkaikai/gists{/gist_id}","starred_url":"https://api.github.com/users/coding-chenkaikai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coding-chenkaikai/subscriptions","organizations_url":"https://api.github.com/users/coding-chenkaikai/orgs","repos_url":"https://api.github.com/users/coding-chenkaikai/repos","events_url":"https://api.github.com/users/coding-chenkaikai/events{/privacy}","received_events_url":"https://api.github.com/users/coding-chenkaikai/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-09-21T06:45:05Z","updated_at":"2016-10-09T06:35:09Z","closed_at":null,"body":"通过phxbinlogsvr_tools设置mysql非root管理员及密码，使用命令如下：\r\n`phxbinlogsvr_tools -f SetMySqlAdminInfo -h <host> -p <port> -u <admin username> -d <admin pwd> -U <new admin username> -D <new admin pwd>`\r\n1、通过phxsql集群中主机登陆mysql，非root用户，密码正常，登陆成功\r\n2、通过phxsql集群外主机登陆mysql，非root用户，提示密码不正确，经测试密码为空\r\n3、想通过phxsql集群外主机登陆mysql，使用root登陆，发现没有权限，通过查看mysql权限表，没有给root分配其他主机访问的权限？\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/tencent-wechat/phxsql/issues/comments/252468120","html_url":"https://github.com/tencent-wechat/phxsql/issues/34#issuecomment-252468120","issue_url":"https://api.github.com/repos/tencent-wechat/phxsql/issues/34","id":252468120,"user":{"login":"coding-chenkaikai","id":19203057,"avatar_url":"https://avatars.githubusercontent.com/u/19203057?v=3","gravatar_id":"","url":"https://api.github.com/users/coding-chenkaikai","html_url":"https://github.com/coding-chenkaikai","followers_url":"https://api.github.com/users/coding-chenkaikai/followers","following_url":"https://api.github.com/users/coding-chenkaikai/following{/other_user}","gists_url":"https://api.github.com/users/coding-chenkaikai/gists{/gist_id}","starred_url":"https://api.github.com/users/coding-chenkaikai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coding-chenkaikai/subscriptions","organizations_url":"https://api.github.com/users/coding-chenkaikai/orgs","repos_url":"https://api.github.com/users/coding-chenkaikai/repos","events_url":"https://api.github.com/users/coding-chenkaikai/events{/privacy}","received_events_url":"https://api.github.com/users/coding-chenkaikai/received_events","type":"User","site_admin":false},"created_at":"2016-10-09T06:35:08Z","updated_at":"2016-10-09T06:35:08Z","body":"我使用最新代码进行编译，设置sqlproxy的端口为19521，集群中主机通过读写端口可以连接上mysql server，但是通过只读端口19522只能连接上master，其余集群内主机均连接不上，我又通过脚本创建管理员用户，出现同样的问题\r\n集群所有主机MasterEnableReadPort = 1，同样提示如下：\r\n```\r\n[root@ip3 phxsql]# mysql -uroot -P19522 -h\"ip3\"\r\nERROR 1045 (28000): Access denied for user 'root'@'ip3' (using password: NO)\r\n[root@ip3 phxsql]# \r\n[root@ip3 phxsql]# mysql -uroot -P19522 -h\"ip2\"\r\nERROR 1045 (28000): Access denied for user 'root'@'ip2' (using password: NO)\r\n[root@ip3 phxsql]# \r\n[root@ip3 phxsql]# mysql -uroot -P19522 -h\"ip1\"\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\n```"}}
{"actor":{"display_login":"coding-chenkaikai"}}