Mysql命令行添加用户并且给予远程访问服务器的权限
--查询用户
SELECT User, Password, Host FROM user;
--创建一个用户,任意主机可以登录%,密码是123456 CREATE USER 'palm'@'%' IDENTIFIED BY '123456';
-- 给用户赋予所有权限 GRANT ALL ON *.* TO 'palm'@'%';
-- 刷新数据库 flush privileges;
参见:http://my.oschina.net/u/1179414/blog/202377文章
Face your past without regret. Handle your present with confidence.Prepare for future without fear. keep the faith and drop the fear.
面对过去无怨无悔,把握现在充满信心,备战未来无所畏惧。保持信念,克服恐惧!一点一滴的积累,一点一滴的沉淀,学技术需要不断的积淀!