| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> domas : THank you for all the help.
<1> hehehe
<1> I just blogged about #mysql channel
<1> http://dammit.lt/2006/02/04/browser-wars-in-mysql-community/
<1> ;-)
<0> domas : FUnny.
<2> hmm.... why can't I do this: ORDER BY foo1 ASC, foo2 DESC
<2> or rather, what is a better way to do that
<2> whereas a better way is a way that works lol
<3> What's wrong about this?
<3> What do you expect it to do?
<2> order by foo1 in the ASC direction... if there is more than 1 foo1, order those by foo2 in the DESC direction
<3> That's exactly what your ORDER BY statement does.
<2> just like it would do if I did ORDER BY foo1, foo2 DESC.... except I want foo1 to go ASC
<2> well thats what I thought... but I get a syntax error and it points to that
<2> 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 'ASC, name DESC' at line 1
<3> ORDER BY foo1, foo2 DESC is equivalent to ORDER BY foo1 ASC, foo2 DESC
<2> oh
<2> alright cool
<2> I thought if you did foo1, foo2 DESC, it would do both DESC
<3> And regarding your error message -- maybe you should show your complete SQL statement.
<3> No.
<2> SELECT * FROM mos_sportsscores_extendedinfo WHERE eventType_id = '1' ORDER BY default ASC, name DESC
<3> Your problem is the column name "default"...
<2> ohh!
<2> DUH
<3> This is a reserved word. Rename the column, or put it into backquotes.
<2> yeah
<2> cool thanks man
<3> np :)
<2> bleh, what was I thinking.... bad ee99ee, bad
<4> How do i set up mysql so i can use phpnuke
<1> dexion: did you run ./setup-mysql-for-phpnuke from mysql distribution?
<5> did you read the phpnuke special instuctions
<1> oh wait, I was trolling here
<4> domas, i just install mysql on my gentoo box and followed the instrutions got to this point "now you need to edit the file "config.php" to set the
<4> database options. Please read carefully the instruction on that file! now i'm getting lost everything is on my localhost.
<1> :(((
<4> I'm not useing host
<4> this box will be server
<5> you computer is a host
<6> hey :) Im getting this errors "Warning: Asked for 196608 thread stack, but got 126976" all the time. Any idea what's happening? (There're no other errors on the mysql log)
<4> yes its all happening here this box will run a the server
<5> so edit the config.php and set valid hostname, user and p***word
<7> where's the thing that you run to make a new install of mysql safe?
<4> archivist, as im using localhost at the moment would i use 127.0.0.1
<5> !man securing
<8> (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<5> dexion you can use localhost or 127.0.0.1 or actual_host_name or actual_IP
<7> seemed like there was a my_sql_secure script
<1> Didact: there is
<4> Still geting not found on server when i put http://phpnuke.org/admin.php in ,Hmm seems i have not got a clue :(
<9> Heh, the pukies.
<1> Didact: scripts/mysql_secure_installation
<1> kuja: :)
<5> im not surprised dexion use a local addres of your machine
<9> I swear to god, some day I will grab every IP address of people in #mysql and ##php and attempt to mysql_connect() remotely and drop databases.
<5> try it ****er
<9> There are people who have root@% you know, with no p***word
<4> kuja, the sql hacker :)
<7> where's scripts?
<9> :(
<7> domas?
<1> Didact: in source distribution :-D
<7> hmmm
<7> fedora core 4
<7> having trouble locating the daemon and stuff
<1> Didact: install mysql-server package then
<5> i did add a db to somebody who left his phpmyadmin open
<1> I loved how google used to drop phpmyadmin databases once...
<7> it's installed, can't find the various locations
<1> Didact: rpm -ql mysql-server then
<5> he soon put a p***word on it
<7> ty
<7> ok, so when I do a mysql_secure_installation my keyboard stops working in that window
<7> oh, nm
<4> how do i change my p***wd in mysqal
<4> mysql*
<7> ok, thanks for everyones help
<10> Question: I know nothing about MYSQL other than its a database, i am trying to install mythtv which is dependant on mysql, i am getting this error message
<10> 2006-02-03 16:58:17.356 Unable to connect to database!
<10> 2006-02-03 16:58:17.356 Driver error was [1/2002]:
<10> QMYSQL3: Unable to connect
<10> Database error was:
<10> Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<10> any quick thought appreciated
<11> dexion: mysql -u <user> -p p***word 'thenewp***'
<10> thanks i'll try that
<4> malchias, thankyou
<11> it's shake and bake, an' I halped!
<10> i thought i would try the above suggestion but i got 2006-02-03 16:58:17.356 Unable to connect to database!
<10> 2006-02-03 16:58:17.356 Driver error was [1/2002]:
<10> QMYSQL3: Unable to connect
<10> Database error was:
<10> Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<1> !perror 2
<8> System error: 2 = No such file or directory
<1> ;-)
<10> so does this mean i have to setup mysql then?
<10> is there someting like mysqlconfig
<4> malchias, this is strange it does not reconize my p***wd i get this error,ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: YES)
<10> ok i started mysql but i am now getting a ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using p***word: YES
<12> hello
<12> Is there a way you can limit 1 result per id?
<12> say you have a db of genres, which is called gid
<12> many results have the same gid
<12> but you want to only select one result for each gid
<1> group by gid
<12> Group by /
<12> ?
<4> how do i start mysql with the --skip-grant-tables option
<13> I have an xml dump of a database that i need to import ... what command do i use to import .xml's?
<10> i am at a mysql prompt how do I add a user with full privledges
<10> from mysql prompt how can i add a user?
<14> hey guys
<10> hi rapid
<14> i was hoping someone could gimme a hand creating a second database using mysql 5.0
<14> and not overwriting the database i have
<10> i am needing an arm so i dont think i can give you my hand
<14> :-p
<10> i am trying to setup mthtv which requires mysql(something i want to learn anywyas but not today)
<10> so i am more lost then if i were on mars
<10> cant you just make a new DB with new name
<10> and then connect to that DB
<10> use 2nd DB
<14> lol idk
<14> im noob bro
<10> idk either dont blame me if it goes haywire
<14> oh geez..
<14> *backs up database*
<14> :-p
<10> lmao
<14> NOOOOOOOO
<15> whats the name of the thing where you select blah FROM (SELECT blah) so i can look it up in the docs
<14> im going through all this so i can use eqdkp...
<14> and i just realized it only lets me select mysql 4
<14> and im running 5
<14> but before you start to install it check to see if your system can run it
<14> and it says it can :-/
<14> ./sigh
<10> use //sigh
<10> /sigh
<10> use //sigh it them creates
<10> /sigh
<14> ./i give up
<14> it didnt work lol
<10> i just didi a mysql command i dont wnat how you you undi
<10> undo?
Return to
#mysql
or
Go to some related
logs:
gentoo removing DHCPCD static IP
#perl
centos stop dhcp
#ubuntu
pureftpadmin ftp
java encoding, decoding, chanel
cdemu Permission denied:
#perl
sony sz hibernation crash
via padlock TCPA
|
|