Error 1005 Mysql Errno 13
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions error 1005 mysql errno 121 you might have Meta Discuss the workings and policies of mysql error 1005 errno 150 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring mysql error 1005 can't create table errno 121 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is error 1005 can t create table db errno 13 a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 1005 “Can't create table (errno: 13)” up vote 0 down vote favorite I am trying to do a migration with django to a MySQL database but I am receiving this error:
Mysql Error 1005 (hy000)
(1005, "Can't create table '#sql-60_f71' (errno: 13)") I have done several migrations before to this database and this is the first time seeing this error. The thing that really confuses me is that my migration isn't even creating a table. Here is what the migrations look like: operations = [ migrations.AddField( model_name='inverter', name='custom_name', field=models.CharField(blank=True, default=b'', max_length=30), ), migrations.AlterField( model_name='status', name='generic_name', field=models.CharField(default=b'Status', max_length=20), ), ] Thanks in advance. mysql django share|improve this question asked May 12 at 0:17 keverly 10615 1 (errno: 13) is a permissions error. I have no idea what's causing it from the information you've provided but some other people have talked about looking at your directories and seeing if you have the correct rights. stackoverflow.com/questions/2476272/… –Dresden May 12 at 0:24 @Dresden You are right. owner of database was me rather than mysql. I just had trouble figuring out where in the directory my database was located (ended up being
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: [solved] #1005 Can't create table (errno: 13) New Topic Advanced Search [solved] #1005 Can't create table (errno: 13) Posted
Mysql Errno 13 Permission Denied
by: Martin Wagner () Date: October 20, 2009 06:40PM !!!SOLVED see end of mysql can't create database errno 13 message hello, using Ubuntu Jaunty with mysqlclient/server 5.1.3. I`m trying to create a table on my localhost. logged in docker can't create table 'db' (errno: 13) as root. (all privileges & grant) but the result is an error message: #1005 Can't create table 'test' (errno: 13) "ls -al" to /var/lib/mysql is -drwxrwxr-x mysql mysql /var/lib/mysql/mysql is -rw-rw-r- mysql http://stackoverflow.com/questions/37175264/error-1005-cant-create-table-errno-13 mysql I tried other users as well as other (test)databases Tried to "google" the error but can't find smthg. except rights (should be set to mysql.mysql ) thanks in advance regards martin ___________________________ all *.MYD and *.MIY and *.frm must have minimum -> mysql as group (rights) Edited 1 time(s). Last edit at 10/20/2009 07:42PM by Martin Wagner. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written http://forums.mysql.com/read.php?10,287167 By Posted [solved] #1005 Can't create table (errno: 13) Martin Wagner 10/20/2009 06:40PM Re: [solved] #1005 Can't create table (errno: 13) Rick James 10/21/2009 09:47PM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides MySQL Cluster Legal Legal Policies Your Privacy Rights Terms of Use Trademark Policy Contributor Agreement © 2015, Oracle Corporation and/or its affiliates
hashchk Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK) Message: isamchk Error: 1002 SQLSTATE: HY000 (ER_NO) Message: NO Error: 1003 SQLSTATE: HY000 (ER_YES) Message: YES Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Message: Can't create file '%s' (errno: %d) http://www.fromdual.com/mysql-error-codes-and-messages-1000-1049 Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: %d) Error: 1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database '%s' (errno: %d) How does the MySQL error message look like? mysql> CREATE DATABASE test; ERROR 1006 (HY000): Can't create database 'test' (errno: 13) What does the MySQL error message mean? The MySQL Server (mysqld process) can, for whatever reason, NOT create a schema/database. Additional information you error 1005 can get as follows: shell> perror 13 OS error code 13: Permission denied When does this MySQL error message happen? This MySQL error usually happens when the MySQL data directory (datadir) does not belong to the user under which the mysqld process runs. For example the data directory belongs to the user root and the mysqld process runs as user mysql. How to fix this MySQL error? If mysql error 1005 the MySQL data directory does not belong to the user the mysqld process is running under, you can fix this for example as follows: shell> sudo su - shell> cd /var/lib shell> chown -R mysql:mysql mysql Alternatively you can start the mysqld process as follows: shell> bin/mysqld_safe --user=mysql or set the user accordingly in your my.cnf file. # my.cnf [mysqld] user = mysql Error: 1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists How does the MySQL error message look like? mysql> CREATE SCHEMA test; ERROR 1007 (HY000): Can't create database 'test'; database exists What does the MySQL error message mean? MySQL (the mysqld process) can, for whatever reason NOT create a schema/database. When does this MySQL error message happen? This MySQL error apears, as the error message states, when the database already exists. How to fix this MySQL error? You have 2 possiblities: Choose an other name for your new database / schema. Drop your old database / schema. Rename your old database / schema (we can provide you more information, how to do this). Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Message: Can't drop database '%s'; database doesn't exist Error: 1009 SQLSTATE: HY000 (ER_DB_DROP_DELETE) Message: Error dropping database (can't d