Unable to update security settings
Posted by: James Murphy
Date: August 10, 2014 03:59PM
Date: August 10, 2014 03:59PM
Due to access problems I uninstalled and reinstalled MySql from
mysql-installer-community-5.6.20.0.msi
When I got to the configuaration neither the "MySQL Server 5.6.20" nor the "Samples and Examples" worked.
"MySQL Server 5.6.20" Configuration produced:
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:10 - Checking if there are any features installed that need configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
"Samples and Examples" Configuration produced:
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:10 - Checking if there are any features installed that need configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-installer-community-5.6.20.0.msi
When I got to the configuaration neither the "MySQL Server 5.6.20" nor the "Samples and Examples" worked.
"MySQL Server 5.6.20" Configuration produced:
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:10 - Checking if there are any features installed that need configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
"Samples and Examples" Configuration produced:
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:10 - Checking if there are any features installed that need configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
mysql-server-5.6-win32:6 - Looking for valid template
mysql-server-5.6-win32:12 - Found valid template.
mysql-server-5.6-win32:18 - Attempting to process template.
mysql-server-5.6-win32:25 - Processed template.
mysql-server-5.6-win32:31 - Attempting to configure service.
mysql-server-5.6-win32:37 - Configured service.
mysql-server-5.6-win32:43 - Attempting to start service.
mysql-server-5.6-win32:50 - Started service.
mysql-server-5.6-win32:56 - Adding firewall rule for MySQL56 on port 3306.
mysql-server-5.6-win32:62 - Successfully added firewall rule.
mysql-server-5.6-win32:68 - Attempting to update security settings.
mysql-server-5.6-win32:100 - Unable to update security settings. Access denied for user 'root'@'localhost' (using password: YES)
mysql-server-5.6-win32:75 - Attempting to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.6-win32:100 - Product configuration controller finished configuration.
examples-5.6:100 - Could not open connection to database
examples-5.6:100 - Product configuration controller finished configuration.
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.