February 22nd, 2011, 12:34 AM
Enable to read and write in Program Files
I've created a program which uses MySQL as backend, MySQL is installed at program files, I'm having trouble writing data inside my MySQL database as my OS is blocking my activity. I'm using Windows 7. Any remedy on this how I can read and write in my database.
Thanks in advance
February 22nd, 2011, 04:39 AM
two options come to mind...
1) backup your mysql DBs and uninstall mysql , then, reinstall mysql manually outside of the "program files" folder [ie. C:\mysql ] and re-setup your DBs.
2) run your program with elevated permissions [rt clk program exe and choose 'run as administrator']
Last edited by DonR; February 23rd, 2011 at 06:20 PM.
February 22nd, 2011, 08:49 AM
Right click on MySql's data folder and go to Properties, then click on the Security tab. Give full control to whatever user MySql is running as.
Comments on this post
March 6th, 2011, 07:04 AM
Yes! this works fine...Thanks!
Originally Posted by E-Oreo
April 25th, 2011, 11:03 AM
This was quite obvious actually