linux mysql

来源：互联网发布：c语言好考么编辑：程序博客网时间：2024/05/17 02:36

Linux 安装mysql
http://jingyan.baidu.com/article/a378c9609eb652b3282830fd.html
http://www.cnblogs.com/bookwed/p/5896619.html

加入防火墙的白名单
http://blog.csdn.net/linuxlsq/article/details/52348625
http://blog.csdn.net/catoop/article/details/50476099

权限问题
http://www.cnblogs.com/fslnet/p/3143344.html

INSERT INTO user (host,user,password) VALUES ('ip','root',123456);grant all privileges on user.user to root@ip identified by '123456';

http://c.biancheng.net/cpp/html/1443.html

启动mysql

service mysqld start

查看状态
/etc/rc.d/init.d/mysqld status

http://www.2cto.com/database/201310/251824.html
http://www.d5s.cn/archives/9

mysql 添加某个ip 允许访问
http://blog.csdn.net/hanshileiai/article/details/46375449

mysql设置权限

CREATE USER vpeTest@localhost IDENTIFIED BY '123';grant select,update on user.* to vpe@localhost identified by  '123';

0 0