mysql更改数据存储目录

时间:2023-03-09 01:48:44
mysql更改数据存储目录

具体操作请参考文章

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