#mysql
24 October 2007
Total 29 pages. You are browsing page 4/29.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
01:32 <****> tells me Error #2002
01:33 <****> somebody ?
01:38 <****> if i have a m&m's despencer and i get 3 m&m's every time i turn the crank what is the probibility that i would get 3 green m&m's
01:39 <****> *probability
01:39 <****> there are 6 diffrent colors btw
01:40 <****> kkruit: i would say 100% but
01:40 <****> i asked #math and they didnt help i figured you guys may know
01:40 <****> oh you really want to know?
01:40 <****> uhhuh
01:41 <****> is that the entire question?
01:41 <****> yah
01:41 <****> assuming there is an infinite supply of m&ms you have the same probability with each m&m
01:41 <****> rrr not 3 green every time i turn the crank ... just the one time
01:41 <****> 1/6 each time
01:42 <****> (1/6) * (1/6) * (1/6)
01:42 <****> please somebody
01:42 <****> nice so 1 in like 216
01:42 <****> what do you need?
01:42 <****> i cant configure MySQl on suse 10.2
01:42 <****> why aren't more ppl in here talking?
01:43 <****> on all the channels?
01:43 <****> kkruit: sure
01:43 <****> thank ya sir! ... sorry to go off topic
01:43 <****> cie213: I am studying for a test
01:43 <****> cie213: well it's night in Europe
01:44 <****> good point haha
01:44 <****> heeeey
01:44 <****> apparently, some people see that as a good reason to not hang out on irc
01:44 <****> how to dump and restore a database with mysqldump?
01:45 <****> http://dev.mysql.com/doc/refman/5.0/en/backup.html
01:45 <****> reference to mysqldump: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
01:46 <****> on the second link, scroll down just above the comments to see an example
01:47 <****> how to configure MySQl ?
01:47 <****> hello everybody
01:47 <****> xochilpili: that's a ridiculous question
01:49 <****> xochilpili: http://dev.mysql.com/doc/refman/5.0/en/configure-options.html
01:49 <****> i ve just installed mysqlserver on a freebsd jail (in which i can not listen on localhost but on a specific IP), when i try from the host where is mysqlserver, i get error: 'Host 'cimdev12' is not allowed to connect to this MySQL server'
01:50 <****> external
01:50 <****> no the_wench
01:50 <****> !tell siddharta about external
01:50 <****> But I don't know a thing about that.
01:50 <****> SQL: bitch!
01:50 <****> yeah damn it
01:50 <****> so i don't understand , i add this param in my.cnf : bind-address= 192.168.1.2
01:50 <****> siddharta: you need to add a grant
01:50 <****> siddharta: that's not it, you must allow cimdev12 to connect to your mysql server in the mysql privilege system
01:50 <****> !man grant
01:50 <****> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
01:50 <****> chadmaynard: can you look at this: http://pastebin.com/d53762072
01:51 <****> everything works fine but I am confused by the size of the new column (varchar 4?!)
01:51 <****> dkr : sorry are born being knowledge?
01:52 <****> nils_: well but how to execute the query if i can not connect from the main host
01:52 <****> siddharta: excellent question
01:52 <****> xochilpili: yes, because adam and eve ate the fruit of the tree of knowledge
01:52 <****> siddharta: you can connect via the unix socket, that should always work
01:53 <****> no , not in a jail
01:53 <****> damn jails
01:53 <****> reminds me of the time I was in jail
01:53 <****> ;)
01:53 <****> dkr : http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html <-- this dont work for me, because i installed mysql from yast
01:53 <****> it's true what they say about the soap in prison showers
01:53 <****> it really slips off your hand easily
01:54 <****> whe i type mysqld its says an error & shutdown
01:54 <****> i dont know what to do, i search in google
01:54 <****> siddharta: what you can do is start the mysql with disabled authentication and modify the tables in the mysql database directly.
01:54 <****> xochilpili: errors aren't mysterious abstract concepts, they tell you what is wrong
01:54 <****> ribasushi: you can't store characters in an int so it casted to a varchar
01:54 <****> implicit to the concat
01:54 <****> chadmaynard: I understand that, why only 4 characters long
01:55 <****> chadmaynard: won't this trim away a lot?
01:55 <****> ribasushi: I think it will adapt ;)
01:55 <****> ribasushi: if that value isn't even totally made up
01:55 <****> right
01:55 <****> nils_: ok i search how to do that
01:55 <****> xochilpili: http://dev.mysql.com/doc/refman/5.0/en/database-administration.html
01:56 <****> siddharta: skip-grant-tables in my.cnf, then use sql to modify the mysql.host, mysql.db and possibly other tables
01:56 <****> nils_: so I can disregard this, and my overall construct is perfectly valid?
01:57 <****> ribasushi: I think so, but you might want to check by yourself
01:57 <****> nils_: it looks ok (after running some selects), but I have been in IT too long, to know that not everything appearing to work actually does :)
01:57 <****> so I figured I'll ask
01:58 <****> ribasushi: as long as it appears to be working to the client ;)
02:00 <****> thanks guys
02:04 <****> hmm I just can force myself to code today.
02:04 <****> can't
02:04 <****> DO IT!
02:13 <****> when i typed : mysql -u root 'mypass' its says : Access denied for user 'root'@'localhost' (using password: NO
02:13 <****> what's wrong ?
02:13 <****> mysql -u root -p
02:13 <****> then type your password
02:13 <****> or just put it after -p
02:13 <****> ok
02:15 <****> mysql -u root -p 'mypass' : says : Enter a password: mypass then Error 1049 (42000) Unkow database 'mypass'
02:15 <****> what's wrong ?
02:16 <****> if i typed : mysql_install_db : its says : Acces denied for root @localhost /using password:NO)
02:16 <****> don't put mypass
02:17 <****> just mysql -u root -p to stay secure
02:17 <****> if u don't want to stay secure then mysql -u root --password mypass
02:18 <****> wait : i typed mysql -u root -p
02:19 <****> and then its says : Enter a pasword then i typed, and it's say: your MySQl connection id is 28 to server version_ 5.0.28
02:19 <****> type help or c to clear the buffer
Total 29 pages. You are browsing page 4/29.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last