fractalic.mysql-rootpass
MySQL rootpass
Reset MySQL Server Root Password
Sometimes uninstalling and purging mysql-server isn't enough to make your root password go away: it hangs around in the grant tables of the mysql database.
This role resets the root account password to empty-string, or another string of your choice.
The method is adapted from L.D. James' stackexchange answer.
I don't know where the mysql grant tables are stored, but I hope to find out.
Requirements
This package assumes you have a mysql server running somewhere, and that you don't care about reseting the root password. I can't make any guarantees that data will be safe, or that your mysql server will be in a usable state after running this role; please consider it a last-ditch effort.
This package will install python-mysqldb for both python2 and python3 on the target server.
This package expects mysql-server >= 5.7.6, and ubuntu=16.04, but will likely work with any system where mysql is fully managed by systemd.
Role Variables
defaults.yml
- mysql_rootpass_new: Set to empty-string by default
vars.yml
None
Dependencies
None
Example Playbook
- hosts: servers
roles:
- { role: fractalic.mysql-rootpass, mysql_rootpass_new: 'password' }
License
CC-BY
Author Information
Ben loves noodling about with C++, Javascript, and other languages. Right now he's working on mesh networking and cryptocurrency with a Vancouver company.
Contact: [email protected]
Reset the root password of a mysql server.
ansible-galaxy install fractalic.mysql-rootpass