| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> how can I make this recursive thing work? SELECT categories.`categories_id` FROM `categories` WHERE categories.parent_id = (SELECT categories.`categories_id` FROM `categories` WHERE categories.parent_id = 223);
<1> change = to in
<0> complaints about second select returns more than 1 row, which by me is fine...
<0> ah
<2> is this a valid mysql query? => http://www.rafb.net/paste/results/joWtHa46.html
<0> hmm
<2> mysql signals several syntax errors... and i am confused
<2> well?
<2> __Ace__ ?
<3> how could I use the log function in mysql?
<4> !m vhuren log
<5> vhuren: (Mathematical Functions) : http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
<4> hmm
<6> !looping
<2> is this a valid mysql query? => http://www.rafb.net/paste/results/joWtHa46.html
<7> good evening
<7> I have this problem
<7> 2 pcs
<7> mysql 5
<7> no firewalls
<7> I can't connect to the server of the LAN
<7> as mysql client
<7> any ideas?
<2> can
<2> you
<2> please
<2> post
<2> your
<2> question
<2> in
<2> one
<2> line
<2> ?
<8> _m6s_: what is the error? or just a timeout?
<7> Like you did :-p :-) ok, I wanted to be clear just that!
<0> BigSinep: I kinda have the same problem as http://codewalkers.com/archives/sqlhelp/1630.html
<7> polvi: I getERROR 2003 (HY000): Can't connect to MySQL server on '10.0.0.79' (111)
<8> sure you have networking enabled in mysql?
<8> like, is the port open?
<7> It's rpm
<0> cat_id, parent_id. I wanna select all cat_id (and those where cat_id also is a parent)
<0> example:
<8> _m6s_: is that a way of saying "i don't know? "
<8> :P
<7> LoL
<7> perhaps yes, its an rpm
<7> how can I know if its network capable?
<0> cat_id = 244, parent_id = 233 -> cat_id = 636, parent_id = 244;
<8> i'm sure it is network capable, just might not be enabled. on the mysql host, run: netstat -lntp | grep 3306
<8> if nothing shows up that means the server is not listening
<7> Well it is true!
<9> Alright, so here's a question. I want to do this query: "select t1.*, t2.* from footable t1, bartable t2"... The problem is, both those tables have an "id" column, but all other columns have different names.I want to make sure that the "id" column gets selected from t1, not t2. How do I make sure of this?
<0> anyone got some bright idea?
<7> I don't see with netstat... but I have done service mysqld start!
<8> _m6s_: check /etc/my.cnf for a line that says: skip-networking
<8> if it is there, comment it out, and restart mysqld again
<7> nope, I don't anything like that :-(
<10> !tell prium about evil
<5> Alrighty.
<10> prium: don't use *, then you can ask for just the columns you want and need
<8> _m6s_: can you connect to it locally? from the mysql server?
<7> yes
<7> :-)
<7> can I check localy from mysql tool IF mysql server listens on a port?
<11> netstat -an
<8> _m6s_: thats what the netstat thing was :)
<11> netstat -an | grep LISTEN
<7> well ok, suppose netstat showed all the ports up-to 65K....
<7> the scenario is netstat doesn't show any port, I connect locally, then what might happened? mysql-no-network-capability.rpm perhaps?
<11> netstat -an | grep LISTEN 'will' show it
<0> kinda like: SELECT * FROM `categories` WHERE categories.parent_id = 223 and categories.categories_id = categories.parent_id;
<11> if it dosen't then your netstat has been altered
<0> but that doesnt work
<7> [root@zeus root]# netstat -an | grep mysql
<7> unix 2 [ ACC ] STREAM LISTENING 36983 /var/lib/mysql/mysql.sock
<7> what this means?!!!!!
<0> how do I say <previous table result>.categories_id ?
<11> or
<11> lsof -i
<7> the -lntp doesn't show nothing (still)
<0> has this become linux support? ;)
<11> __Ace__: people aren't very imaginative and self-sufficient it seems
<0> damn, I can solve my problem with php, but was hoping for some nice mysql solution
<7> polvi: are you gonne gonne gonne?
<12> i try to connect to my mysql 4.1 server using dreamweaver. my host is localhost, my document root is public_html. I get this error when i try to select a
<12> database: 1) there is no testing server running on the hostmachine" 2) the testing-server specified does not map to the http://82.157.27.106/
<12> _mmServerScripts/MMHTTPDB.php URL. Verifie that the URL-prefix map to the root of the site. any briljant ideas anyone?
<8> _m6s_: nope, just out of ideas. pastbin the output of /etc/my.cnf and netstat -an|grep LISTEN
<11> also
<11> ps aux | grep mysql
<7> gvam
<8> frank-: good call ;)
<11> also please check the mysql logs
<7> http://pastebin.com/634843
<7> I p***ed the info there
<7> mysql-logs are null
<8> /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --skip-networking --pid-file=/var/run/mysqld/mysqld.pid
<8> note the --skip-networking
<8> check /etc/sysconfig/mysqld for something related to that
<7> mandrake :-) check the last line ;-) of my pastebin
<8> yeah, sorry, anyway, there is a config option somewhere in a mandrake init script that is causing that
<7> Tip: is it a problem when I give the grant all, the query result is 0?
<7> (no big-deal, not that my mandrake would cry ;-)
<8> _m6s_: paste /etc/init.d/mysqld :)
<8> (to pastebin)
<7> polvi: YES! telnet works to 3306
<8> there ya go, what did you change?
<7> the sysconfig
<7> ****
<8> sweet
<11> good call
<7> thank you guys
<11> I never used manrape, so I wouldnt have known
<7> or...girls :-)
<8> frank-: either have i...
<7> but the error 2003 keeps going on... :-(
<8> iptables -L -n |grep 3306 ?
<7> no iptables, sorry! LoL
<8> ok, now paste: netstat -lntp
<7> we are cool, I see mysqld
<7> 3306, we have network for sure
<8> ok.. hrm.. sure you are trying to connect to the right server?
<11> haha
<7> Lol :-ppppppppp
<7> grant all on *.* TO 'm6s'@'10.0.0.2' IDENTIFIED BY
<7> is this a nice line for granting privileges?
<7> what worries me is that grant and flush give 0 rows affected...is that good?
<11> _m6s_: select the proper database
<7> I have done use mysql; and then I do the grant and flush thing
<13> is there a way to find out what number was just used in an auto_incrementing column?
<13> ie: if I do: "INSERT INTO SOMETABLE VALUES()" (specifically via jdbc) can I get at the value of ID that was just auto-allocated?
<7> IF I keep the tables in a safe place, delete entire mysql and rebuild it, then copy this tables ( which I have upgraded to 5 ) again in mysql directory they should work normal....logic?
<14> mysqldump: Got error: 1044: Access denied for user 'ibls'@'localhost' to database 'ibls' when using LOCK TABLES
<14> eh
<14> how do i fix that?
<14> p***word is right, and the user has full access to the table
<15> grant lock tables on ibls.* to 'idls'@'localhost' identified by 'somep***word';
<14> ah
<15> ..i think
<14> thanks
<14> works
<14> cheers
<15> :)
<13> ah, http://dev.mysql.com/doc/refman/5.0/en/cj-retrieve-autoinc.html
<16> Does anyone know how to do a select that will show me everything that was inserted between today and 7 days ago in 4.1 syntax?
<11> !m DogWater datetime orperations
<5> DogWater: Nothing found
<11> !m DogWater date functions
Return to
#mysql
or
Go to some related
logs:
#perl
gleam CHARSET = latin1
red_tide
#css
#lgp
#debian
audomont -x
#mysql
#perl
#bash
|
|