SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    accidentally deleted mysql database and my database?

    I think I may have deleted the mysql database as well as a practice database ("ijdb") that I just created. Here is what I'm being given as a result of my SHOW DATABASES command:
    Code:
    mysql> USE ijdb;
    ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'ijdb'
    mysql> SHOW DATABASES;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema | 
    +--------------------+
    1 row in set (0.00 sec)
    Right before this, I was trying to add data to a table within the "ijdb" database, and the data included several single and double quotes. I may have done something inadvertent involving quotes and escaping, because I couldn't get back to the [mysql>] command prompt. I closed down my Terminal window, tried to USE ijdb, then when I was given the error I entered the SHOW DATABASES command.

    If I bombed the mysql database is there anything I can do to recover it, or do I need to reinstall?

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,077
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    You might be looking at a re-install of MySQL as the users table in the mysql database is what the server uses to keep track of who is authorised to use a database.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    Thanks, had a feeling...


Bookmarks

Posting Permissions

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