default mysql host for new accounts

backblaze

• October 13, 2015 07:56

where i need to update mysql settings so every new account database user/host will be created with 127.0.0.1?

• 

  Infopro

  • October 13, 2015 13:01

  All databases created are already: localhost

  0
• 

  backblaze

  • October 13, 2015 14:07

  did you read the message??? 127.0.0.1 != localhost unix socket connection and tcpip address... we need it to be 127.0.0.1 select user,host from mysql.user; +------------------+---------------+ | user | host | +------------------+---------------+ | test | 127.0.0.1

  0
• 

  cPanelMichael

  • October 13, 2015 14:33

  Hello :) Could you provide some more details about the specific error message you are receiving with the default configuration? Have you ensured the database user is added to the database via the "MySQL Databases" option in cPanel? Thank you.

  0
• 

  backblaze

  • October 13, 2015 15:22

  my question is pretty simple, not sure why you can not answer...

  0
• 

  cPanelMichael

  • October 13, 2015 15:37

  New my question is pretty simple, not sure why you can not answer...

  
  Hello :) There's no simple configuration value you can change for this setting. Thus, we are simply attempting to understand the issue and offer an alternative solution before advising you to utilize hook action scripts. That being said, if you simply want an answer to the question, then the place to start is at: Guide to Standardized Hooks - Software Development Kit - cPanel Documentation You will need to develop a custom script that configures MySQL how you prefer, and then utilize a hook to automatically run that script each time an account or database is created. Thank you.

  0
• 

  backblaze

  • October 13, 2015 16:35

  looks like this is something you have to include in whm, such a simple task to change and i need to dive into development kit? :/

  0
• 

  Infopro

  • October 13, 2015 16:45

  did you read the message??? 127.0.0.1 != localhost unix socket connection and tcpip address... we need it to be 127.0.0.1 select user,host from mysql.user; +------------------+---------------+ | user | host | +------------------+---------------+ | test | 127.0.0.1

  
  I did. Would you mind mentioning the script name you're (I guess) trying to install thats requiring this setting for database to be 127.0.0.1 instead of localhost? localhost should work fine, if it doesn't for your script I'm curious as to which script that is. TIA.

  0
• 

  backblaze

  • October 13, 2015 21:04

  hm, 4 messages about nothing... what are you talking about??? all im asking if there is any way you can add "hostname" field in "database and database user" creation wizard in cPanel. so i dont have to use mysql shell every time to check it and convert ....

  0
• 

  Infopro

  • October 14, 2015 00:30

  No, there isn't. What are you talking about, I wonder? Why would you need to change this?

  0

Please sign in to leave a comment.