mysql安装错误解决
1.mysqld: Can't create directory 'D:\mysql\data\' (OS errno 2 - No such file or directory)
把目录改成反斜杠
2.MySQL登陆报错
更改my.ini文件:
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 这个有问题,在创建完新用户登录时报错
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
3.更改root密码,报无password字段
c:>mysql –uroot
mysql>show databases;
mysql>use mysql;
mysql>UPDATE user SET authentication_string=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES;
mysql>QUIT
posted on 2018-05-14 19:15 SheldonBin 阅读(12948) 评论(0) 编辑 收藏 举报