Welcome, Guest
Username Password: Remember me
  • Page:
  • 1

TOPIC: database query for Sonar setup

database query for Sonar setup 1 year, 7 months ago #363

  • rajeshkumar
  • OFFLINE
  • Moderator
  • I love software configuration management
  • Posts: 370
  • Points: 44591
  • Karma: 4
  • Honor Medal 2009
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'@'%';
Regards,
Rajesh Kumar
Build and Release Engineer
My Blog: community.scmgalaxy.com/pg/profile/rajeshkumar
  • Page:
  • 1
Time to create page: 0.46 seconds

     
    
Home Forum