LNMP(linux+nginx+mysql+php)服务器环境配置（一）mysql安装

搭建LNMP(linux+nginx+mysql+php)服务器，首先搭建mysql服务器

[color=blue]1 安装mysql[/color]

yum install -y mysql mysql-server mysql-devel

[color=blue]2 启动mysql服务[/color]

service mysqld start

[color=blue]3 设置root用户密码[/color]

mysqladmin -u root password 123456

[color=blue]4 登录mysql[/color]

mysql -u root -p123456

[color=blue]5 mysql远程登录。windows下，用SQLyog或navicat等软件连接mysql：[/color]
首先查看mysql服务使用哪个端口

netstat -tulnp

[img]http://dl2.iteye.com/upload/attachment/0106/3232/2eb80a19-0b58-3410-b798-bc3783ef87f1.png[/img]

其次，防火墙设置

iptables -I INPUT 3 -p tcp --dport 3306 -j ACCEPT
service iptables save
service iptables restart 

再次，赋予用户权限（我这里给了全部权限）

mysql -u root -p123456
show grants;

[img]http://dl2.iteye.com/upload/attachment/0106/3250/ebe8aae5-18d8-3a1a-960a-c966ddf6fd09.png[/img]

[color=red]这里注意：password要密文，所以执行select password('你想要的密码')[/color]
[img]http://dl2.iteye.com/upload/attachment/0106/3252/5f894c1d-f5cb-39f3-b969-bceaca8d0a65.png[/img]

最后:用SQLyog或navicat连接

[img]http://dl2.iteye.com/upload/attachment/0106/3254/274f902a-2f8d-39f7-a5c8-5b0160dd97df.png[/img]

[img]http://dl2.iteye.com/upload/attachment/0106/3256/186d3948-b670-3722-9ba6-34c428899634.png[/img]