| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> hypnox actually it's the table AND index in one file.
<0> so might be difficult to rebuild if you don't have data. perhaps you can rebuild from the log
<1> you need to make sure your my.cnf is setup, restart mysqld, check port 3306? with netstat and do the user grant
<0> yeah make sure you use grant.. if you don't you need to Flush Privileges;
<2> I get "Host 'app1' is not allowed to connect". So I did "insert into host values ('app1', '%', 'Y', ...)". But the following "FLUSH PRIVILEGES" says "Query OK, 0 rows affected, 1 warning". Why/how to see the warning?
<0> SHOW WARNINGS;
<3> malchias: in my my.cnf the binding is off. i can portscan the server and the standard port is open, i granted the user and it still not wirking
<2> Table 'mysql.procs_priv' doesn't exist
<3> malchias: and when i telnet to it it respond
<2> probably the mysql 5 invention, I copied from mysql 4. How to fix?..
<1> I'm a newb, sorry I don't know more and my book doesn't tell anything more than what Jax posted above
<0> Migo1 you need to run mysql_fix_priviliege_tables shell script
<0> try /usr/local/bin/mysql_fix_privilege_tables
<4> How can I change the default date display from yyyy-dd-mm to dd-mm-yyyy?
<4> oops
<4> Through PHPmyadmin
<0> ^pirate is it relevant?
<4> Jax, what do you mean?
<0> who cares how it looks in the db?
<2> Jax: I fixed this warning (by copying this table from the distribution), but now "FLUSH PRIVILEGES" gives "Query OK, 0 rows affected", and "app1" is still not allowed... What is wrong?
<0> format it in your query, or in your programming language. i.e in the query with DATE_FORMAT
<0> Migo1 is the Host field correct ?
<2> Jax: yes, all fields are correct
<0> is mysql really listening on the OUTSIDE interface?
<0> ^pirate why do you want to change how it looks in phpMyAdmin ?
<2> Jax: yes, to port 3306, and it even gives "Host 'app1' is not allowed to connect" error :)
<0> can i test? ;) i'll give you the grant
<0> do a: GRANT ALL ON test.* TO 'jax'@'%' IDENTIFIED BY 'mysql';
<5> mysqladmin: connect to server at 'localhost' failed
<5> error: 'Access denied for user 'root'@'localhost' (using p***word: NO)'
<2> Jax: I will give you the output of any select query
<4> Jax, well the date is printed and I'm too big a noob to figure out how to reformat it '_'
<0> raden use the -p flag
<0> ^pirate you doing a query, right?
<0> like, SELECT my_date FROM table;
<0> Migo1 p*** me the ip/host in private if you like.
<6> Migo1: you don't probably don't want to that.
<6> eh, one don't should be enough
<0> also give me the: SELECT * FROM user WHERE User='jax';
<5> Jax, thanks sir
<2> Jax: I would be glad, but this db machine is under firewall, 10.0.0.1, so I would need to give you 2 user/p*** and to open your ip :)
<4> Jax, yup
<0> Migo1 gah ok.
<4> Jax, actually selecting all data from the table beforehand and saving them to variables but yeah that's the gist of it
<6> Migo1: how about tunneling via ssh?
<7> whats wrong here: select t.*, wt.Field1, wt.Field2 from Table as t join (select ID, max(Field1), max(Field2) from workingtable group by ID) as wt on t.ID = wt.ID order by ID ?
<7> :)
<0> ^pirate well you do something like this then: SELECT DATE_FORMAT('1997-10-04 22:23:00', '%m-%d-%Y') AS my_new_date FROM t1;
<0> rxvtman where is the table name you're trying to join?
<0> you're trying to dynamically p*** a table name? ;)
<7> maybe
<2> what does GRANT do? Fills one of 'user', 'host', 'db' tables, or all of them?
<0> Migo1 all
<7> dynamically p*** a table
<0> !man GRANT
<8> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<0> rxvtman i doubt that'll work.
<2> Jax: But I want just 'host', is not this enough?
<7> hmm
<7> well
<7> i'm trying to use GROUP BY in an UPDATE and thats not legal so
<7> >:O
<0> Migo1 then you have to do UPDATE user SET Host='%' WHERE User='X'; FLUSH PRIVILEGES;
<7> jax: how would i go about making that query work correctly? i'd just join the tables and group the whole thing, but there's a lot of fields i want to return without performing aggregate functions on
<2> Jax: thanks, this may be it, I will try it
<0> rxvtman sounds to me, as if your schema is messed up.
<0> give me more details of what exactly your trying to do, with the table layout
<2> So I can't just insert into host, I need to insert to user too... And is user a unix name, or mysql name (-u)?
<0> mysql username
<0> if i were you, i'd use GRANT
<0> then you don't need to flush privs.
<7> i've got a table of data, and another table that corresponds to it (referencing by ID) but the second table has multiple entries per ID, i'm trying to perform an aggregate function on the second table, and pull the results along with the results for the corresponding row in the first table
<0> so you got a 1:n relation ?
<7> yeah
<0> and what sohuld the result set look like?
<0> s/sohuld/should
<0> 1:1 ?
<0> or 1:n
<7> tablea.*, max(tableb.a), max(tableb,b)
<7> 1:1
<0> ok, so you want to join on the MAX of the other table, i.e only join that
<7> yes
<7> this is the last piece of a 5-part sorted procedure :D
<0> think the other way around
<0> n:1
<7> hmm
<7> well they link around one field, TaskID, table A has one row per TaskID, table B has multiple rows per TaskID
<0> SELECT MAX(t2.my_field), t1.x FROM t2 INNER JOIN t1 ON t2.id = t1.id GROUP BY t2.my_field;
<2> (Ok, I fixed that connection problem.)
<0> good stuff
<7> well
<7> i'm not selecting MAX(TaskID)
<7> i'm selecting MAX(someotherfield)
<7> but i'm grouping by taskid
<0> yeah
<0> you get the idea
<7> still throws an error
<0> well, which? ;)
<7> hmm
<7> here's the exact query:
<7> select max(wt.ContactIDList), max(wt.ContactNameList), t.* from Tasks as t join #workingtable as wt on t.ID = wt.TaskID group by TaskID
<7> exact error: Column 'Tasks.ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
<7> its throwing errors on my indexes.. if i change "group by TaskID" to "group by ID" it gives the same error, but complains about "Tasks.ClientID" which has an index on it
<0> which db is this?
<7> sql2k5 :)
<0> mssql eh?
<7> yeah
<0> hm, perhaps ask therion about it tomorrow. he knows mssql quite well.
<0> he should be online in ~10 hours
<7> was looking for him in #sql earlier
<0> he's never on, weekends.
<7> ah i see
<0> he joins #reallife then hehe
<7> heheh
<0> then again, i thought i banned him from there
<0> hm
<7> i can possibly get around this heh
<7> but it involves creating two temporary tables
<7> kinda ugly
<0> indeed.
<7> actually one
<7> i'll do that until i can fix this
<4> Awesome
<4> Thanks Jax!
<0> sure
<7> thanks a lot for the help
<0> "help" ;)
<0> but your welcome
<7> heheh
<7> i used to live here and #php when i was a lamp coder
<0> good to hear you left #php ;)
<7> i took a sabatical and someone grabbed my old rxvt nick
<0> it only causes brain damage lately
<7> yeah well now i'm doing asp.net, i don't see any channels for that :D
<0> ... i wonder why ...
<7> the docs are very well written
<7> but i miss the user-commented docs on php.net and mysql.com
<0> yeah useful.
<7> can't find an equivilant for mssql or asp.net
<0> clippy ;)
<7> heheh
<0> http://www.rjlsoftware.com/software/entertainment/clippy/screenshots/useless.jpg
<0> :D
<7> http://www.microsoft.com/pressp***/features/2001/apr01/04-11clippy.mspx
<7> we still have the stupid search dog though
<0> hah yes ;)
<0> sniff sniff sniff
<0> http://www.digibarn.com/collections/screenshots/Screenshots%20Funstuff/TN_BushAndClippy.JPG
<0> lol
<4> Hm, I want to print data collected via a while loop + variable storage that prints 3 of the highest IDs, then gives a <TR>, another line of 3, <TR>, etc, but I'm a bit stuck..Am I even making sense? :P
<0> not very mysql specific ;)
Return to
#mysql
or
Go to some related
logs:
fsstat debian
RC_DEVICES udev
usbmon script
#gaim
automatic mount ntfs hd ubuntu
#css
unshift, pearl
#math
dillo2　pdaxrom
ubuntu install mga drivers+linux
|
|
