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.

[tomkrouper]

mysql/libraries/mysql_service_base.rb

Lines 89 to 98 in 753195b

	def initialize_database
	# initialize database and create initial records
	bash "#{new_resource.name} initial records" do
	code init_records_script
	umask '022'
	returns [0, 1, 2] # facepalm
	not_if { db_initialized? }
	action :run
	end
	end

• With db_initialized? false, and line 94 returns [0,1,2] set, it doesn't matter if MySQL is actually up. It will return a "valid" return code.
• Next time it attempts to run and db_initialized? is true, it won't attempt to run. The existence of the file in db_initialzed? doesn't prove that a sql statement has been run or not. (Still noodling how to resolve that.)

[lordkage]

@tomkrouper, tested using your branch, and it still failed to set the root password.

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