login: root

Tag: mysql

  • changing mysql to innodb_file_per_table=1 with lvm and replication almost without downtime

    —

    by

    nsc
    in

    This conversion was made with mysql 5.5, but it should work with older versions, as replications on mysql were introduced since mysql 3.23.15. Don’t forget the Disclaimer !!! It requires more than the basic knowledge in linux, lvm and mysql. I do NOT take ANY responsibility for Your data loss!!! Long story short: enable mysql…

  • Recover mysql root password

    Recover mysql root password

    —

    by

    nsc
    in

    It happens quite often, that You need to do something on database, which was installed long long time ago. And nobody remembers the root password. Kinda good practice is to save mysql password in root user directory with a “.” in front of it (hidden), for example .my.cnf Nobody can read root users directory, except…