initial_root_password does not apply password during initialization of service

[lordkage]

👻 Brief Description

Using initial_root_password in the mysql_service resource does not apply the password, it always uses the default

🥞 Cookbook version

11.1.6

👩‍🍳 Chef-Infra Version

18.5.0

🎩 Platform details

CentOS Streaming 8 (but this appears to be an issue in multiple OSes)

Steps To Reproduce

1. Install and configure the MySQL service

mysql_service 'default' do
  port '3306'
  version '8.0'
  initial_root_password mysqlpass['password']
  action [:create, :start]
end

2. Converge
3. Attempt to connect via Socket: mysql -S /var/run/mysql/mysql.sock
4. The resulting error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

5. Attempt to connect via Socket with expected Password: sudo mysql -p -S /var/run/mysql/mysqld.sock
6. The resulting error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

7. Attempt to connect with HARD CODED default password: sudo mysql -p -S /var/run/mysql/mysqld.sock
8. Success! (and totally disappointing)

🚓 Expected behavior

You should be able to connect with the expected/defined password from the recipe. The default resource password SHOULD NOT be used.

➕ Additional context

• I spent a number of days tracking this down thinking I had a corrupt data bag or some other issue.
• Other issues like initial_root_password has no effect on modern MySQL versions #681 and Control hash is not picking up the password. #701 seem to be related to the same problem.