Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    74

    Unanswered: after installed mysql, only test database show

    hi, good day, i have install mysql with 4.0.2a version, when i start mysql and using "show databases" command , it only contain test database , why is it so ? i couln't found "mysql" database inside ..anyone can guide to solve this problem ? thank you !!

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    did you log into mysql as the root user?

  3. #3
    Join Date
    Mar 2004
    Posts
    74
    yes, i'm under computer administrator account in winxp

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    no, not who you are logged into in XP. When you log into mysql do you do it as the root user for mysql or do you do it as a user where you might not have set up privileges properly?

  5. #5
    Join Date
    Oct 2004
    Location
    Romania
    Posts
    5
    you need to run from command line the following

    mysql -uroot -p (if your root account for mysql has a password)


    have a nice day.

  6. #6
    Join Date
    Mar 2004
    Posts
    74
    yes, ok ...i still log in as root ,

    what i have did

    1) after installed, i use "mysqladmin -u root password 'password' " command to set first time password, then restart pc

    2) enter mysql using command "mysql -u root -p" , enter password 'password' which i already defined ..but cannot access

    3) then i just type "mysql" ..it allow me to go in ..however, i use "show databases;" , it only show me test database, but no mysql db reside

    anyone know what problem is it

  7. #7
    Join Date
    Mar 2004
    Posts
    480
    If you just type mysql and it allows you in then you haven't changed your mysql table which by default allows connections by any user from localhost without a password. But then as an anonymous user you have no permissions to see any databases you may have set up.

    when you say you can't get in as root, please post the error message you get.

  8. #8
    Join Date
    Mar 2004
    Posts
    74
    when i use command "mysql -u root -p", it show error 1045 : accessed denies for user, 'root@localhost' <using pasword : yes>

    then if i use command "mysql", it let me go in, then i try to use "update user set password=PASSWORD('password') where user='root'" command to update password but it show me error 1046 : no database selected

Posting Permissions

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