1.Got error 28 from storage engine
如果数据库存储空间没问题,应该是数据库用的临时目录空间不够。
linux:清空/tmp目录,或者修改my.cnf中的tmpdir参数,指向具有足够空间目录。
windows: mysql的临时目录一般在C:\Windows\Temp。
2.
1045 access denied for user 'root'@'localhost' using password yes
service mysql stop
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
//新开一个终端
mysql -u root -p
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
mysql> FLUSH PRIVILEGES;
mysql> quit
service mysql start
3.mysql is runing but PID file could not be found
先打印MYSQL进程
ps aux | grep mysql
然后KILL进程
kill -9 pid1 pid2 …
再启动MYSQL
service mysql start
ps aux | grep mysql
然后KILL进程
kill -9 pid1 pid2 …
再启动MYSQL
service mysql start
4. mysql 启动 出现 the server quit without updating PID file
mysql_install_db --user=mysql --datadir=/var/lib/mysql
启动mysql
mysqld_safe --user=mysql &
5.
重置密码后,mysql中执行语句 you must set password before executing this statement
mysql> SET PASSWORD=PASSWORD('password');