Rss Feed

Posts Tagged ‘mysql’

  1. Forgotten MySQL Root Password

    18 June 2010 by admin

    It happens to the best of us all the time. (Three times in a 24-hour period is my record…) On my Ubuntu VPSs, this is what I do when that happens:

    $-> /etc/init.d/mysql stop
    $-> mysqld_safe --skip-grant-tables &
    $-> mysql -u root

    Use the ‘msyql’ database to issue this query:
    UPDATE user set password=PASSWORD("ice_cream") where User='root';
    Flush privs and then stop and start MySQL (normally).

    Category Uncategorized | Tags: ,,,,,, | No Comments

  2. Is MySQL OK?

    by admin

    There are always many ways to skin a cat but here’s a neat way to check on MySQL:

    root@aleida:/home/aleida# mysqladmin -p ping
    Enter password:
    mysqld is alive

    Kinda neat, no?

    Category Uncategorized | Tags: ,,,, | No Comments