#1
  1. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Posts
    879
    Rep Power
    12

    Exclamation Enable to read and write in Program Files


    Hi

    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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Oct 2009
    Location
    Nebraska, USA
    Posts
    862
    Rep Power
    275
    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 05:20 PM.
  4. #3
  5. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    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

    • crackerweb agrees
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Posts
    879
    Rep Power
    12
    Yes! this works fine...Thanks!

    Originally Posted by E-Oreo
    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.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    99
    Rep Power
    0
    This was quite obvious actually

IMN logo majestic logo threadwatch logo seochat tools logo