phpmyadmin连接远程mysql
phpmaadmin连接远程mysql
连接远程mysql步骤
.保证已经有�phpmyadmin,如果没有,去http://www.phpmyadmin.net/home_page/downloads.php下载,安装;文章这里用集成开发环境wamp自带的phpmyadmin示范。
进入到phpmyadmin安装目录下,这里是:C:\wamp\apps\phpmyadmin4.1.14,
.创建文件夹config;拷贝.config.inc.php到,\config\config.inc.php
浏览器中执行http://localhost/phpmyadmin/setup,根据自己主题填写host,user,password
.设置保存后,拷贝.\config\config.inc.php到.\config.inc.php(原来文件最好能备份一下)
文件config.inc.php
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 4.1.14 setup script
* Date: Wed, 24 Sep 2014 08:15:24 +0200
*/
/* Servers configuration */
$i = 0;
/* Server: 85 [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '85';
$cfg['Servers'][$i]['host'] = '172.163.25.85';/*远程数据库主机*/
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['nopassword'] = true;
$cfg['Servers'][$i]['auth_type'] = 'config';/*认证方式,以配置文件方式认证*/
$cfg['Servers'][$i]['user'] = 'user2';/*数据库账户*/
$cfg['Servers'][$i]['password'] = '';/*密码为空*/、
$cfg['Servers'][$i]['AllowNoPassword'] = true;/*账户密码为空时,添加此句*/
/* End of servers configuration */
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
$cfg['Servers'][$i]['AllowNoPassword']解释
$cfg['Servers'][$i]['AllowNoPassword']
Type: boolean
Default value: false
Whether
to allow logins without a password.The default value of false for this
parameter prevents unintended access to aMySQL server with was left with
an empty password for root or on which ananonymous (blank) user is
defined.
最新文章
- 12306官方火车票Api接口
- Visual Studio 2015 Update 3 ISO
- Yii2 实现修改密码功能
- oracle:jdbcTest
- LA 4123 (计数 递推) Glenbow Museum
- Oracle set autotrace 时提示:Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- Codeforces 459E Pashmak and Graph
- 第三十节,正则表达式re模块
- SMTP错误码建议解决方法
- pytorch错误:RuntimeError: received 0 items of ancdata解决
- Linux进程管理专题
- C语言 九九乘法表
- mongo的runCommand与集合操作函数的关系
- RabbitMQ 消费消息
- Oracle 11g 异机恢复参考文档
- C# 添加修改防火墙端口及程序
- Artech的MVC4框架学习——第七章Action的执行
- USACO 铂金 T1
- IntelliJ IDEA 2018.3 安装+永久激活[Windows]
- C#如何判断操作系统位数是32位还是64位