首先在mysql里面创建一个用户,使其有远程连接权限 在php中用 mysql_connect('your mysql server ip address','username','password')就可以连接
这个方法我也知道~~!我在想是不是可以用winadmin的配置文件直接帮定MYSQL服务器 MY.INI 配置如下#This File was made using the WinMySQLAdmin 1.3 Tool #2003-11-21 10:05:56#Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions[mysqld] basedir=D:/mysql #bind-address=192.168.0.1 datadir=D:/mysql/data #language=D:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=D:/mysql/bin/mysqld-nt.exe user=root password=
呵呵,竟然和楼上的几乎同一时刻回复;-) mysql中创建一个可远程连接的SQL是: grant all on YouDB.* to username@YourWebserverIP identified by 'password';
在php中用
mysql_connect('your mysql server ip address','username','password')就可以连接
#2003-11-21 10:05:56#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions[mysqld]
basedir=D:/mysql
#bind-address=192.168.0.1
datadir=D:/mysql/data
#language=D:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=D:/mysql/bin/mysqld-nt.exe
user=root
password=
mysql中创建一个可远程连接的SQL是:
grant all on YouDB.* to username@YourWebserverIP identified by 'password';