MySQL任意主机用户无法登录
在创建MySQL用户时,选择登录主机为“%”,意思为所有主机均可以连接。
命令如下:
grant all privileges on *.* to ‘kevin’@’%’ identified by ‘password’ with grant option;
创建完成后,登录发现提示如下错误:
ERROR 1045 (28000): Access denied for user ‘kevin’@’localhost’ (using password: YES)
从逻辑上说,%代表所有主机,为什么使用“localhost”就是不行呢?或者也有一种可能性,“%”不包括“localhost”主机,而创建连接时使用到了“localhost”。
新增用户@localhost:
grant all privileges on *.* to ‘kevin’@’localhost’ identified by ‘password’ with grant option;
刷新权限,登录成功。
flush privileges;
13 条评论
androxal saturday delivery cod
how to buy androxal cheap canada
enclomiphene online no prescription overnight
cheap enclomiphene online mastercard accepted
online order rifaximin cheap usa
get rifaximin price in us
buying xifaxan cheap next day delivery
order xifaxan generic medications
staxyn special price
discount staxyn australia cheap
buy cheap avodart without prescriptions canada
buy avodart san francisco
cheap dutasteride cheap prescription
order dutasteride cheap now
how to buy flexeril cyclobenzaprine cheap next day delivery
cheapest buy flexeril cyclobenzaprine cost of tablet
gabapentin online no rx
how to order gabapentin generic low price
cheapest buy fildena cheap mastercard
cheapest buy fildena usa price
cheap itraconazole no prescription mastercard
Order perscription free itraconazole
kamagra přepraveno přes noc bez lékařského předpisu
kamagra bez předpovědi
prix de kamagra 100 mg numéro 30
sans ordonnance kamagra prescrire eu medicament pharmacie