Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Feb 2012
    Posts
    85
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Error when Removing test Database

    Hi Guys,

    looking to follow the lynda.com SQL Essential training course however right at the beginning when trying to remove the test database (that's in from the start after a fresh XAMPP install) I get this error!

    Any ideas?

    Had a google search and ran a couple of the terminal commands suggested but same result!
    Attached Thumbnails Attached Thumbnails Error when Removing test Database-screen-shot-2013-09-03-20.21.42.jpg  
    Don't Click Here!

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,023
    Thanks
    75
    Thanked 4,323 Times in 4,289 Posts
    Looks like the database was installed incorrectly. Apparently, the directory that the database file is in (and, yes, with MySQL all databases are represented in the host operating system as files) has been marked as read only.

    Find that directory and change the permissions to read/write/execute for the MySQL engine.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New Coder
    Join Date
    Feb 2012
    Posts
    85
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi,

    Do you know what the directory would be on a default install, I've just tried uninstalling/reinstalling and Still the exact same, Really not sure why its doing it!
    Attached Thumbnails Attached Thumbnails Error when Removing test Database-screen-shot-2013-09-05-18.36.33.jpg  
    Don't Click Here!

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,023
    Thanks
    75
    Thanked 4,323 Times in 4,289 Posts
    I don't use XAMPP, just a standard MySQL only install.

    But *probably* it will be a file named "test.myd" (and likely also "test.myi") somewhere under the "mysql" directory you see there. In any case, search for "test.myd".

    Remember: It's not just the file itself whose permissions you need to change but also the directory containing that file.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •