
How to reset the root user account for a MySQL database
Inherited a MySQL server with no root password? Start mysqld with --skip-grant-tables, update the root password in the grant tables, and you're back in. Here's how.
1 min read
2 articles tagged “mysql”

Inherited a MySQL server with no root password? Start mysqld with --skip-grant-tables, update the root password in the grant tables, and you're back in. Here's how.

If your Urchin 6 profile is stuck in 'Running' with errors 12007 and 12008, a reboot during processing left MySQL inconsistent. Here's the command-line fix to clear it.