A:由于开启了验证管理员的 IP ,在用户更换本地网络的 IP 或者换个网络后,导致进入后台要求一直输入密码。
修改为:
|
In my blog, i would discuss the problem i face in daily routine. Following are some of them: mysql error, mysql replication, mysql database corrupted repair, innodb tablespace corruption, mysql storage engines, mysql optimization and tuning, reinstall mysql linux server, linux command for dummies, linux administration tips, mysql administration tips, Linux server benchmarking
Tuesday, March 9, 2010
discuz !7.2登陆后台一直需要输入密码的解决方法?
Monday, March 8, 2010
if get Error No 1130 while connecting from your client to your mysql server
check whether the mysql user you are using have permission to connect from your current IP / host
SAMPLE: To create User with "Select" access only
Case 1: to create a user "report" that can access the dabatase from any IPRange
> CREATE USER 'report'@'%' IDENTIFIED BY 'p@ssw0rd';
> GRANT select ON *.* to 'report'@'%';
Case 2: to create a user "report" that can access the dabatase from localhost only
> CREATE USER 'report'@'localhost' IDENTIFIED BY 'p@ssw0rd';
> GRANT select ON *.* to 'report'@'localhost';
NOTE: after create the user, don't forget to flush the privileges.
> FLUSH PRIVILEGES;
to grant access to the USER;
grant all privileges on *.* to 'user'@'%';
'%' - here is indicating, the 'user' are able to connect via any host
to create a mysql user,
CREATE USER 'user'@'%' IDENTIFIED BY 'pswd123';
SAMPLE: To create User with "Select" access only
Case 1: to create a user "report" that can access the dabatase from any IPRange
> CREATE USER 'report'@'%' IDENTIFIED BY 'p@ssw0rd';
> GRANT select ON *.* to 'report'@'%';
Case 2: to create a user "report" that can access the dabatase from localhost only
> CREATE USER 'report'@'localhost' IDENTIFIED BY 'p@ssw0rd';
> GRANT select ON *.* to 'report'@'localhost';
NOTE: after create the user, don't forget to flush the privileges.
> FLUSH PRIVILEGES;
Subscribe to:
Posts (Atom)