debian 安装 mysql
1.aptitude search mysql-client mysql-server
2.aptitude search mysql-client-5.1 mysql-server-5.1
3.aptitude install mysql-client-5.1 mysql-server-5.1
4.配置mysql,打开远程主机访问。
修改配置文件/etc/mysql/my.cnf
#bind-address = 127.0.0.1
bind-address =0.0.0.0 --表示接受所有地址
5.重启服务/etc/init.d/mysql restart
6.添加远程访问用户
使用root用户登录mysql后,执行:
grant create,drop,alter,select,insert,update,delete on *.* to "dev"@"%" identified by "123";
即可使用用户名dev,密码123,在远程主机登录并访问mysql数据库