Find the answer to your Linux question:
Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 25
hi: i have my testing server set up (FC3) and i am attempting to connect to a mysql db that i created in gnome-db. i set the db up and ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    i'm stumped ~ mysql no connect


    hi:

    i have my testing server set up (FC3) and i am attempting to connect to a mysql db that i created in gnome-db. i set the db up and the connect string looks good, however when i attempt to connect with the username and password, i get:

    * Connection to Database failed
    Access denied for user: 'myuser@localhost' (Using password: YES)

    anyone have any ideas?

    any help would be appreciated.

    j

  2. #2
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    does myuser@localhost have access to the database in question?

    you can either grant ALLL priviliges to that user globally (insecure) or give him persmision to just the databases you want him access to, make sure he has either one of the other.

    are you connecting from a difernet host or from localhost?

    Luc

  3. #3
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql connect

    yes, i am creating the db with gnome-db and the connect string is good. when i check /var/lib/mysql i am not seeing the db i created in gnome. it is appearing in the gnome queue. yes, i am connecting as localhost.

    still no luck.

    help,
    john

  4. #4
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    what about the user? mysql by default won't give a new user access to nothing, you need to gran this user access.

    or use root@localhost..

    I never used gnome-db so no clue about it.

    I use my sql command line and Phpmyadmin to admister the database so I can't help you specialy with gnome-db.

    Luma

  5. #5
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

    thank you. so, how do i create a db and assign a username from the command line?

    j

  6. #6
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    let see if I can remember

    go to a shell.

    type mysql -u root -p

    it will give you
    enterpassword:
    so enter the mysql root password....

    create database nameofdatabasehere; (press enter)
    Query OK, 1 row affected (0.00 sec)

    now type
    GRANT ALL (pressenter)
    >ON newdatabasenewhere.* (press enter)
    >TO newusername@localhost; (press enter)
    Query OK, 0 rows affected (0.02 sec)

    this new user DOES NOT HAVE A PASSWORD. so lets give him one.
    mysqladmin -u molly -p password NEWPASSWORD

    exit

    so here you have created a database called nameofdatabasehere (I hope you cahnge this )
    then granted ALL persmision so that new database to newusername (hope you cahnge this too ) at localhost

    btw localhost users can only connect from you guess it. the localhost (that computer only)

    Luma

  7. #7
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

    i tried this and all i get is:

    Error 1045: Access denied for user: 'root@localhost' (Using password: YES)


    i'm logged at the command prompt as root.

    what gives?


    john

  8. #8
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    what is your mysql root password? (don't type it here but I hope you know this.)
    you need to reorganise man, you need to know at least some stuff, you need user id and password of a WORKING account on the database

    Luma

  9. #9
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

    i have been using su - and logging in as root and various other usernames with no problems. for instance, right now i am logged in at the term window as

    [root@linuxbox mysql]

    this is the prob: as a user or as a su -, i am being told that access is denied.

    could it be in the setup of mysql server and how do i go about making the changes to enable me as a user?


    j

  10. #10
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    mysql is completely seperate users then the computer itself.

    try root as mysql user without password...

    Luma

Page 1 of 3 1 2 3 LastLast

Posting Permissions

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