SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Aug 2001
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Alien databases in MySQL?

    I opened phpMyAdmin and discovered four new databases that I didn't create (I am the only user on this shared hosting plan): forumdata, freewareforum, rmoforum and veforum. When I try to drop them, MySQL returns:

    Error
    SQL-query:
    DROP DATABASE forumdata
    MySQL said: Access denied for user: 'myname@localhost' to database 'forumdata'

    The databases contain no tables. What are those alien monsters, and how to kill them? I am new to PHP, so any feedback will be appreciated. Thanks!

  2. #2
    <? echo "Kick me"; ?> petesmc's Avatar
    Join Date
    Nov 2000
    Location
    Hong Kong
    Posts
    1,508
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    On shared hosting you can almost always see everyone elses databases if you try hard enough. When you try to delete them you will get an error because each database on shared hosting as it own permissions which are set making only one person able to delete it. When you try to edit it, same thing, except it will always say no tables found because you don't have permission.

    If you really want this fixed you can ask your host to modify phpMyAdmin to show only your databases.

    -Peter

  3. #3
    SitePoint Member
    Join Date
    Aug 2001
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you, Peter. So I don't have to worry about it? As long as those databases don't consume my bandwidth and disk space, I can live with them. In fact, it would be interesting to watch databases grow on the shared server. Unless there are hundreds of them, so you have to struggle to find your own ones...

  4. #4
    <? echo "Kick me"; ?> petesmc's Avatar
    Join Date
    Nov 2000
    Location
    Hong Kong
    Posts
    1,508
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Usually the databases have your username before them, but there is nothing to worry about.

    -Peter


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
  •