Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Nuclear's Avatar
    Join Date: Sep:2004
    Location: , . ()
    Posts: 3,352

    MySQL remote connection

    .

    MySQL 5.1.37 Ubuntu 9.10

    mysql , localhost.
    localhost, .

    IP (94.73.32.46) php , :

    Code:
    mysql_connect("94.73.32.46", "crimson", "password")) or die(mysql_error();
    :

    Code:
    Warning: mysql_connect() [function.mysql-connect]: Host '94.73.32.46' is not allowed to connect to this MySQL server in /data/upload/nuclear/test/connect.php on line 2
    Host '94.73.32.46' is not allowed to connect to this MySQL server
    , . :

    Code:
    nuclear@aridas:~$ mysql -u root -p
    mysql> grant all privileges on *.* to 'crimson'@'94.73.32.46' identified by 'password';
    Query OK, 0 rows affected (0.00 sec)
    /etc/mysql/my.cnf
    Code:
    bind-address            = 94.73.32.46
    + mysqld

    :

    Code:
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'crimson'@'94.73.32.46' (using password: YES) in /data/upload/nuclear/test/connect.php on line 2
    Access denied for user 'crimson'@'94.73.32.46' (using password: YES)
    , , 'localhost'?
    . HWBG !

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , 'localhost' .

  3. #3
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,387
    :
    Code:
    GRANT ALL PRIVILEGES ON *.* TO 'crimson'@'%'...
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |