Professional Web Applications Themes

MySQL Databases lost - MySQL

Hi, I am using MySQL v4.1 on Linux (CentOS v4.2)) I don't how, but when I list the databases available, "mySQL" databases doesn't exist anymore !!! As far as i know, this database stores all the infomation on users and rights ? How can I do to restore it ? , instead of reinstalling completely the RPM package ? :-( thanks Steph...

  1. #1

    Default MySQL Databases lost

    Hi,

    I am using MySQL v4.1 on Linux (CentOS v4.2))

    I don't how, but when I list the databases available, "mySQL" databases
    doesn't exist anymore !!!
    As far as i know, this database stores all the infomation on users and
    rights ?

    How can I do to restore it ? , instead of reinstalling completely the RPM
    package ? :-(

    thanks
    Steph


    Stephane M Guest

  2. #2

    Default Re: MySQL Databases lost

    Stephane M wrote:
    > I don't how, but when I list the databases available, "mySQL" databases
    > doesn't exist anymore !!!
    Another possibility is that you're connecting without specifying the
    correct user/password combination to see the database.

    A typical MySQL installation allows any user (including anonymous
    connections that specify no user) to see only the "test" database. You
    need to specify a user that has privilege to see the "mysql" database in
    order to see it.

    For instance, this command:

    mysqlshow

    Shows only the "test" database.

    mysqlshow -u root -p

    The latter command shows several databases, including your "mysql"
    system database.

    Note that operating system user and MySQL user are totally separate
    identities; one does not imply the other, even if they have the same
    names (e.g. there's a root for Linux and a root for MySQL, and they are
    not the same). So you can log in to Linux as root, and still have no
    privileges in MySQL unless you specify the user/password as options when
    you use "mysql" or other tools.

    Regards,
    Bill K.
    Bill Karwin Guest

  3. #3

    Default Re: MySQL Databases lost


    "Bill Karwin" <billkarwin.com> wrote in message
    news:e0q1iu016lienews3.newsguy.com...
    > Stephane M wrote:
    >> I don't how, but when I list the databases available, "mySQL" databases
    >> doesn't exist anymore !!!
    >
    > Another possibility is that you're connecting without specifying the
    > correct user/password combination to see the database.
    >
    > A typical MySQL installation allows any user (including anonymous
    > connections that specify no user) to see only the "test" database. You
    > need to specify a user that has privilege to see the "mysql" database in
    > order to see it.
    >
    > For instance, this command:
    >
    > mysqlshow
    >
    > Shows only the "test" database.
    >
    > mysqlshow -u root -p
    >
    > The latter command shows several databases, including your "mysql" system
    > database.
    >
    > Note that operating system user and MySQL user are totally separate
    > identities; one does not imply the other, even if they have the same names
    > (e.g. there's a root for Linux and a root for MySQL, and they are not the
    > same). So you can log in to Linux as root, and still have no privileges
    > in MySQL unless you specify the user/password as options when you use
    > "mysql" or other tools.
    >
    > Regards,
    > Bill K.
    Unfortunately, I cannot connect to mySQL database even as Root

    Do you know how to reset the Root password ?
    All there password are stored inot the database calles mySQL ???
    Thanks

    Stephane


    Stephane M Guest

  4. #4

    Default Re: MySQL Databases lost

    Stephane M wrote:
    > Do you know how to reset the Root password ?
    [url]http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html[/url]
    > All [their] password[s] are stored [into] the database [called] mySQL ???
    Correct.

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Replies: 1
    Last Post: January 23rd, 12:06 PM
  2. upgraded mysql, lost all data?
    By Tim McNamara in forum MySQL
    Replies: 1
    Last Post: February 3rd, 10:18 PM
  3. [charter] comp.databases.mysql
    By Woodchuck Bill in forum MySQL
    Replies: 5
    Last Post: October 7th, 01:50 PM
  4. Lost MySql Table Access
    By r.mcinteer in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 29th, 10:33 AM
  5. Searching MySQL databases with PHP
    By Richard Conway in forum PHP Development
    Replies: 1
    Last Post: July 29th, 04:18 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139