MYSQL开启远程访问权限 用PHPMYADMIN－权限－添加新用户

开3306端口，grant一个帐户，默认的root不能用作远程连接。

您已添加了一个新用户。   www.shengfang.org
SQL 查询:
GRANT ALL PRIVILEGES ON * . * TO 'sf' at '192 dot 168.1.2' IDENTIFIED BY '******' WITH GRANT OPTION ;

 用户 'sf' at '192 dot 168.1.2'  www.shengfang.org
    编辑权限
  全局权限 
注意：MySQL 权限名称会以英文显示
全选     全部不选
 数据   结构   管理 
 SELECT  CREATE  GRANT
 INSERT  ALTER  PROCESS
 UPDATE  INDEX  RELOAD
 DELETE  DROP  SHUTDOWN
 FILE    REFERENCES
 
The GRANT and REVOKE statements allow system administrators to create MySQL user accounts and to grant rights to and revoke them from accounts. GRANT and REVOKE are implemented in MySQL 3.22.11 or later. For earlier MySQL versions, these statements do nothing.

MySQL account information is stored in the tables of the mysql database. This database and the access control system are discussed extensively in Chapter 5, Database Administration, which you should consult for additional details.

If the grant tables contain privilege records that contain mixed-case database or table names and the lower_case_table_names system variable is set, REVOKE cannot be used to revoke the privileges. It will be necessary to manipulate the grant tables directly. (GRANT will not create such records when lower_case_table_names is set, but such records might have been created prior to setting the variable.)

#下面这条指令可以把虚拟目录freehost映射到实际路径/apache/webroot/users/下!
#AliasMatch ^/class/([0-9]).html$ /article.php?articleid=$1
#AliasMatch ^/class/([0-9] ).([0-9a-zA-Z] ).html$ /article.php?articleid=$1＆amp;pagenum=$2
DirectoryIndex index.html index.htm index.php index.cgi bbs.pl index.pl admin.php login.htm login.html login.php
#默然主机头
AccessFileName .htaccess

Order allow,deny
Deny from all

TypesConfig conf/mime.types
DefaultType text/plain

MIMEMagicFile conf/magic

#Alias/class/"/apache/webroot/phpa"#虚拟目录啦
##对虚拟目录进行权限配置
#OptionsFollowSymLinks#+MultiViewsExecCGI为有CGI执行权限
#php_admin_valuesafe_mode1#表示此目录下的PHP脚本只能有php_safe下权限
#php_admin_valueopen_basedir/apache/phpsafe/
#此句是限制PHP的文件操作只能限于/apache/phpsafe及其子目录下,不能对此目录外的文进行操作
#php_flagengineoff
#表示此目录下的PHP脚本不会被解释执行,此选项要求PHP必须以模块方式安装的!
#AllowOverrideNone
#Orderallow,deny
#Allowfromall#表示允许任何人从任何地方访问

Alias /c "c:" www.shengfang.org

<Directory "c:">
    Options Indexes MultiViews
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>