Musial had been in poor health for several years and Herzog remembered a conversation at the funeral of Musial's wife, Lillian, last May in which Musial indicated he was ready for the end of his life.
"I always wanted to live to be 100," Herzog recalled Musial saying, "but I didn't want to live to be 100 like this."
All of Musial's admirers preferred to recall the long-lasting glory days.
"I never got to see him play but I saw what type of person he was and what type of impact he had in this city," Cardinals general manager John Mozeliak said. "That made me realize how lucky we were to have him."
Commissioner Bud Selig said baseball lost "one of its true legends," adding that Musial had been a "Hall of Famer in every sense and a man who led a great American life."
"All of Major League Baseball mourns his passing, and we extend our deepest condolences to his family, friends, admirers and all the fans of the Cardinals," Selig said.
Hall of Fame President Jeff Idelson said: "The mold broke with Stan. There will never be another like him."
"Stan will be remembered in baseball annals as one of the pillars of our game, with his many successes on the diamond, the passion with which he played, and his engaging personality," he said.
Blues Hall of Famer Bernie Federko commented on Musial after broadcasting the hockey team's 6-0 victory over Detroit.
"He never acted like a famous ballplayer, he just acted like a normal guy. He always had time for everyone, and he looked you in the eye," Federko said. "It's a sad day but to go at 92, it's a great life. I lost my dad last year at 92 the same way. If we all signed up for 92 years, we'd be pretty happy about it."