Skip to main content
Solved

Change Mysql SA username

  • 12 September 2021
  • 5 replies
  • 341 views

Forum|alt.badge.img+2

Hey,
I'm trying to backup a Mysql instance on a linux machine but for some reason I cannot submit the changed username for the backup.

I’ve installed mysql agent on the linux machine but I need to change the SA username as its different from the agent install user.

I’ve gone to Client computers » client name » MySQL » right click on mysql instance » properties » accounts » change » input my username and password » OK.

My issue is that I cant click on the second ‘OK’,its just does nothing.


Thanks in advance

Best answer by Chris Hollis

Thanks @paragon,

I just reviewed the case notes and found the findings/solution was:

  • Going through the MySQL prerequisites, it seems we were missing the "Log Data Directory" that needed to be filled.
  • We filled that in and tried again with the root SA user and it worked this time.

Were you happy with these findings?

I personally think a prompt to inform you that the directory needed to be specified would have been helpful here so I checked internally and was informed the command center console steps https://documentation.commvault.com/11.24/essential/109837_adding_mysql_database_instance.html were much more intuitive and would not have this issue. 

Please let me know what you think.

 

Regards,


Chris


 



 

View original
Did this answer your question?

5 replies

Chris Hollis
Vaulter
Forum|alt.badge.img+15
  • Vaulter
  • 333 replies
  • September 13, 2021

@paragon 

Hope you’re well!

Could you please raise a support incident for this issue? We’ll need to look a little closer into this (e.g. get a copy of your Commserve database) to see if we can reproduce locally etc.

If you could please let me know the support case once done (for tracking) that would be appreciated.

Thanks,

Chris 


Forum|alt.badge.img+2
  • Author
  • Bit
  • 9 replies
  • September 13, 2021
Chris Hollis wrote:

@paragon

Hope you’re well!

Could you please raise a support incident for this issue? We’ll need to look a little closer into this (e.g. get a copy of your Commserve database) to see if we can reproduce locally etc.

If you could please let me know the support case once done (for tracking) that would be appreciated.

Thanks,

Chris 

Hey Chris,
Thank you for your reply
Incident 210913-117


Chris Hollis
Vaulter
Forum|alt.badge.img+15
  • Vaulter
  • 333 replies
  • Answer
  • September 14, 2021

Thanks @paragon,

I just reviewed the case notes and found the findings/solution was:

  • Going through the MySQL prerequisites, it seems we were missing the "Log Data Directory" that needed to be filled.
  • We filled that in and tried again with the root SA user and it worked this time.

Were you happy with these findings?

I personally think a prompt to inform you that the directory needed to be specified would have been helpful here so I checked internally and was informed the command center console steps https://documentation.commvault.com/11.24/essential/109837_adding_mysql_database_instance.html were much more intuitive and would not have this issue. 

Please let me know what you think.

 

Regards,


Chris


 



 


Forum|alt.badge.img
  • Bit
  • 1 reply
  • September 14, 2021

Thank you very much for the help
Very pleased!


Chris Hollis
Vaulter
Forum|alt.badge.img+15
  • Vaulter
  • 333 replies
  • September 14, 2021
simona wrote:

Thank you very much for the help
Very pleased!

No worries, @simona @paragon, could you please mark this as closed (best answer) when ready, thanks. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings