You might have encountered the following 'Applying Security Settings' failure error while installing MySQL Server (more precisely, during the instance configuration) for Windows.
This occurs because an older MySQL database (instance) exists in your system. To find where it is located, open the my.ini file in the MySQL installation folder and find '#Path to the database root' string. The line next to it specifies the default path to the database folder. By default this will be pointing to "C:/ProgramData/MySQL/MySQL Server 5.5/Data/".
Now remove the existing MySQL installation. Next, open the parent folder of the database location ( ie if the path is "C:/ProgramData/MySQL/MySQL Server 5.5/Data/" then open the folder that is the parent of "MySQL" folder). Here it will be "C:/ProgramData". Then delete the "MySQL" folder (with all its contents) in it.
Notes:
1. Deleting only the "Data" folder will also serve our purpose. But it would be better if you delete the entire location as specified above.
2. The "ProgramData" folder is a hidden/system folder. So in order to access it, type the path of the folder ("C:/ProgramData") in your windows explorer address bar and press enter.
3. Deleting the database will delete all the data stored in it. You may not be able to recover it.
Now install a fresh copy. You will see that it works like charm!
Nice and useful piece of info. I'm glad that you simply shared this helpful information with us. Please keep us informed like this. Thank you for sharing.
ReplyDeleteWeb Development Company in Chandigarh
You're welcome. Thank you for responding.
DeleteGreat useful that you simply shared this blog information helpful.
ReplyDeleteWeb designing course in Chandigarh
How To Install Mysql In Windows 2012 Server.......http://mytecharticle.com/?p=923
ReplyDeletevery useful post
ReplyDeletewebsite designing company in india
For anyone who is looking for an alarm system provider who is reliable and affordable so I highly recommend to purchase the service of security systems Toronto. http://www.baanto.com/touch-screen-frames-and-systems
ReplyDeleteHi there!! We are two engineering students from Mexico and we had a big issue with this, your post saved us thank you!!!!!
ReplyDeleteYou're welcome. Thank you for responding.
Deletethanks man! (y)
ReplyDeleteYou're welcome. Thank you for responding.
Deletethank you for this infos..
ReplyDeleteYou're welcome. Thank you for responding.
DeleteThanksssss!! This works fine for me ;)
ReplyDeleteadvanced windows tips and tricks
Nice.., It worked
ReplyDeleteThank you for the response.
DeleteIt's very nice~~^^, It solved.
ReplyDeleteThank you for the response.
Deletethank you very much buddy..its work for me
ReplyDeletePositive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.
ReplyDeleteSecurity Systems
great !!! it is working now
ReplyDeleteNot able to Secure MySQL Database from Anyone? Contact to MySQL Technical Support |Cognegic
ReplyDeleteWith MySQL database we can without much of a stretch play out our work. In any case, the primary concern its security, in the event that we are not genuine about our MySQL then any programmer can hack our MySQL database and play out some irregular exercises. Ensure in the event that you need to anchor your record then you need to take after the beneath ventures to anchor your MySQL database. To start with you need to introduce any best antivirus or antispam programming and furthermore you need to arrange working framework's firewall. Aside from that on the off chance that you have any issue then you can straightforwardly contact to MySQL Remote Support or MySQL Remote Service.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
Troubleshoot Security Issues with MySQL Database with to MySQL Technical Support
ReplyDeleteWorking with MySQL is extremely advantageous however in the event that keep up and working with MySQL then you need to comprehend the significance of security in MySQL. There are various types of security hazard in MySQL which make issues and forestall you to work with your MySQL. A portion of the security issues are: File framework security issue, Network security issue and some more. Be that as it may, with our extreme help suppliers you can without much of a stretch bring the correct answer for your MySQL Issues. Contact to MySQL Remote Support and MySQL Remote Service
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
Troubleshoot MySQL Installation and Configuration if Unable to Process? Contact to MySQL Technical Support
ReplyDeleteCognegic's MySQL Remote Support gives improved help to your establishment and arrangement related issues. At Cognegic we give out-of-box administrations to boost the uptime and execution of your MySQL. In any case, being a quick and dependable database framework some of the time it joins some specialized issues and ensures any single issue can influence your entire work and because of this reason, it winds up lumbering to defeat of this issue. In any case, with Cognegic's MySQL Remote Service can investigate your issues and offer propel bolster.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
Thanks man you helped me out!
ReplyDelete