Database query for Sonar setup

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” Sonar123”)
CREATE DATABASE IF NOT EXISTS `sonar123` ;

GRANT ALL PRIVILEGES ON `sonar123` . * TO ‘sonar123’@’%’;
[/code]

Regards,
Rajesh Kumar
Twitt me @ twitter.com/RajeshKumarIn

• Author
• Recent Posts

Follow me

Rajesh Kumar

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Software AG

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• Best AI tools for Software Engineers - November 4, 2024
• Installing Jupyter: Get up and running on your computer - November 2, 2024
• An Introduction of SymOps by SymOps.com - October 30, 2024