Home >Database >Mysql Tutorial >debian6配置mysql允许远程连接的方法(图)_MySQL
debian6配置mysql允许远程连接的方法(图)_MySQL
- WBOYOriginal
- 2016-06-01 13:25:511040browse
debian
bitsCN.comdebian6系统：
首先先安装mysql吧：
打开终端（root）用户登入
apt-get purge mysql-server-5.5
安装完成后：
默认情况下Mysql只允许本地登录，所以需要修改配置文件将地址绑定给注释掉：
vim /etc/mysql/my.cnf
#bind-address = 127.0.0.1
若还是不行，请本地登录mysql执行词句：UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql Innodb表空间卸载、迁移、装载的使用方法_MySQLNext article：Linux自动备份MySQL数据库脚本代码_MySQL