subject:"error"

Hi gang,

Trying to generate a CSV file using mySQL and I keep getting this error below. 
The target folder has full permissions to write (777). I am not certain why 
this is happening. Any answers? Thanks!


Database_Class error: DATABASE_ERROR: Access denied for user 
'teal1dwd_teal'@'localhost' (using password: YES) IN [SELECT u.user_id, 
u.first_name AS u_first_name, 
u.last_name AS u_last_name,
c.client_id AS c_client_id,
c.first_name AS c_first_name,
c.middle_name AS c_middle_name,
c.last_name AS c_last_name,
c.address AS c_address,
c.city AS c_city,
c.state AS c_state,
c.zip AS c_zip,
c.dob AS dob_ymd,
c.phone_home AS c_phone_home,
c.phone_cell AS c_phone_cell,
c.phone_work AS c_phone_work,
c.email AS c_email,
c.other_contacts AS c_other_contacts,
count(*) as apt_qty

FROM tl_appt apt 

JOIN tl_clients c on c.client_id = apt.client_id 
JOIN tl_rooms r on r.room_id = apt.room_id
JOIN tl_users u on u.user_id = apt.user_id

WHERE 

apt.time_start between '1388552400' and '1420088399' 
and r.location_id = '1'

GROUP BY u.user_id, c.client_id 
having count(*)  1

ORDER BY u.first_name, u.last_name, c.last_name, c.first_name
INTO OUTFILE '/tmp/1_2031305738.csv' 
FIELDS TERMINATED BY ','
ENCLOSED BY '']


Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Reindl Harald



Am 19.09.2014 um 16:43 schrieb Don Wieland:
 Trying to generate a CSV file using mySQL and I keep getting this error 
 below. The target folder has full permissions to write (777). I am not 
 certain why this is happening. Any answers? Thanks!

the target folder don't matter
that is clearly a *MySQL error* that your *MYSQL user* lack the needed 
permissions

 Database_Class error: DATABASE_ERROR: Access denied for user 
 'teal1dwd_teal'@'localhost' (using password: YES) IN [SELECT u.user_id, 
 u.first_name AS u_first_name, 
 u.last_name AS u_last_name,
 c.client_id AS c_client_id,
 c.first_name AS c_first_name,
 c.middle_name AS c_middle_name,
 c.last_name AS c_last_name,
 c.address AS c_address,
 c.city AS c_city,
 c.state AS c_state,
 c.zip AS c_zip,
 c.dob AS dob_ymd,
 c.phone_home AS c_phone_home,
 c.phone_cell AS c_phone_cell,
 c.phone_work AS c_phone_work,
 c.email AS c_email,
 c.other_contacts AS c_other_contacts,
 count(*) as apt_qty
 
 FROM tl_appt apt 
 
 JOIN tl_clients c on c.client_id = apt.client_id 
 JOIN tl_rooms r on r.room_id = apt.room_id
 JOIN tl_users u on u.user_id = apt.user_id
 
 WHERE 
 
 apt.time_start between '1388552400' and '1420088399' 
 and r.location_id = '1'
 
 GROUP BY u.user_id, c.client_id 
 having count(*)  1
 
 ORDER BY u.first_name, u.last_name, c.last_name, c.first_name
 INTO OUTFILE '/tmp/1_2031305738.csv' 
 FIELDS TERMINATED BY ','
 ENCLOSED BY '']



signature.asc
Description: OpenPGP digital signature

Re: INTO OUTFILE ERROR...

On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:

 the target folder don't matter
 that is clearly a *MySQL error* that your *MYSQL user* lack the needed 
 permissions

Yes i figured that - so the question is, how do I give full permissions to that 
user?

I did go to my cPanel and delete the user and recreated the user adding them to 
the DB with ALL PRIVILEGES. Obviously this is not enough.

If this is not a simple thing that I can do myself, I am willing to compensate 
someone for support they can offer via GoToMeeting and SKYPE.

I am spinning my wheels and I need to resolve this issue asap.

Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Reindl Harald


Am 19.09.2014 um 16:59 schrieb Don Wieland:
 On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
 
 the target folder don't matter
 that is clearly a *MySQL error* that your *MYSQL user* lack the needed 
 permissions
 
 Yes i figured that - so the question is, how do I give full permissions to 
 that user?
 
 I did go to my cPanel and delete the user and recreated the user adding them 
 to the DB with ALL PRIVILEGES.
 Obviously this is not enough.

into outfile is *not* a db-specific permission

http://lmgtfy.com/?q=mysql+permissions+into+outfile
http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold



signature.asc
Description: OpenPGP digital signature

Re: INTO OUTFILE ERROR...

Thanks Reindl,

Yes I stubbled upon this page last night. I try running that query:

grant all privileges 
  on teal1dwd_teal.* 
  to 'teal1dwd_teal'@'localhost' 
  identified by 'my_user_pw';

I get this error:

#1044 - Access denied for user 'teal1dwd'@'localhost' to database 
'teal1dwd_teal'

Do I need to perform this query in a different place?  Sigh…

Don

On Sep 19, 2014, at 8:03 AM, Reindl Harald wrote:

 into outfile is *not* a db-specific permission
 
 http://lmgtfy.com/?q=mysql+permissions+into+outfile
 http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold

Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Christophe


Hi there,

Le 19/09/2014 17:19, Don Wieland a écrit :


grant all privileges
   on teal1dwd_teal.*
   to 'teal1dwd_teal'@'localhost'
   identified by 'my_user_pw';

I get this error:

#1044 - Access denied for user 'teal1dwd'@'localhost' to database 
'teal1dwd_teal'



I think you are trying to access the DB with the 'teal1dwd' user, but 
your grant applies to 'teal1dwd_teal'.


Hope this helps ;).

Regards,
Christophe.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Christophe


Le 19/09/2014 18:00, Christophe a écrit :

Hi there,

Le 19/09/2014 17:19, Don Wieland a écrit :


grant all privileges
   on teal1dwd_teal.*
   to 'teal1dwd_teal'@'localhost'
   identified by 'my_user_pw';

I get this error:

#1044 - Access denied for user 'teal1dwd'@'localhost' to database
'teal1dwd_teal'



I think you are trying to access the DB with the 'teal1dwd' user, but
your grant applies to 'teal1dwd_teal'.



I forgot to tell, that GRANT queries need to be performed by a user 
which has the GRANT privilege.


Don't you have root access to MySQL instance ?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: INTO OUTFILE ERROR...

On Sep 19, 2014, at 9:11 AM, Christophe wrote:

 Don't you have root access to MySQL instance ?

I guess not, I am using a managed server VPSLatch. I chatted with them and they 
are going to GRANT the permissions I need…at least that is what the tech said. 
I waiting with baited breath ;oP

Thanks!

Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Mogens Melander

Maybe you need to grant access from localhost to the user?

On Fri, September 19, 2014 16:59, Don Wieland wrote:
 On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:

 the target folder don't matter
 that is clearly a *MySQL error* that your *MYSQL user* lack the needed
 permissions

 Yes i figured that - so the question is, how do I give full permissions to
 that user?

 I did go to my cPanel and delete the user and recreated the user adding
 them to the DB with ALL PRIVILEGES. Obviously this is not enough.

 If this is not a simple thing that I can do myself, I am willing to
 compensate someone for support they can offer via GoToMeeting and SKYPE.

 I am spinning my wheels and I need to resolve this issue asap.

 Don Wieland
 d...@pointmade.net
 http://www.pointmade.net
 https://www.facebook.com/pointmade.band





 --
 This message has been scanned for viruses and
 dangerous content by MailScanner, and is
 believed to be clean.




-- 
Mogens Melander
+66 8701 33224


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

ERROR in syntax...

2014-09-06 Thread Don Wieland

Can anyone tell me why this query is generating an ERROR:

DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes;

CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes` 
AFTER INSERT ON `rtsadven_development`.`content_assets`
FOR EACH ROW 
BEGIN

IF NEW.content_asset_type_code = 'CURRI' THEN
   INSERT INTO curriculums (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'COURS' THEN
   INSERT INTO courses (content_asset_id) VALUES (NEW.id);
IF NEW.content_asset_type_code = 'DOC' THEN
   INSERT INTO documents (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'MODUL' THEN
   INSERT INTO modules (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'TOPIC' THEN
   INSERT INTO topics (content_asset_id) VALUES (NEW.id); 
ELSEIF NEW.content_asset_type_code = 'WEBPG' THEN
   INSERT INTO web_pages (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'EMAIL' THEN
   INSERT INTO emails (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'FBPOST' THEN
   INSERT INTO facebook_posts (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'TWEET' THEN
   INSERT INTO tweets (content_asset_id) VALUES (NEW.id); 
ELSEIF NEW.content_asset_type_code = 'CHALL' THEN
   INSERT INTO challenges (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'IMAGE' THEN
   INSERT INTO images (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'VIDEO' THEN
   INSERT INTO videos (content_asset_id) VALUES (NEW.id);
END IF;

INSERT INTO content_asset_statistics (content_asset_id, 
statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from 
content_asset_statistic_types where content_asset_type_code = 
NEW.content_asset_type_code;

END;

Appreciate it.

Don Wieland


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR in syntax...

2014-09-06 Thread hsv

 2014/09/06 09:06 -0700, Don Wieland 
Can anyone tell me why this query is generating an ERROR: 

Which error? The first IF statement is not properly ended? it isn't.

(A series of equality tests against the same variable is done more conveniently 
with CASE ... END CASE.) 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: 1045 Error accessing mysql db

2014-09-05 Thread wagnerbianchi.com

FYI

WB

2014-09-04 21:27 GMT-03:00 정천기 jeongcheo...@gmail.com:

 Hi~~
 I think this trouble because change OS and MySQL grant Initialization..

 Could you please follow my step...

 First.. check your (foo) grant

 root#] mysql -u root -p
 mysql  select * from mysql.user where 'foo';

 there is HOST column.
 HOST column values is '%'..  Must..

 if there is not, you must grant to 'foo'.

 mysql  grant all privileges on *.* to foo@% identified by '';
 mysql  flush privileges;

 Try Login~~

 Second.. Recreate user..

 root#] mysql -u root -p
 mysql  drop user foo;
 mysql  create user 'foo'@'%' IDENTIFIED by '';
 mysql  grant all privileges on *.* to foo@% identified by '';
 mysql  flush privileges;


 Try again Login~~

 My List is Here..

 Have a good day





 2014-09-05 0:54 GMT+09:00 wagnerbianchi.com m...@wagnerbianchi.com:

 Do you know if the Python version has changed? Do you know what was the
 Python version you used to develop your script on CentOS 5? So, If
 anything
 has changed in mysql.user table or even in `foo` user credentials, it
 seems
 that your script must be reviewed and even the Python version in use
 currently must be checked as well...could you let us now if you can log to
 MySQL using the mysql client?

 Something like:

 $ mysql -u foo -p

 Let us know, cheers!!



 --
 *Wagner Bianchi, MySQL Database Specialist*
 Mobile:  +55.31.8654.9510
 E-mail:  m...@wagnerbianchi.com
 Twitter: @wagnerbianchijr


 2014-09-04 11:05 GMT-03:00 Divesh Kamra kamra.div...@gmail.com:

  check weather there any space in localhost
  'localhost
  '
 
  Also check permission for 'foo' user though command
 
  select * from mysql.user where 'foo';
 
 
 
 
  On Thu, Aug 21, 2014 at 6:53 AM, Augori aug...@gmail.com wrote:
 
   After an operating system change (CentOS 5 to CentOS 6), my Python
 script
   could no longer connect with mysql database.  I get the following
  error...
  
   mysql_exceptions.OperationalError: (1045, Access denied for user
 'foo'@
   'localhost
   ' (using password: YES))
  
   I have granted all on all databases to this user.
   I attempted to run mysql_upgrade.
  
   I am stymied because according to another guy, he is successfully
  accessing
   the same database with the same credentials as I am (but in a PHP
  script).
  
   Can any of you suggest an explanation for this?
  
   Thanks in advance!
  
 




 --
 
 정천기  차장, Jeong Cheon Ki , 鄭 天 基
 Home : Seoul
 Mobile : 82(0)10.6261.5356
 E-mail : jeongcheo...@gmail.com
  MSN : jeongcheo...@hotmail.com

Re: Getting error while launching mysqld

2014-09-05 Thread wagnerbianchi.com

Have you changed the default mysqld port? Could you share with us the below
command output?

$ my_print_defaults mysqld



--
*Wagner Bianchi, MySQL Database Specialist*
Mobile:  +55.31.8654.9510
E-mail:  m...@wagnerbianchi.com
Twitter: @wagnerbianchijr


2014-09-04 4:33 GMT-03:00 Banerjee, Somnath somnath_baner...@mentor.com:

 Hi,

 We are getting following error while launching mysqld_safe in local
 machine.
 Any help would be appreciated.

 --
 connect to address 127.0.0.1 port 544: Connection refused
 connect to address 127.0.0.1 port 544: Connection refused

 trying normal rsh (/usr/bin/rsh)

 -

 The command used is:

 rsh $HOST -n mysql install dir/bin/mysqld_safe
 --defaults-file=$MYSQL_CONFIG --port=$PORT

RE: Getting error while launching mysqld

2014-09-05 Thread Banerjee, Somnath

Thanks a lot.
I changed rsh to ssh and things worked !

-somnath

From: shawn l.green [shawn.l.gr...@oracle.com]
Sent: Friday, September 05, 2014 8:21 PM
To: mysql@lists.mysql.com
Subject: Re: Getting error while launching mysqld

Hello Somnath,

On 9/4/2014 3:33 AM, Banerjee, Somnath wrote:
 Hi,

 We are getting following error while launching mysqld_safe in local machine.
 Any help would be appreciated.

 --
 connect to address 127.0.0.1 port 544: Connection refused
 connect to address 127.0.0.1 port 544: Connection refused

 trying normal rsh (/usr/bin/rsh)

 -

 The command used is:

 rsh $HOST -n mysql install dir/bin/mysqld_safe 
 --defaults-file=$MYSQL_CONFIG --port=$PORT

This looks more like a problem with your permissions to use the rsh
command than MySQL. MySQL should never operate on port 554 as that is
already reserved for a different well-known service.

--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Getting error while launching mysqld

2014-09-04 Thread Banerjee, Somnath

Hi,

We are getting following error while launching mysqld_safe in local machine.
Any help would be appreciated.

--
connect to address 127.0.0.1 port 544: Connection refused
connect to address 127.0.0.1 port 544: Connection refused

trying normal rsh (/usr/bin/rsh)

-

The command used is:

rsh $HOST -n mysql install dir/bin/mysqld_safe --defaults-file=$MYSQL_CONFIG 
--port=$PORT

Re: 1045 Error accessing mysql db

2014-09-04 Thread Divesh Kamra

check weather there any space in localhost
'localhost
'

Also check permission for 'foo' user though command

select * from mysql.user where 'foo';




On Thu, Aug 21, 2014 at 6:53 AM, Augori aug...@gmail.com wrote:

 After an operating system change (CentOS 5 to CentOS 6), my Python script
 could no longer connect with mysql database.  I get the following error...

 mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@
 'localhost
 ' (using password: YES))

 I have granted all on all databases to this user.
 I attempted to run mysql_upgrade.

 I am stymied because according to another guy, he is successfully accessing
 the same database with the same credentials as I am (but in a PHP script).

 Can any of you suggest an explanation for this?

 Thanks in advance!

Re: 1045 Error accessing mysql db

2014-09-04 Thread wagnerbianchi.com

Do you know if the Python version has changed? Do you know what was the
Python version you used to develop your script on CentOS 5? So, If anything
has changed in mysql.user table or even in `foo` user credentials, it seems
that your script must be reviewed and even the Python version in use
currently must be checked as well...could you let us now if you can log to
MySQL using the mysql client?

Something like:

$ mysql -u foo -p

Let us know, cheers!!



--
*Wagner Bianchi, MySQL Database Specialist*
Mobile:  +55.31.8654.9510
E-mail:  m...@wagnerbianchi.com
Twitter: @wagnerbianchijr


2014-09-04 11:05 GMT-03:00 Divesh Kamra kamra.div...@gmail.com:

 check weather there any space in localhost
 'localhost
 '

 Also check permission for 'foo' user though command

 select * from mysql.user where 'foo';




 On Thu, Aug 21, 2014 at 6:53 AM, Augori aug...@gmail.com wrote:

  After an operating system change (CentOS 5 to CentOS 6), my Python script
  could no longer connect with mysql database.  I get the following
 error...
 
  mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@
  'localhost
  ' (using password: YES))
 
  I have granted all on all databases to this user.
  I attempted to run mysql_upgrade.
 
  I am stymied because according to another guy, he is successfully
 accessing
  the same database with the same credentials as I am (but in a PHP
 script).
 
  Can any of you suggest an explanation for this?
 
  Thanks in advance!

1045 Error accessing mysql db

2014-08-20 Thread Augori

After an operating system change (CentOS 5 to CentOS 6), my Python script
could no longer connect with mysql database.  I get the following error...

mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@
'localhost
' (using password: YES))

I have granted all on all databases to this user.
I attempted to run mysql_upgrade.

I am stymied because according to another guy, he is successfully accessing
the same database with the same credentials as I am (but in a PHP script).

Can any of you suggest an explanation for this?

Thanks in advance!

sql syntax error

2014-08-08 Thread florent larose

hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my 
system : windows 7 / wampserver 2).
i have a bug when i am running my connection to database webpage.
My error message is the following :
Erreur SQL : You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use 
near ''membres2' WHERE
'pseudo_membre' = '\'Flarose59\'' GROUP BY 
'id_membre'' at line 1 
Ligne : 29.

this is my php code :
 $result = sqlquery(SELECT COUNT('id_membre') AS nbr, 'id_membre', 
'pseudo_membre', 'mdp_membre' FROM 'espace_membre2'.'membres2' WHERE 
'pseudo_membre' = '\'.mysql_real_escape_string($_POST['pseudo']).\'' GROUP BY 
'id_membre', 1);

I tried several delimitator for the query function (like ' \* ').

Re: sql syntax error

2014-08-08 Thread Johan De Meersman

- Original Message -
 From: florent larose florent.lar...@hotmail.com
 Subject: sql syntax error

 near ''membres2' WHERE
 [...]
  FROM 'espace_membre2'.'membres2' WHERE

You were on the right path - mysql is wibbly about quotes. Either remove the 
quotes entirely ( espace_membre2.membres2 ) or try backticks ( ` ). They're 
MySQL's favourite quote, presumably because they were convenient to type on 
whatever abomination Monty used to type code :-)

As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr 
plus the rightmost key (right next to return) on the middle row. Enjoy 
spraining your fingers :-p

/johan

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: sql syntax error

2014-08-08 Thread Christophe

Hi,

Le 08/08/2014 17:48, Johan De Meersman a écrit :
 
 As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr 
 plus the rightmost key (right next to return) on the middle row. Enjoy 
 spraining your fingers :-p
 
 /johan
 

Alt-GR plus '7' for French keyboard layout ;)


Christophe.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

alter table modify syntax error

Hello,

I'm trying to use a very basic alter table command to position a column
after another column.

This is the table as it exists now:

mysql describe car_table;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| car_id | int(11) | NO | PRI | NULL | auto_increment |
| vin | varchar(17) | YES | | NULL | |
| color | varchar(10) | YES | | NULL | |
| year | decimal(4,0) | YES | | NULL | |
| make | varchar(10) | YES | | NULL | |
| model | varchar(20) | YES | | NULL | |
| howmuch | decimal(5,2) | YES | | NULL | |
+-+--+--+-+-++
7 rows in set (0.03 sec)

I am trying to position the 'color' column after the 'model' column with
the following command:

mysql alter table car_table modify column color after model;

And I'm getting the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'after model' at line 1


I'm just wondering what I'm doing wrong here, because the syntax looks
correct to me!

Thanks

-- 
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

Re: alter table modify syntax error

2014-06-28 Thread Carsten Pedersen


On 28-06-2014 19:11, Tim Dunphy wrote:

Hello,

I'm trying to use a very basic alter table command to position a column
after another column.

This is the table as it exists now:

mysql describe car_table;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| car_id | int(11) | NO | PRI | NULL | auto_increment |
| vin | varchar(17) | YES | | NULL | |
| color | varchar(10) | YES | | NULL | |
| year | decimal(4,0) | YES | | NULL | |
| make | varchar(10) | YES | | NULL | |
| model | varchar(20) | YES | | NULL | |
| howmuch | decimal(5,2) | YES | | NULL | |
+-+--+--+-+-++
7 rows in set (0.03 sec)

I am trying to position the 'color' column after the 'model' column with
the following command:

mysql alter table car_table modify column color after model;

And I'm getting the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'after model' at line 1


Try:
alter table car_table modify column color varchar(10) after model;

/ Carsten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: alter table modify syntax error

Cool guys, that did it..

ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model;

For some reason the book I'm following doesn't specify that you have to
note the data type in moves! This helped. and thanks again.

Tim


On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen cars...@bitbybit.dk
wrote:

 On 28-06-2014 19:11, Tim Dunphy wrote:

 Hello,

 I'm trying to use a very basic alter table command to position a column
 after another column.

 This is the table as it exists now:

 mysql describe car_table;
 +-+--+--+-+-++
 | Field | Type | Null | Key | Default | Extra |
 +-+--+--+-+-++
 | car_id | int(11) | NO | PRI | NULL | auto_increment |
 | vin | varchar(17) | YES | | NULL | |
 | color | varchar(10) | YES | | NULL | |
 | year | decimal(4,0) | YES | | NULL | |
 | make | varchar(10) | YES | | NULL | |
 | model | varchar(20) | YES | | NULL | |
 | howmuch | decimal(5,2) | YES | | NULL | |
 +-+--+--+-+-++
 7 rows in set (0.03 sec)

 I am trying to position the 'color' column after the 'model' column with
 the following command:

 mysql alter table car_table modify column color after model;

 And I'm getting the following error:

 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
 that corresponds to your MySQL server version for the right syntax to use
 near 'after model' at line 1


 Try:
 alter table car_table modify column color varchar(10) after model;

 / Carsten

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql




-- 
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

Re: alter table modify syntax error

Hey guys,

 Sorry to hit you with one more. But I'm trying to use a positional
statement in a column move based on what you all just taught me:

mysql alter table modify column color varchar(10) sixth;

But I am getting this error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'column color varchar(10) sixth' at line 1

Here's my table one more time for reference:

mysql describe car_table;
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra  |
++--+--+-+-++
| car_id | int(11)  | NO   | PRI | NULL| auto_increment |
| vin| varchar(17)  | YES  | | NULL||
| year   | decimal(4,0) | YES  | | NULL||
| make   | varchar(10)  | YES  | | NULL||
| model  | varchar(20)  | YES  | | NULL||
| color  | varchar(10)  | YES  | | NULL||
| price  | decimal(7,2) | YES  | | NULL||
++--+--+-+-++
7 rows in set (0.01 sec)

I appreciate your suggestions so far and it would be great if I could get
some help with this one too.

Thanks
Tim


On Sat, Jun 28, 2014 at 1:34 PM, Tim Dunphy bluethu...@gmail.com wrote:

 Cool guys, that did it..

 ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model;

 For some reason the book I'm following doesn't specify that you have to
 note the data type in moves! This helped. and thanks again.

 Tim


 On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen cars...@bitbybit.dk
 wrote:

 On 28-06-2014 19:11, Tim Dunphy wrote:

 Hello,

 I'm trying to use a very basic alter table command to position a column
 after another column.

 This is the table as it exists now:

 mysql describe car_table;
 +-+--+--+-+-++
 | Field | Type | Null | Key | Default | Extra |
 +-+--+--+-+-++
 | car_id | int(11) | NO | PRI | NULL | auto_increment |
 | vin | varchar(17) | YES | | NULL | |
 | color | varchar(10) | YES | | NULL | |
 | year | decimal(4,0) | YES | | NULL | |
 | make | varchar(10) | YES | | NULL | |
 | model | varchar(20) | YES | | NULL | |
 | howmuch | decimal(5,2) | YES | | NULL | |
 +-+--+--+-+-++
 7 rows in set (0.03 sec)

 I am trying to position the 'color' column after the 'model' column with
 the following command:

 mysql alter table car_table modify column color after model;

 And I'm getting the following error:

 ERROR 1064 (42000): You have an error in your SQL syntax; check the
 manual
 that corresponds to your MySQL server version for the right syntax to use
 near 'after model' at line 1


 Try:
 alter table car_table modify column color varchar(10) after model;

 / Carsten

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql




 --
 GPG me!!

 gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B




-- 
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

RE: alter table modify syntax error

2014-06-28 Thread Jesper Wisborg Krogh

Hi Tim,

 -Original Message-
 From: Tim Dunphy [mailto:bluethu...@gmail.com]
 Sent: Sunday, 29 June 2014 03:45
 Cc: mysql@lists.mysql.com
 Subject: Re: alter table modify syntax error

 Hey guys,

  Sorry to hit you with one more. But I'm trying to use a positional statement
 in a column move based on what you all just taught me:

 mysql alter table modify column color varchar(10) sixth;

 But I am getting this error:

 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
 that corresponds to your MySQL server version for the right syntax to use
 near 'column color varchar(10) sixth' at line 1

The syntax sixth is not a supported syntax. You should use the syntax AFTER 
column_name where you replace column_name with the column name you want to 
position the modified column after.

See also: https://dev.mysql.com/doc/refman/5.5/en/alter-table.html

Best regards,
Jesper Krogh
MySQL Support

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: alter table modify syntax error

The syntax sixth is not a supported syntax. You should use the syntax
AFTER column_name where you replace column_name with the column name
you want to position the modified column after.

Oh thanks. That's actually what I ended up doing after I got frustrated
with that error. I was following the book 'Head First SQL' which was
suggesting that you could do something like what this user was trying in
this stack overflow thread:

http://stackoverflow.com/questions/19175240/re-arranging-columns-in-mysql-using-position-keywords-such-as-first-second

But the answer in that thread too suggests that this is wrong. So is the
Head First SQL book just referring to an outdated syntax that doesn't work
anymore? I can't imagine that it never worked if it's in that book. But hey
ya never know! ;)

Thanks
Tim

On Sat, Jun 28, 2014 at 7:46 PM, Jesper Wisborg Krogh my...@wisborg.dk
wrote:

Hi Tim,

-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 03:45
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error

Hey guys,

Sorry to hit you with one more. But I'm trying to use a positional
statement
in a column move based on what you all just taught me:

mysql alter table modify column color varchar(10) sixth;

But I am getting this error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual
that corresponds to your MySQL server version for the right syntax to use
near 'column color varchar(10) sixth' at line 1

The syntax sixth is not a supported syntax. You should use the syntax
AFTER column_name where you replace column_name with the column name
you want to position the modified column after.

See also: https://dev.mysql.com/doc/refman/5.5/en/alter-table.html

Best regards,
Jesper Krogh
MySQL Support

--
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

RE: alter table modify syntax error

2014-06-28 Thread Jesper Wisborg Krogh

Hi Tim,

 -Original Message-
 From: Tim Dunphy [mailto:bluethu...@gmail.com]
 Sent: Sunday, 29 June 2014 10:09
 To: Jesper Wisborg Krogh
 Cc: mysql@lists.mysql.com
 Subject: Re: alter table modify syntax error

  The syntax sixth is not a supported syntax. You should use the
  syntax AFTER column_name where you replace column_name with
 the
  column name you want to position the modified column after.

 Oh thanks. That's actually what I ended up doing after I got frustrated with
 that error.  I was following the book 'Head First SQL' which was suggesting
 that you could do something like what this user was trying in this stack
 overflow thread:

 http://stackoverflow.com/questions/19175240/re-arranging-columns-in-
 mysql-using-position-keywords-such-as-first-second

 But the answer in that thread too suggests that this is wrong. So is the Head
 First SQL book just referring to an outdated syntax that doesn't work
 anymore? I can't imagine that it never worked if it's in that book. But hey ya
 never know! ;)

Given the title of the book is Head First SQL and not Head First MySQL it 
probably isn't exclusively using syntax for MySQL. While SQL is a standard the 
various SQL databases are not completely identical with the syntax they 
support. This may be due to not completely conforming to the standard, using 
different versions of the SQL standard, or that there is not standard for that 
operation.

Best regards,
Jesper Krogh
MySQL Support

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: alter table modify syntax error


 Given the title of the book is Head First SQL and not Head First MySQL
 it probably isn't exclusively using syntax for MySQL. While SQL is a
 standard the various SQL databases are not completely identical with the
 syntax they support. This may be due to not completely conforming to the
 standard, using different versions of the SQL standard, or that there is
 not standard for that operation.


Hey, that's some good input. Thanks and makes total sense. I guess the
reason I thought I could use that syntax is that the book uses MySQL for
all it's examples and explains that it does so because MySQL is a free and
open source version of SQL that's easy to install. But maybe you're right
and they do depart into other syntaxes of SQL. I just don't know where they
got that 'first, second, third, etc' version of the alter table syntax
from. Definitely not sweatin' this detail tho, I am totally fine with what
you showed me that works.

Thanks again for your input!
Tim


On Sat, Jun 28, 2014 at 9:14 PM, Jesper Wisborg Krogh my...@wisborg.dk
wrote:

 Hi Tim,

  -Original Message-
  From: Tim Dunphy [mailto:bluethu...@gmail.com]
  Sent: Sunday, 29 June 2014 10:09
  To: Jesper Wisborg Krogh
  Cc: mysql@lists.mysql.com
  Subject: Re: alter table modify syntax error
 
  
   The syntax sixth is not a supported syntax. You should use the
   syntax AFTER column_name where you replace column_name with
  the
   column name you want to position the modified column after.
 
 
  Oh thanks. That's actually what I ended up doing after I got frustrated
 with
  that error.  I was following the book 'Head First SQL' which was
 suggesting
  that you could do something like what this user was trying in this stack
  overflow thread:
 
  http://stackoverflow.com/questions/19175240/re-arranging-columns-in-
  mysql-using-position-keywords-such-as-first-second
 
  But the answer in that thread too suggests that this is wrong. So is the
 Head
  First SQL book just referring to an outdated syntax that doesn't work
  anymore? I can't imagine that it never worked if it's in that book. But
 hey ya
  never know! ;)

 Given the title of the book is Head First SQL and not Head First MySQL
 it probably isn't exclusively using syntax for MySQL. While SQL is a
 standard the various SQL databases are not completely identical with the
 syntax they support. This may be due to not completely conforming to the
 standard, using different versions of the SQL standard, or that there is
 not standard for that operation.

 Best regards,
 Jesper Krogh
 MySQL Support





-- 
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

Re: error 29, file not found (errcode: 13)

2014-06-25 Thread thufir

I followed the manpage for mysqlimport:


thufir@dur:~$ 
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using 
password: NO)
thufir@dur:~$ 
thufir@dur:~$ 
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test 
-u root -p
Enter password: 
ERROR 1049 (42000): Unknown database 'test'
thufir@dur:~$ 
thufir@dur:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 54
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, 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 create database test;
Query OK, 1 row affected (0.01 sec)

mysql quit
Bye
thufir@dur:~$ 
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test 
-u root -p
Enter password: 
thufir@dur:~$ 
thufir@dur:~$ ed
a
100 Max Sydow
101 Count Dracula
.
w imptest.txt
32
q
thufir@dur:~$ 
thufir@dur:~$ od -c imptest.txt 
000   1   0   0  \t   M   a   x   S   y   d   o   w  \n   1   0
020   1  \t   C   o   u   n   t   D   r   a   c   u   l   a  \n
040
thufir@dur:~$ 
thufir@dur:~$ mysqlimport --local test imptest.txt -u root -p
Enter password: 
test.imptest: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
thufir@dur:~$ 
thufir@dur:~$ mysql -e 'SELECT * FROM imptest' test -u root -p
Enter password: 
+--+---+
| id   | n |
+--+---+
|  100 | Max Sydow |
|  101 | Count Dracula |
+--+---+
thufir@dur:~$ 
thufir@dur:~$ 


so this looks like the route to go.



-Thufir


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: error 29, file not found (errcode: 13)

2014-06-24 Thread Reindl Harald



Am 24.06.2014 07:08, schrieb thufir:
 On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote:
 
 I generally drop them into /tmp for easy access and cleanup after the
 data load, but you can put them any place that the mysql daemon process
 has access to read.
 
 Huh, maybe the daemon doesn't have access to /tmp?...
 ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13)

then file not found is bullshit

these days computers can distinguish between
not exist and no permissions and should reflect
that in the messages they give to humans



signature.asc
Description: OpenPGP digital signature

Re: error 29, file not found (errcode: 13)

2014-06-24 Thread thufir

I think it's apparmor:


thufir@dur:/tmp$ 
thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld
 1  # vim:syntax=apparmor
 2  # Last Modified: Tue Jun 19 17:37:30 2007
 3  #include tunables/global
   
 4  /usr/sbin/mysqld {
 5#include abstractions/base
 6#include abstractions/nameservice
 7#include abstractions/user-tmp
 8#include abstractions/mysql
 9#include abstractions/winbind
   
10capability dac_override,
11capability sys_resource,
12capability setgid,
13capability setuid,
   
14network tcp,
   
15/etc/hosts.allow r,
16/etc/hosts.deny r,
   
17/etc/mysql/*.pem r,
18/etc/mysql/conf.d/ r,
19/etc/mysql/conf.d/* r,
20/etc/mysql/*.cnf r,
21/usr/lib/mysql/plugin/ r,
22/usr/lib/mysql/plugin/*.so* mr,
23/usr/sbin/mysqld mr,
24/usr/share/mysql/** r,
25/var/log/mysql.log rw,
26/var/log/mysql.err rw,
27/var/lib/mysql/ r,
28/var/lib/mysql/** rwk,
29/var/log/mysql/ r,
30/var/log/mysql/* rw,
31/var/run/mysqld/mysqld.pid rw,
32/var/run/mysqld/mysqld.sock w,
33/run/mysqld/mysqld.pid rw,
34/run/mysqld/mysqld.sock w,
   
35/sys/devices/system/cpu/ r,
   
36# Site-specific additions and overrides. See local/README for 
details.
37#include local/usr.sbin.mysqld
38  }
thufir@dur:/tmp$ 



I need to grant access to /tmp somehow?



thanks,

Thufir


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

error 29, file not found (errcode: 13)

2014-06-23 Thread thufir

Apparently this error is because MySQL can't read my home directory?  
Fair enough, but I don't quite follow.  Where would be a good location 
for the CSV file, then?


   thufir@dur:~$
   thufir@dur:~$ mysql -u root -p
   Enter password:
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 62
   Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
   Copyright (c) 2000, 2014, 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
   mysql LOAD DATA  INFILE '/home/thufir/make_year_model.csv' INTO
   TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
   '\n';
   ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
   (Errcode: 13)
   mysql
   mysql quit
   Bye
   thufir@dur:~$
   thufir@dur:~$ cat /home/thufir/make_year_model.csv
   make1,model1,2012,604,buy now
   make2,model2,2013,780,need to sell
   make3,model3,2001,780,cheap
   thufir@dur:~$



thanks,

Thufir

Re: error 29, file not found (errcode: 13)

2014-06-23 Thread Scott Helms

I generally drop them into /tmp for easy access and cleanup after the data
load, but you can put them any place that the mysql daemon process has
access to read.


Scott Helms
Vice President of Technology
ZCorum
(678) 507-5000

http://twitter.com/kscotthelms



On Mon, Jun 23, 2014 at 10:52 AM, thufir hawat.thu...@gmail.com wrote:

 Apparently this error is because MySQL can't read my home directory?  Fair
 enough, but I don't quite follow.  Where would be a good location for the
 CSV file, then?

thufir@dur:~$
thufir@dur:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, 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
mysql LOAD DATA  INFILE '/home/thufir/make_year_model.csv' INTO
TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir@dur:~$ cat /home/thufir/make_year_model.csv
make1,model1,2012,604,buy now
make2,model2,2013,780,need to sell
make3,model3,2001,780,cheap
thufir@dur:~$



 thanks,

 Thufir

Re: error 29, file not found (errcode: 13)

2014-06-23 Thread Michael Dykman

Often, one uses /tmp or set up an appropriately premoissioned folder under /var

On Mon, Jun 23, 2014 at 10:52 AM, thufir hawat.thu...@gmail.com wrote:
 Apparently this error is because MySQL can't read my home directory?  Fair
 enough, but I don't quite follow.  Where would be a good location for the
 CSV file, then?

thufir@dur:~$
thufir@dur:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, 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
mysql LOAD DATA  INFILE '/home/thufir/make_year_model.csv' INTO
TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir@dur:~$ cat /home/thufir/make_year_model.csv
make1,model1,2012,604,buy now
make2,model2,2013,780,need to sell
make3,model3,2001,780,cheap
thufir@dur:~$



 thanks,

 Thufir




-- 
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: error 29, file not found (errcode: 13)

2014-06-23 Thread Carsten Pedersen

Or use the LOCAL diective to have the client send the csv file contents 
to the server.


/ Carsten


On 23-06-2014 16:59, Scott Helms wrote:

I generally drop them into /tmp for easy access and cleanup after the data
load, but you can put them any place that the mysql daemon process has
access to read.


Scott Helms
Vice President of Technology
ZCorum
(678) 507-5000

http://twitter.com/kscotthelms



On Mon, Jun 23, 2014 at 10:52 AM, thufir hawat.thu...@gmail.com wrote:


Apparently this error is because MySQL can't read my home directory?  Fair
enough, but I don't quite follow.  Where would be a good location for the
CSV file, then?

thufir@dur:~$
thufir@dur:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, 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
mysql LOAD DATA  INFILE '/home/thufir/make_year_model.csv' INTO
TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir@dur:~$ cat /home/thufir/make_year_model.csv
make1,model1,2012,604,buy now
make2,model2,2013,780,need to sell
make3,model3,2001,780,cheap
thufir@dur:~$



thanks,

Thufir






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: error 29, file not found (errcode: 13)

2014-06-23 Thread Divesh Kamra

Sol :- 
Change file owner to mysql.mysql 
  OR
Change folder and file mode to 777


DK Sent from Phone

 On 23-Jun-2014, at 8:22 pm, thufir hawat.thu...@gmail.com wrote:
 
 Apparently this error is because MySQL can't read my home directory?  Fair 
 enough, but I don't quite follow.  Where would be a good location for the CSV 
 file, then?
 
   thufir@dur:~$
   thufir@dur:~$ mysql -u root -p
   Enter password:
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 62
   Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
   Copyright (c) 2000, 2014, 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
   mysql LOAD DATA  INFILE '/home/thufir/make_year_model.csv' INTO
   TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
   '\n';
   ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
   (Errcode: 13)
   mysql
   mysql quit
   Bye
   thufir@dur:~$
   thufir@dur:~$ cat /home/thufir/make_year_model.csv
   make1,model1,2012,604,buy now
   make2,model2,2013,780,need to sell
   make3,model3,2001,780,cheap
   thufir@dur:~$
 
 
 
 thanks,
 
 Thufir
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: error 29, file not found (errcode: 13)

2014-06-23 Thread thufir

On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote:

 I generally drop them into /tmp for easy access and cleanup after the
 data load, but you can put them any place that the mysql daemon process
 has access to read.


Huh, maybe the daemon doesn't have access to /tmp?...

thufir@dur:/tmp$ 
thufir@dur:/tmp$ ll /tmp/make_year_model.csv 
-rw-rw-r-- 1 thufir thufir 83 Jun 23 22:04 /tmp/make_year_model.csv
thufir@dur:/tmp$ 
thufir@dur:/tmp$ nl /tmp/make_year_model.csv 
   
 1  make1,model1,2012,123,red
 2  make2,model2,2013,456,blue
 3  make3,model3,2001,789,green
   
thufir@dur:/tmp$ 
thufir@dur:/tmp$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, 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 
mysql LOAD DATA  INFILE '/tmp/make_year_model.csv' INTO TABLE 
vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13)
mysql 
mysql quit
Bye
thufir@dur:/tmp$ 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL UUID_SHORT() gives error Out of range value for column

2014-06-21 Thread Roberta Jaskolski

 2014/06/20 11:31 +0100, Neil Tompkins 
I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT
UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For
example the number I get is

12057145185130250250 

help uuid_short

Name: 'UUID_SHORT'
Description:
Syntax:
UUID_SHORT()

Returns a short universal identifier as a 64-bit unsigned integer
(rather than a string-form 128-bit identifier as returned by the UUID()
function).


That is one bit longer than you are aiming for.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

MySQL UUID_SHORT() gives error Out of range value for column

2014-06-20 Thread Neil Tompkins

Hi,

I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT
UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For
example the number I get is

12057145185130250250

The problem is in my table I have a column as BIGINT(20) unsigned, but when
storing a number 12057145185130250250 I get the error MySQL 22003

'MySQL 22003 Out of range value for column '' at row 1'

If I run SELECT UUID_SHORT() on our test server which is MySQL 5.6.11
(running on Windows 2008 64x) the result is as follows;

23526798209843216

I changed the column I'm trying to save my number to, as BIGINT(20)
unsigned, but still get this error.

Any ideas why ?

Cheers
Neil

Re: mysql Access denied error

2014-05-09 Thread Divesh Kamra

Edward , use following way

mysql -uroot -p -h{host ip }

else  give grant  privileges to localhost



On Mon, May 5, 2014 at 7:47 AM, EdwardKing zhan...@neusoft.com wrote:

 I use mysql to create a database and grant rights to a user
 hadooptest,then I use hadooptest to login mysql and use the database,but it
 failed. Why raise error after I grant rights? How to solve it? Thanks.

 My operation is follows:

 [hadoop@master ~]$ mysql -h localhost -u root -p
 Enter password:
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 3
 Server version: 5.5.37-log MySQL Community Server (GPL)

 Copyright (c) 2000, 2014, 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 create database hadooptest;
 mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by
 '123456';
 Query OK, 0 rows affected (0.00 sec)

 mysql flush priviledges;
 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
 that corresponds to your MySQL server version for the right syntax to use
 near 'priviledges' at line 1
 mysql flush privileges;
 Query OK, 0 rows affected (0.00 sec)

 mysql quit;
 Bye

 Then I use hadoopuser  with password 123456
 [hadoop@master ~]$ mysql -u hadoopuser -p
 Enter password:
 ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost'
 (using password: YES)



 ---
 Confidentiality Notice: The information contained in this e-mail and any
 accompanying attachment(s)
 is intended only for the use of the intended recipient and may be
 confidential and/or privileged of
 Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader
 of this communication is
 not the intended recipient, unauthorized use, forwarding, printing,
  storing, disclosure or copying
 is strictly prohibited, and may be unlawful.If you have received this
 communication in error,please
 immediately notify the sender by return e-mail, and delete the original
 message and all copies from
 your system. Thank you.

 ---

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui

2014-05-05 4:17 GMT+02:00 EdwardKing zhan...@neusoft.com:

 I use mysql to create a database and grant rights to a user
 hadooptest,then I use hadooptest to login mysql and use the database,but it
 failed. Why raise error after I grant rights? How to solve it? Thanks.

 My operation is follows:

 [hadoop@master ~]$ mysql -h localhost -u root -p
 Enter password:
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 3
 Server version: 5.5.37-log MySQL Community Server (GPL)

 Copyright (c) 2000, 2014, 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 create database hadooptest;
 mysql grant all on hadooptest.* to 'hadoopuser'@'%' identified by
 '123456';
 Query OK, 0 rows affected (0.00 sec)

 mysql flush priviledges;
 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
 that corresponds to your MySQL server version for the right syntax to use
 near 'priviledges' at line 1
 mysql flush privileges;
 Query OK, 0 rows affected (0.00 sec)

 mysql quit;
 Bye

 Then I use hadoopuser  with password 123456
 [hadoop@master ~]$ mysql -u hadoopuser -p
 Enter password:
 ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost'
 (using password: YES)



Hello,

I assume MySQL is listening in 3306 so:
Try this:  mysql -u hadoopuser -plocalhost (or 127.0.0.1)

% doesn't match localhost so if you don't specify it you will be
attempting to connect via Unix Socket.
If you don't want to specify -hlocalhost all the time, just do the grant
with @localhost instead of @%

Hope this helps
Manuel.

Re: mysql Access denied error



Am 05.05.2014 08:34, schrieb Manuel Arostegui:
 % doesn't match localhost so if you don't specify it you will be
 attempting to connect via Unix Socket.
 If you don't want to specify -hlocalhost all the time, just do the grant
 with @localhost instead of @%

nonsense

% matches *any host*



signature.asc
Description: OpenPGP digital signature

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui

2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net:



 Am 05.05.2014 08:34, schrieb Manuel Arostegui:
  % doesn't match localhost so if you don't specify it you will be
  attempting to connect via Unix Socket.
  If you don't want to specify -hlocalhost all the time, just do the grant
  with @localhost instead of @%

 nonsense

 % matches *any host*


Do the test yourself.

Re: mysql Access denied error



Am 05.05.2014 10:19, schrieb Manuel Arostegui:
 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net 
 mailto:h.rei...@thelounge.net:
 
 Am 05.05.2014 08:34, schrieb Manuel Arostegui:
  % doesn't match localhost so if you don't specify it you will be
  attempting to connect via Unix Socket.
  If you don't want to specify -hlocalhost all the time, just do the grant
  with @localhost instead of @%
 
 nonsense
 
 % matches *any host*
 
 Do the test yourself

i don't need to test such basics since i am working
as mysql administrator the last 11 years and curently
responsible for some hundret databases heavily using
host specific permissions

http://dev.mysql.com/doc/refman/5.5/en/connection-access.html
'%' 'fred'  fred, connecting from any host



signature.asc
Description: OpenPGP digital signature

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui

2014-05-05 10:57 GMT+02:00 Reindl Harald h.rei...@thelounge.net:



 Am 05.05.2014 10:19, schrieb Manuel Arostegui:
  2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.netmailto:
 h.rei...@thelounge.net:
 
  Am 05.05.2014 08:34, schrieb Manuel Arostegui:
   % doesn't match localhost so if you don't specify it you will be
   attempting to connect via Unix Socket.
   If you don't want to specify -hlocalhost all the time, just do the
 grant
   with @localhost instead of @%
 
  nonsense
 
  % matches *any host*
 
  Do the test yourself

 i don't need to test such basics since i am working
 as mysql administrator the last 11 years and curently
 responsible for some hundret databases heavily using
 host specific permissions


Good for you.
I might be working somewhere bigger than that.

Here is what I am talking about:


mysql  grant all on hadooptest.* to 'hadoopuser'@'%' identified by
'123456'; flush privileges;
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

mysql


# mysql -uhadoopuser -p123456
ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using
password: YES)

# mysql -uhadoopuser -p123456 -hlocalhost
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 392245
snip


---


mysql drop user 'hadoopuser'@'%'; flush privileges;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql  grant all on hadooptest.* to 'hadoopuser'@'localhost' identified by
'123456'; flush privileges;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

# mysql -uhadoopuser -p123456
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 392191
snip


I have been reading your impoliteness in this list for years. You are well
known in this (and other) lists for being like that. So I am not going to
start a fight over the list and this will be my last message in this thread.
Hopefully I have helped the original poster with my point.

Good luck with your hundreds of databases.

Manuel.

Re: mysql Access denied error

2014-05-05 Thread Jigal van Hemert


Hi,

On 5-5-2014 10:57, Reindl Harald wrote:



Am 05.05.2014 10:19, schrieb Manuel Arostegui:

2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net 
mailto:h.rei...@thelounge.net:

 Am 05.05.2014 08:34, schrieb Manuel Arostegui:
  % doesn't match localhost so if you don't specify it you will be
  attempting to connect via Unix Socket.
  If you don't want to specify -hlocalhost all the time, just do the grant
  with @localhost instead of @%

 nonsense

 % matches *any host*

Do the test yourself


i don't need to test such basics since i am working
as mysql administrator the last 11 years and curently
responsible for some hundret databases heavily using
host specific permissions

http://dev.mysql.com/doc/refman/5.5/en/connection-access.html
'%' 'fred'  fred, connecting from any host


In that case you would know that connecting via a Unix socket is not the 
same as connection via a network.


See:
http://bugs.mysql.com/bug.php?id=69570
http://dev.mysql.com/doc/refman/5.5/en/connecting.html


--
Kind regards / met vriendelijke groet,

Jigal van Hemert.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysql Access denied error



Am 05.05.2014 11:12, schrieb Jigal van Hemert:
 On 5-5-2014 10:57, Reindl Harald wrote:


 Am 05.05.2014 10:19, schrieb Manuel Arostegui:
 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net 
 mailto:h.rei...@thelounge.net:

  Am 05.05.2014 08:34, schrieb Manuel Arostegui:
   % doesn't match localhost so if you don't specify it you will be
   attempting to connect via Unix Socket.
   If you don't want to specify -hlocalhost all the time, just do the 
 grant
   with @localhost instead of @%

  nonsense

  % matches *any host*

 Do the test yourself

 i don't need to test such basics since i am working
 as mysql administrator the last 11 years and curently
 responsible for some hundret databases heavily using
 host specific permissions

 http://dev.mysql.com/doc/refman/5.5/en/connection-access.html
 '%''fred'fred, connecting from any host
 
 In that case you would know that connecting via a Unix socket is not the same 
 as connection via a network.
 
 See:
 http://bugs.mysql.com/bug.php?id=69570
 http://dev.mysql.com/doc/refman/5.5/en/connecting.html

i know that, but it does not change the fact that here
are mysql users in production which are using % and
accessed via localhost unix-socket as well as via
TCP from remote-machines with mysql-over-ssl

maybe MariaDB don't have that bug and it is a bug
if you can't connect with a user specified with %
over the unix-socket independent what some guy
from Oracle pretends




signature.asc
Description: OpenPGP digital signature

Re: mysql Access denied error

2014-05-05 Thread Johan De Meersman

- Original Message - 
 From: Reindl Harald h.rei...@thelounge.net 
 
 i know that, but it does not change the fact that here 

Either you didn't know that but have trouble admitting it; or you did but 
conciously chose to be rude and condescending instead of helpful. 

Your choice. In the second scenario, I can only wonder what you're doing on 
this list. 

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

Re: mysql Access denied error