之前在研究LAMP环境时,一直有个问题在困扰着我。那就是,架设的网站如果含有数据库安装页面,必须得主机上才行,也就是必须得用localhost来安装。我现在的环境是装了X-WINDOWS界面,如果没安装呢?怎么办?所以要解决这个问题。今天终于解决了,在MYSQL数据库中添加一个Remote用户即可:Add Mysql remote user with Linux OS
MYSQL>GRANT ALL PRIVILEGES on *.* TO color@localhost IDENTIFIED BY "password" WITH GRANT OPTION;
*:More attention the Capital letters!
*:Add an user "color" and PWD is "password",the authority is local and all databases;
MYSQL>GRANT ALL PRIVILEGES on *.* TO color@"%" IDENTIFIED BY "password" WITH GRANT OPTION;
*:%=>Remote server
*:set color(password) get all authority to the databaese on the remote server or station. Oracle10g在x86linux上的安装过程Linux系统下备份MySQL的详细笔记相关资讯 Linux技巧
- Linux技巧分享:如何检查PDF中使用 (08/27/2014 19:11:58)
- [技巧分享]如何在Linux中阻止其它 (06/29/2014 19:56:43)
- Linux技巧:一次删除一百万个文件 (06/13/2013 11:11:05)
| - Linux 目录导航技巧 (07/18/2014 08:29:50)
- 8个有趣的Linux提示与技巧! (01/31/2014 08:06:39)
- 35款基于terminal的Linux应用 (02/07/2011 12:54:14)
|
本文评论 查看全部评论 (0)