Results 1 to 3 of 3
Thread: MySQL remote connection
Hybrid View
-
16th February 2011 12:30 #1
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
/etc/mysql/my.cnfCode: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)
+ mysqldCode:bind-address = 94.73.32.46
:
, , 'localhost'?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)
. HWBG !
-
16th February 2011 12:43 #2
-
16th February 2011 12:50 #3
:
Code:GRANT ALL PRIVILEGES ON *.* TO 'crimson'@'%'...
: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in