MySQL常用的权限操作

添加用户 SQL指令如下: CREATE USER '用户名'@'主机' IDENTIFIED BY '密码'; 例如,要创建在所有主机登录、密...

December 18, 2019 · 2 min

libnss-mysql的两个配置文件区分

libnss-mysql有两个配置文件: /etc/libnss-mysql.cfg /etc/libnss-mysql-root.cfg 其官方对这两个文件的用途是有解释的。也许是我的英语阅读能力太差,反正越看解释越搞不清楚。 同时根据...

March 9, 2014 · 2 min

Getting PAM to authenticate against MySQL

Because OpenSSH makes use of PAM for authentication, it may be desirable to back users with a pre-existing MySQL database. The following steps will show how to do this. This is yet another authentication option for integrations. The role of PAM and NSS There is some confusion as to the role of PAM and NSS. In a nutshell, PAM and NSS perform two related functions: PAM: Authentication of users NSS: Name Services The important item to note is that authentication is a question of, “Is this who they purport to be?...

July 13, 2013 · 6 min

迁移MySQL数据目录

话说在VPS中,重装系统也许是不可避免的事。对于很多VPS供应商而言,尤其是Linux客户机的VPS。所谓的重装,也就是直接用一块已经安装好...

May 24, 2010 · 2 min · athurg

远程联接MySQL服务器的设置

对于WEB开发人员而言,常常会遇到远程连接MySQL服务器的情况。一个网站上线后,需要正常的在远程服务器上运行。同时,漏洞修补和功能升级的工...

March 3, 2010 · 2 min · athurg

把AUR的网站建好了

算是了了一桩心愿了。 其实基本上都是按照AUR的文档里来的,只不过到最后阶段出现了两个问题。 无法链接数据库,这个问题是配置的问题。默认MySQ...

November 30, 2009 · 1 min · athurg