I am doing an install of a mysql system, and decided that I needed to change some things like host name. So I have to go back to square one with the mysql setup, but can't find any instructions for this. I TRIED: mysql_install_db And it did SOMETHING, but mysqladmin -u root password 'mypass' failed with: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I tried 'yum reinstall mysql' and that did not help.
On 10/6/2014 12:01 PM, Robert Moskowitz wrote:> I am doing an install of a mysql system, and decided that I needed to > change some things like host name. So I have to go back to square one > with the mysql setup, but can't find any instructions for this. I TRIED:changing hostname, ip addresses, etc, should have ZERO impact on mysql. -- john r pierce 37N 122W somewhere on the middle of the left coast
On 2014-10-07 06:01, Robert Moskowitz wrote:> I am doing an install of a mysql system, and decided that I needed to > change some things like host name. So I have to go back to square one > with the mysql setup, but can't find any instructions for this. I > TRIED: > > mysql_install_db > > And it did SOMETHING, but > > mysqladmin -u root password 'mypass' > > failed with:Why not change hostname back to what it was previously, then change the hostname associated with the root user in the user database? I'm thinking this is rather simple and I'm worried I'm overlooking something by suggesting this after having read the entire thread... Cheers, ak.