MySQL access

Discussion in 'General' started by gmaoret, Jan 16, 2008.

  1. gmaoret

    Joined:
    Nov 13, 2007
    Messages:
    50
    Likes Received:
    0
    What's the UseID and the Password for access to MySQL inteface in Elastix 9.2?
     
  2. ramoncio

    Joined:
    May 12, 2010
    Messages:
    1,663
    Likes Received:
    0
    root / eLaStIx.2oo7
     
  3. gmaoret

    Joined:
    Nov 13, 2007
    Messages:
    50
    Likes Received:
    0
    Using that UID/PWD:

    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

    I have a fresh install of versione 0.9.2-4
     
  4. ramoncio

    Joined:
    May 12, 2010
    Messages:
    1,663
    Likes Received:
    0
    You must be doing something wrong...

    the password is eLaStIx.2oo7
    (notice they've used "o" letters instead of zeros in 2oo7)

    Or you can try with webmin mysql module. It is easier.<br><br>Post edited by: ramoncio, at: 2008/01/16 23:57
     
  5. gmaoret

    Joined:
    Nov 13, 2007
    Messages:
    50
    Likes Received:
    0
    ok, it works if I copy and paste the password.

    Probably it's my terminal app that don't pass it correctly.

    Bye
     
  6. haamed

    Joined:
    Jul 23, 2007
    Messages:
    251
    Likes Received:
    0
    Hi,
    i have this problem with mysql login:

    > mysql -u root -p eLaStIx.2oo7
    Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    I use copy and paste,!
    but i thing it has another problem.
     
  7. haamed

    Joined:
    Jul 23, 2007
    Messages:
    251
    Likes Received:
    0
    it was solved ! :p :blush:
     
  8. aliarjmandi

    Joined:
    Aug 20, 2008
    Messages:
    11
    Likes Received:
    0
    Hi
    I want to connect Mysql from windows (Nivacat 8 for mysql) .
    I edit cdr_mysql.conf

    [global]
    hostname=192.168.100.5
    dbname=asteriskcdrdb
    password=eLaStIx.asteriskuser.2oo7
    user=asteriskuser
    userfield=1
    port=3306
    ;sock=/tmp/mysql.sock

    but when i connect i give this message
    Host 192.168.100.55(my pc)' is not allowed to connect to this my sql server

    please help me
     
  9. aliarjmandi

    Joined:
    Aug 20, 2008
    Messages:
    11
    Likes Received:
    0
    Solved

    mysql> INSERT INTO user (Host,User,Password)
    -> VALUES('192.168.100.55','admin',PASSWORD('123456'));

    GRANT ALL PRIVILEGES ON *.* TO 'admin'@'192.168.100.55'
    -> IDENTIFIED BY '123456' WITH GRANT OPTION;

    192.168.100.55 = address of guest want to connect
     

Share This Page