Results 1 to 4 of 4

Thread: add new user to phpmyadmin

  1. #1
    Join Date
    Mar 2013
    Beans
    9

    add new user to phpmyadmin

    Hi,....firs sorry for my english..

    I'm tryng to install and configure LAMP solution on my UBUNTU. i have installed all the software, and i want to create some user in phpmyadmin to admnistrate his own database.

    i insert a username( for example alex) a passoword(es: 12345) and at the voice "host" i select from the combobox "ANY HOST". I though that the user alex can log-in on phpmyadmin from every host.

    But when i tried to login with username alex i receive the error "#1045 Cannot log in to the MySQL server"...that error from any host i try to connect(local or not).

    If I choose "local" instead of any host i can login.....from any host(local or remote).....that make me a bit confused...

    someome...can help me to undestand how it works?......what it means to select "any host" instead local?

    in a professional enviroment what a have to choose? local....any host or other?

    tanks Giovanni

  2. #2
    Join Date
    Jan 2005
    Location
    Illinois USA
    Beans
    1,047

    Re: add new user to phpmyadmin

    What do you mean "login from any host"? Through the webinterface or from a script?
    CloudRck.com - Host on CloudRck
    I sponsor open source projects and support users of such technologies. PM for details

  3. #3
    Join Date
    Mar 2006
    Location
    Williams Lake
    Beans
    Hidden!
    Distro
    Ubuntu Development Release

    Re: add new user to phpmyadmin

    Can you actually access mysql from any other host aside from localhost. By default mysql is only accessible from the system it is installed on. To allow access from other systems on your network, you need to modify /etc/mysql/my.cnf. Change the line:

    Code:
    bind-address		= 127.0.0.1
    to

    Code:
    bind-address            = <server-ip-address>
    where server-ip-address = the ip address of your server.

    Note: it is not advisable to leave mysql open to the internet, as unless you are using a strong password, the admin user is already know in a default Ubuntu install, and it is just a matter of brute forcing the mysql password.

  4. #4
    Join Date
    Mar 2013
    Beans
    9

    Re: add new user to phpmyadmin

    i have create this user on phpmyadmin

    username:alex
    host:any
    password:12345

    if i try to login from the webinterface of localhost/phpmyadmin i receive error 1045

    i made the same configuration on a remote computer on internet(virtual server on linode) i connect for example to 75.21.84.85/phpmyadmin i received the same error ----> no access in local or remote

    i have tried with other user

    username:joe
    host:local
    password:12345

    with that user i can have access locally with localhost/phpmyadmin and remotely 75.21.84.85/phpmyadmin --->so with local i have access locally and all over

    so with local i tell you to phpmyadmin that mysql is on the same computer of phpmyadmin?..or what?

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
  •