Re: restarting mysql databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]




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

What I thought.  I guess just shooting in the dark.


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/*

ls /var/lib/mysqld/*
ls: cannot access /var/lib/mysqld/*: No such file or directory

did you mean /var/lib/mysql/*  ?

But that seems risky as there is /var/lib/mysql/mysql that has lots of interesting looking files. But there is an empty directy /var/lib/mysql/foo and /var/lib/mysql/mydb with the file db.opt



* 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

I MIGHT have gotten to this in a couple of days or reading. Thanks for the pointer.


_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos




[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux