su 切换ivalue用户时,提示"This account is currently not available"; 首先进入/etc/passwd文件中是否添加ivalue用户,发现ivalue用户时候存在: cat /etc/passwd | grep ivalue 我们发现发现该用户不允许登录系统,所以导致我们su 切换时候报错 我们将“/sbin /nologin”,改成"/bin/bash"保存 再次切换,切换成功:
USE UFSystem go DECLARE @cUser_Id NVARCHAR(20) SET @cUser_Id='用户的登录名' DELETE l FROM dbo.UA_TaskLog l INNER JOIN dbo.ua_Task t ON t.cTaskId = l.cTaskId WHERE t.cUser_Id=@cUser_Id DELETE FROM dbo.ua_Task WHERE cUser_Id=@cUser_Id
问题: 在centOS上安装了mysql后,卸载了又重新安装,使用mysqladmin -u root password 'new password' 更改密码,提示: mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'" 解决方案: 1.修改MySQL的登录设置:# vi /etc/my.cnf在[mysqld]的段中加上一句:sk