Add User for Database form shell

sudonic

• September 25, 2013 23:50

Hi, I need to create a database more than 200. i create shell script and using this code : in mysql : create database USERNAME_dbname; GRANT ALL PRIVILEGES ON USERNAME_dbname.* TO 'USERNAME_dbuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
and user dbmaptool : /usr/local/cpanel/bin/dbmaptool USERNAME --type mysql --dbs USERNAME_dbname' && /usr/local/cpanel/bin/dbmaptool USERNAME --type mysql --dbusers 'USERNAME_dbuser'
everything ok to this section, but in cPanel user don't added to database. i have read this :

• 

  cPanelMichael

  • September 26, 2013 18:06

  Hello :) Do you experience the same problem when adding a user to a database via "WHM Home " SQL Services " Database Map Tool"? Thank you.

  0
• 

  sudonic

  • September 28, 2013 06:24

  [quote="cPanelMichael, post: 1470282">Hello :) Do you experience the same problem when adding a user to a database via "WHM Home " SQL Services " Database Map Tool"? Thank you.
  Yes, i tested this option, but can't help me, i need this problem solved without WHM GUI, because i have many database and i can't create DB & user & add user to DB & import SQL file in DB manually.

  0
• 

  cPanelMichael

  • October 02, 2013 15:47

  Feel free to open a support ticket so we can take a closer look: Submit A Ticket You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0

Please sign in to leave a comment.