mysql>创建数据库测试；错误1006(HY000):无法创建数据库“测试"(错误号:2) [英] mysql> create database test; ERROR 1006 (HY000): Can't create database 'test' (errno: 2)

问题描述

以我的根帐户登录mysql后，我无法创建数据库.我需要注册一个管理员帐户吗?另外，由于某种原因，我的启动文件没有安装(出现错误).我不确定这是否会影响其他任何事情，因为当我在终端中键入"mysql"时，mySQL确实会启动.

I can't create a database after logging in mysql under my root account. Do I have to make an admin account to do so? Also, for some reason, my StartUp file didn't install (there was an error). I'm not sure if that will affect anything else since mySQL DOES start up when I type "mysql" into my terminal.

也是当我输入

mysql> SELECT Host, User FROM mysql.user;
+---------------------+------+
| Host                | User |
+---------------------+------+
| 127.0.0.1           | root |
| ::1                 | root |
| myname-mac.att.net  |      |
| myname-mac.att.net  | root |
| localhost           |      |
| localhost           | root |
+---------------------+------+

我不明白.我似乎有多个root用户，但我不知道:: 1是什么意思.

Which I don't get. I seem to have multiple root users and I don't know what ::1 means.

我的数据库当前如下所示.

My databases currently look like this.

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.02 sec)

输入我的数据库名称并不重要.我什至尝试称它为苹果".

And it doesn't matter what I type in as my database name. I even tried calling it 'apple'.

推荐答案

空间可能有问题. 遵循这个

It might be problem with space. Follow this

1. 在/var/lib/mysql
检查.err日志

2. 如果日志显示类似 "[错误]无法启动服务器:无法创建PID文件:设备上没有剩余空间"

1. Check .err logs at /var/lib/mysql

2. if the log says something like "[ERROR] Can't start server: can't create PID file: No space left on device"

通过df -hk /var

如果使用率是100％，那么您必须找到要填充的文件.

if used is 100% , then u have to find the files which is geting filled.

通过

find /var/ -type f -size +100000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'

查看可以删除的文件，然后通过以下方式重新启动mysql进程

see which file you can delete and then restart the mysql process by

让我知道是否可行:)

let me know if that worked :)

这篇关于mysql>创建数据库测试；错误1006(HY000):无法创建数据库“测试"(错误号:2)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！