{"id":2637,"date":"2017-12-09T08:37:15","date_gmt":"2017-12-09T08:37:15","guid":{"rendered":"http:\/\/www.scmgalaxy.com\/tutorials\/?p=2637"},"modified":"2020-01-09T07:36:48","modified_gmt":"2020-01-09T07:36:48","slug":"database-query-for-sonar-setup","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/database-query-for-sonar-setup\/","title":{"rendered":"Database query for Sonar setup"},"content":{"rendered":"

rajeshkumar created the topic: database query for Sonar setup<\/strong><\/p>\n

[code language=”css”]
\nCREATE USER ‘sonar123’@’%’ IDENTIFIED BY ‘***’;
\n(Create a User in Mysql DB)
\nGRANT USAGE ON * . * TO ‘sonar123’@’%’ IDENTIFIED BY ‘***’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
\n(Grant Access to user\u201d Sonar123\u201d)
\nCREATE DATABASE IF NOT EXISTS `sonar123` ;<\/p>\n

GRANT ALL PRIVILEGES ON `sonar123` . * TO ‘sonar123’@’%’;
\n[\/code]<\/p>\n

Regards,
\nRajesh Kumar
\nTwitt me @ twitter.com\/RajeshKumarIn<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

rajeshkumar created the topic: database query for Sonar setup [code language=”css”] CREATE USER ‘sonar123’@’%’ IDENTIFIED BY ‘***’; (Create a User in Mysql DB) GRANT USAGE ON * . * TO ‘sonar123’@’%’ IDENTIFIED BY ‘***’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; (Grant Access to user\u201d Sonar123\u201d) CREATE DATABASE IF NOT EXISTS `sonar123`…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[516],"class_list":["post-2637","post","type-post","status-publish","format-standard","hentry","category-uncategorised","tag-sonar"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=2637"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2637\/revisions"}],"predecessor-version":[{"id":2638,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2637\/revisions\/2638"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=2637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=2637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=2637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}