Error 13 Hy000 Mysql
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn error 13 hy000 errcode 2 more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered
Error Hy000 Mysql Odbc 5.1 Driver Access Denied For User
Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills error 2002 hy000 mysql and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the error 2002 hy000 mysql centos top MySQL import csv file ERROR 13 (HY000): Can't get stat of /path/file.csv (Errcode: 2) up vote 6 down vote favorite 6 I am an absolute beginner to MySQL (5.5.34) / Linux (Ubuntu 12.04 LTS)` I have created a simple database with one table. When trying to import data into it via a 'data_test.csv file an error message 13 appears. Exert from Terminal follows: mysql> source /home/g/stockrecdb/load_test.sql; Database changed ERROR 13 (HY000): Can't get stat of '/home/stockrecdb/data_test.csv' (Errcode:
Error 2006 Hy000 Mysql
2) mysql> Note: if using LOCAL in LOAD DATA LOCAL INFILE an error appears: ERROR 1148 (42000): The used command is not allowed with this MySQL version mysql errors csv-file share|improve this question edited Jan 2 '14 at 5:50 asked Jan 2 '14 at 5:17 Guillermo 33114 add a comment| 2 Answers 2 active oldest votes up vote 14 down vote accepted I hope you are using LOAD DATA INFILE. Try to use LOAD DATA LOCAL INFILE instead of LOAD DATA INFILE. Other issue might be this, please visit the following links : MySQL LOAD DATA. When you login in MySQL do like below, abdul@xmpp3:~/Desktop/Jiva$ mysql -uroot -p --local-infile Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 257 Server version: 5.5.29-0ubuntu0.12.04.1-log (Ubuntu) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mydb; mysql> LOAD DATA LOCAL INFILE '/home/abdul/Desktop/STATISTIC_T.csv' INTO TABLE STATISTIC_T FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES; Now load your CSV using LOAD DATA LOCAL INFILE ,we need to use --local-infile before we load CSV in in new MySQL vesrsions, due to security re
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers error 1215 hy000 mysql or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask error 2013 hy000 mysql Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's how it
Error 2003 Hy000 Mysql Windows
works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL ERROR 13 (HY000) on database creation up vote 1 down vote favorite The full error is: MySQL ERROR 13 (HY000): http://dba.stackexchange.com/questions/55960/mysql-import-csv-file-error-13-hy000-cant-get-stat-of-path-file-csv-errcod Can't get stat of './databasename' (Errcode: 13 - Permission denied) I can't create databases in the mysql shell. I can log in as root just fine and I've granted all privileges to the root user, flushed privileges and exited/logged back in multiple times. Nothing seems to work. I'm on Ubuntu GNOME 15.04. This worked fine on 14.04, but I'd rather not downgrade if I don't have to. permissions mysql 15.04 share|improve this question edited May 5 '15 at 14:22 A.B. 47.6k896170 asked http://askubuntu.com/questions/618620/mysql-error-13-hy000-on-database-creation May 5 '15 at 14:00 daraul 95 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Wrong permissions, the server runs as mysql. Correct with: sudo chown -R mysql:mysql /var/lib/mysql/databasename example: % top -u mysql PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 15891 mysql 20 0 4472 1684 1536 S 0,0 0,0 0:00.00 mysqld_safe 16240 mysql 20 0 728684 117020 12068 S 0,0 2,9 0:00.38 mysqld share|improve this answer edited May 5 '15 at 14:18 answered May 5 '15 at 14:10 A.B. 47.6k896170 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged permissions mysql 15.04 or ask your own question. asked 1 year ago viewed 1529 times active 1 year ago Related 1MyISAM problem after moving datadir of a MySQL database2Error Updating MYSQL package3MySQL Installation Issues on Ubuntu 15.042MySQL Job cannot start - Can't find error, need database0How can I transfer the users from an old mysql install with having access to ONLY the physical files?0Unable to log in to Ubuntu after fixing MySql Upstart issue0Storing MySQL database in USB .. Permission problem (errno: 13)?1Mysql
Donovan Hsieh Email Updates: Status: Can't repeat Impact on me: None Category:MySQL Server: General Severity:S2 (Serious) Version:5.1.22-0 OS:Linux (Redhat EL4) Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [17 Oct https://bugs.mysql.com/bug.php?id=31670 2007 17:06] Donovan Hsieh Description: -bash-3.00$ ll /tmp/test.txt -rwxrwxrwx 1 mysql mysql 10180 Oct http://forums.mysql.com/read.php?60,98094,98094 17 09:37 /tmp/test.txt -bash-3.00$ mysql dars -uroot Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.1.22-rc-community MySQL Community Edition (GPL) Type 'help;' or hy000 mysql '\h' for help. Type '\c' to clear the buffer. mysql> load data infile '/tmp/test.txt' into table core_dars fields terminated by ','; ERROR 13 (HY000): Can't get stat of '/tmp/test.txt' (Errcode: 13) How to repeat: -bash-3.00$ ll /tmp/test.txt -rwxrwxrwx 1 mysql mysql 10180 Oct 17 09:37 /tmp/test.txt -bash-3.00$ mysql dars -uroot Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with error 13 hy000 -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.1.22-rc-community MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> load data infile '/tmp/test.txt' into table core_dars fields terminated by ','; ERROR 13 (HY000): Can't get stat of '/tmp/test.txt' (Errcode: 13) [17 Oct 2007 17:49] Miguel Solorzano Thank you for the bug report. That sounds as permission issue: [miguel@skybr 5.1]$ bin/perror 13 OS error code 13: Permission denied Please see: http://dev.mysql.com/doc/refman/5.1/en/load-data.html "For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege. See Section 5.7.3, “Privileges Provided by MySQL”." [17 Oct 2007 19:17] Donovan Hsieh As you can see from the screen capture text, the input file '/tmp/dars.txt' has rwxrwxrwx and it is located in /tmp directory. Also, I login as root from console shell and it has "GRANT FILE ON *.* TO `root`@`localhost`" privilege. I still think it is a BUG. [18 Oct 2007 8:17] Sveta Smirnova Thank you for the feedback. I can not repeat described behaviour in myself environment. Please provide output of
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Microsoft SQL Server :: Using LOAD DATA INFILE get error 13 (HY000) New Topic Advanced Search Using LOAD DATA INFILE get error 13 (HY000) Posted by: Rosa Morales () Date: June 22, 2006 02:28PM Hi, I am using a mysql server version: 5.0.22-max. I am trying to load data in a mysql table using: LOAD DATA INFILE 'Users/rosamorales/Documents/etc/1990list.txt' INTO TABLE first_list FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'; and I got the following error message: ERROR 13 (HY000): Can't get stat of '/usr/local/mysql/data/Users/rosamorales/Documents/etc/1990list.txt' (Errcode: 2) can someone help? Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Using LOAD DATA INFILE get error 13 (HY000) Rosa Morales 06/22/2006 02:28PM Re: Using LOAD DATA INFILE get error 13 (HY000) Bob Field 06/22/2006 02:55PM 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