具体操作请参考文章
1.http://blog.****.net/aaronbai/article/details/1431190
更改数据存储目录时候会出现
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
解决方案:
http://fuhj02.blog.51cto.com/274616/1357405
//登陆
mysql -u root -p
//新增用户
insert into mysql.user(Host,User,Password) values("%","liudongri",password("iminerldr"));
flush privileges;
//分配root权限
grant all on *.* to 'liudongri'@'%';
flush privileges;
//分配查询权限
grant select,insert,update,delete on *.* to 'liudongri'@'%';
flush privileges;
mysql 设置root密码 用SET PASSWORD命令
mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
本地不能登陆问题
http://blog.sina.com.cn/s/blog_7d1d5b0001015lv4.html
---断电mysql不能启动问题
http://blog.sina.com.cn/s/blog_5093fd500102v8qg.html