错误信息
Access denied for user ‘root’ @ ‘xxxxx’ (using password:YES)
1:打开cmd,进入mySQL所在的磁盘中
2:输入 mysqld --initialize 进行初始化,mysql会自动帮你重新创建data文件
3:创建完毕之后,重新输入 net start mysql,就行
host WIN10-0007 is not allowed to connection to this mysql server
1:在装有MySQL的机器上登录MySQL mysql -u root -p密码
2:执行use mysql;
3:执行update user set host = '%' where user = 'root';如果报错,不用处理
4:执行FLUSH PRIVILEGES;