On 10/06/2014 03:27 PM, Reindl Harald wrote: > > > Am 06.10.2014 um 21:24 schrieb Robert Moskowitz: >> >> On 10/06/2014 03:08 PM, Reindl Harald wrote: >>> >>> Am 06.10.2014 um 21:01 schrieb Robert Moskowitz: >>>> 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 >>> >>> why should "yum reinstall" change anything? >> >> Some apps reinit there data on reinstalls. Some don't. Don't know >> until you try. > > no they don't > > /var/lib/appname/ is never part of the package > otherwise update swould touch/damage your data > >>> the daemon specific data are below /var&/lib/mysql as for >>> any other software they live below /var/ib/appname >>> >>> no command ever will reset them besides rm -rf /var/lib/mysql/ >>> but what has that all to do with change the hostname? >> >> Don't know what changing the hostname did or does not do. I am digging >> into various info to figure out what to delete or rebuild to get back to >> pristine mysql. I can understand why this should not be easy - for >> someone to remove all of your mysql data, but it should be possible... > > if you have no data: > > * stop the service > * rm -rf /var/lib/mysqld/* Looks like the files: /var/lib/mysql/mysql/user.MYD /var/lib/mysql/mysql/user.MYI /var/lib/mysql/mysql/user.frm have the goo that has to go. > * start the service > * you have a virgin setup > > and as always read some docs > http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html > >