Changes between Version 43 and Version 44 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
11/15/10 09:44:26 (14 years ago)
Author:
Fran Boon
Comment:

Reset Lost root password

Legend:

Unmodified
Added
Removed
Modified

  • InstallationGuidelines/MySQL

    v43 v44  
    190190 * Then mysqldump to export each database to an individual flat file.
    191191
     192=== Reset Lost root password ===
     193Debian:
     194{{{
     195dpkg-reconfigure mysql-server-5.1
     196}}}
     197
     198Manually:
     199{{{
     200/etc/init.d/mysql stop
     201mysqld_safe --skip-grant-tables &
     202
     203mysql -u root
     204
     205UPDATE mysql.user SET Password=PASSWORD('mynewpassword') WHERE User='root';
     206FLUSH PRIVILEGES;
     207quit
     208
     209/etc/init.d/mysql stop
     210/etc/init.d/mysql start
     211mysql -u root -p
     212}}}
    192213=== Troubleshooting ===
    193214Can view the list of expensive queries by editing /etc/mysql/my.cnf and uncommenting/adding: