Error 13 Hy000 At Line 1
Contents |
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 error 13 hy000 at line 1 can t get stat of about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users error 1 hy000 at line 1 can t create write to file Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping error 2006 hy000 at line 1 mysql server has gone away each other. Join them; it only takes a minute: Sign up ERROR 13 (HY000) at line 1: Can't get stat of (Errcode: 13) up vote 1 down vote favorite Via SSH client I tried to connect with mysql and
Error 1114 Hy000 At Line The Table Is Full
add a new database: mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "create database psa" and I get this message: ERROR 13 (HY000) at line 1: Can't get stat of './psa' (Errcode: 13) I tried this too: 1-mysql -uadmin -p'cat /etc/psa/.psa.shadow' and I am connected to mysql server but once I type: mysql> create database psa; I receive this message: ERROR 13 (HY000): Can't get stat of './psa' (Errcode: 13) How to add a database to mysql server? mysql share|improve mysql error code 13 permission denied this question asked Apr 4 '14 at 9:53 user2747249 Not fully sure but I'd dare say it's an OS permission error. Can your user read from /etc/psa? –Álvaro González Apr 4 '14 at 9:57 But why create database psa; fails cause the first commad mysql -uadmin -p'cat /etc/psa/.psa.shadow' works fine so this not a permission issue –user2747249 Apr 4 '14 at 10:13 add a comment| 2 Answers 2 active oldest votes up vote 8 down vote accepted The mysql (Errcode: 13) : ERROR 13 (HY000): Can't get stat of './database-name' means that mysqlserver have no permissions to access this database. How to fix it via ssh client? 1-Go to your mysql directory: cd /var/lib/mysql/ 2-Give the default permission to the required database so MYSQL server can access it: chown mysql:mysql database-name/ -R and done. but what if once I type SHOW databases;and get ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) that means MYSQL server have no permission to acces the whole mysql directory: cd /var/lib/ then chown mysql:mysql mysql/ -R share|improve this answer answered Apr 4 '14 at 10:37 user2747249 add a comment| up vote 0 down vote ERROR 13 (HY000): Can't get stat of 'filename' simply states that the "filename" is not accessible thus provide the privilege to the file 'Filename'. [shell]# cd /xyz/location of the file [shell]# chmod 777 'filename'
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 error 13 (hy000): can't get stat of (errcode: 2) developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Error Code: 1148. The Used Command Is Not Allowed With This Mysql Version
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them;
Error 1148 (42000): The Used Command Is Not Allowed With This Mysql Version
it only takes a minute: Sign up LOAD DATA INFILE Error Code : 13 up vote 37 down vote favorite 24 In my remote MySQL, when I try to execute this query, I am getting the MySQL Error Code http://stackoverflow.com/questions/22859409/error-13-hy000-at-line-1-cant-get-stat-of-errcode-13 : 13. Query - LOAD DATA INFILE '/httpdocs/.../.../testFile.csv' INTO TABLE table_temp FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\r \\n' (sku, qty); Error Code : 13 Can't get stat of '/httpdocs/.../.../testFile.csv' (Errcode: 2) a. The database userlogin has all the grant priviliges. CREATE USER 'userName'@'%' IDENTIFIED BY '************'; GRANT ALL PRIVILEGES ON * . * TO 'userName'@'%' IDENTIFIED BY '************' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; GRANT ALL PRIVILEGES ON `userName\_%` . * TO http://stackoverflow.com/questions/4215231/load-data-infile-error-code-13 'userName'@'%'; b. I have also set the file and folder permission to chmod 777 (rwxrwxrwx) using FTP Tool mysql file-io share|improve this question edited Dec 28 '15 at 16:42 Brian Tompsett - 汤莱恩 3,093122775 asked Nov 18 '10 at 13:27 user292049 3801613 You are saying is remote mysql, is the csv place into remote mysql? –ajreal Nov 18 '10 at 14:07 From MS Windows System using mysqlbench connected to the remote mysqldatabase. Yes, the csv file indeed resides in the remote Linux server. –user292049 Nov 18 '10 at 14:10 add a comment| 10 Answers 10 active oldest votes up vote 82 down vote I know that this post is old, but this still comes up in search results. I couldn't find the solution to this problem online, so I ended up figuring it out myself. If you're using Ubuntu, then there is a program called "Apparmor" that is preventing MySQL from seeing the file. Here's what you need to do if you want MySQL to be able to read files from the "tmp" directory: sudo vim /etc/apparmor.d/usr.sbin.mysqld Once you are in the file, you're going to see a bunch of directories that MySQL can use. Add the line /tmp/** rwk to the file (I am not sure that it matters where, but here is a sample of where I put it): /etc/mysql/*.pem r, /etc/mysql/conf.d/ r, /etc/mysql/conf.d/* r, /etc/mysql/*.cnf r, /usr/lib/mysql/plugin/ r, /usr/
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 http://askubuntu.com/questions/336205/loading-data-into-mysql-database hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's https://www.zabbix.com/forum/showthread.php?t=1897 how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Loading data into mysql database up vote 1 down vote favorite 2 I have a text file which error 1 i would want to load into mysql database on Ubuntu server 12.04 LTS. I have entered the data into the file trey.txt and i moved the file to /tmp directory. When i move to the db, and enter the command LOAD DATA INFILE '/tmp/trey.txt' into table arp_table columns terminated by '|'; the output is ERROR 13(HY000):Can't get stat of '/tmp/trey.txt'(Errcode: 2) How should i modify to enter these details. And can i run this from command line as a cron hy000 at line job. mysql cron share|improve this question asked Aug 23 '13 at 11:17 sosytee 1,32322038 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted The problem i was having was that for security reasons, local data offloading is disabled by default , and for the file to be read into the database, it must be enabled by starting mysql using mysql -uroot -ppassword --local-infile database This will solve the problem and you can insert from a text file. share|improve this answer answered Aug 26 '13 at 6:48 sosytee 1,32322038 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 0 down vote Put your data fine in root folder in ubuntu after that run this command as admin:- $ sudo mysql -u root -p
Posts Search Community Links Social Groups Pictures & Albums Members List Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page... Page 1 of 2 1 2 > Thread Tools Display Modes #1 04-01-2006, 16:57 breun Junior Member Join Date: Jan 2006 Location: Utrecht, The Netherlands Posts: 9 Can't load images into MySQL (ERROR 13: Can't get stat of ...) I'm trying to do a fresh install of Zabbix 1.1beta5. I've read through the forums, but still I had no luck loading the images into the MySQL database using images.sql. Here's what I did (I followed the instructions at http://www.zabbix.com/manual/v1.1/install_server.php): Create zabbix user: Code: # su - # useradd -m zabbix # passwd zabbix # su - zabbix Download zabbix 1.1beta5: Code: # wget http://surfnet.dl.sourceforge.net/sourceforge/zabbix/zabbix-1.1beta5.tar.gz # tar zxvf zabbix-1.1beta5.tar.gz # rm -f zabbix-1.1beta5.tar.gz # mv zabbix-1.1beta5 zabbix # cd zabbix Create database and load schema and data: Code: # mysql -uroot -p