| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Therion: this is America for gawd sakes! children should not be exposed to people having ***, but they can watch somebody get disemboweled all they want
<1> i mean how can i use it
<2> dramen: there are many tools, actually mysql has a graphical utility for that
<2> dramen: you will not be responded to if you ask these kinds of questions, there are books at barnes and nonbles on this subject :)
<2> but check out mysql.com
<2> for mysqladministrator
<1> okay
<2> sigh, enough procrastinating, off to do the damn hw
<2> you people are all mean :(
<1> thynk you very much
<2> dramen: np
<3> vasiliyb_home: You will thank us later! :P
<3> Maybe much, much later.....
<3> mishehu: Where do you live?
<3> I mean
<4> like... in next life
<3> A/S/L
<4> lol
<4> so as I got up at 6AM I thought it would be cool to clone off some mysql slave servers...
<4> and hey, root p***word doesn't work!
<4> life ****s!
<5> why do i get this error when trying to delete a user: #1268 - Can't drop one or more of the requested users
<3> life sometimes blows
<4> command_: not revoked grants?
<3> command_: probably did not revoke all of the grants for the user
<3> need to do that before 5.0
<5> ok
<4> Therion the Verbose
<3> :P
<3> o/` Little Pig, Little Pig, Let Me In o/`
<0> ASL == ***hole, didn't you know that?
<4> damn, I stepped in a bit early, and got some fun cold shower already :)
<6> ok... after talking to some people I have determined I need mysql ***itance :D arent you thrilled?
<4> I should have slept longer :) could have a lazy saturday
<4> mishehu: that's somewhat bad reading comprehension
<0> I can't do cold showers.
<0> domas: shorthand.
<0> ashole
<6> So, I was hoping i could describe what i want to do, and you could tell me in essense how to build my tables
<6> any takers :D?
<7> i am sorry for the question here but i don't know where to ask as i don't have friends in here. May you login on google adsense right now? Because i have error message for more than 2 hours. Thank you in advance
<5> Therion: that worked for one of the users that didnt have ALL PRIVILEGES, but not for one with ALL PRIVILEGES
<4> Skretch: um, I don't know you, are you DBA there as well? :)
<5> (im doing this through phpMyAdmin)
<7> domas what is DBA ?
<4> data base administrator
<3> DumB***!
<3> :D
<4> ah, right
<4> dumb*** :(((
<7> domas i have an account in there
<4> litheum: moin!
<4> Skretch: root?
<3> litheum: why are you sober and conscious?
<3> litheum: at the SAME TIME?
<4> yeah, somewhat strange :))
<7> domas, I am sorry but i don't understand what do you mean ?
<3> Skretch: have you tried contacting someone actually with Google, or whatever?
<6> Awe you knwo you want to do this one Therion!!! :D
<7> Therion i am wondering whether it is my problem or it is a global one
<4> Skretch: are you trying to log in into adwords mysql servers??
<3> Lord_Loki: 12:30am, trying to leave so wife does not stab me to death in my sleep
<6> doh
<8> Therion: i am quickly moving away from sobriety, worry not!
<6> i am told its really easy
<3> it surely is
<3> but you didn't ask a question :P
<8> just drank some belgian beer, some seattle beer, and i'm drinking some swedish beer right now as a matter of fact
<6> ok
<3> litheum: die
<6> here ya go
<3> litheum: I need to get a raise so I can move up there and drink beer with you
<7> domas yes exactly
<6> I am trying to create a mod in phpbb that i can add medals to users with. Now for each medal there is a 2nd image... ie 1 table with both image filenames and an id field
<4> Skretch: then which account are you using?:)
<8> Therion: use some of that vacation time!
<6> i also thought that i should create a field in the users table for each medal (a total of 42 different medals , 9 levels for each)
<4> Therion: you'd come here - no need for a raise, lots of beer! :)
<3> domas: maybe if company would keep paying me the same......... ;)
<6> and someone said to create a links table or something so that i didnt have a bunch of empty fields for the possibility of a medal... and now i am lost
<8> Therion: i actually brought the swedish beer back with me so we're not gonna be able to drink that one when you're here
<8> but we can find some pretty amazing other stuff
<3> litheum: hate you!
<6> I want the mod to be able to add new medals, edit existing ones, and add medals to users.
<5> mysql> FLUSH PRIVILEGES; REVOKE ALL PRIVILEGES ON * FROM 'floridadb'@'%'; DROP USER 'floridadb'@'%';
<5> ERROR 1268 (HY000): Can't drop one or more of the requested users
<5> why :(
<7> domas thebeatlesplace.com
<8> Therion: i know, but you're so cute when you do it!
<4> Therion: you can use 'so if you're not raising for my move to Seattle/Cal/whereverelse, do not lower for Vilnius!'
<7> i am using this account
<4> Skretch: that's not a valid mysql login!
<6> I also want the interface to function neatly.. ie.. i thought that if i added say a 2nd medal of honor to a user, the value would increase by 1, displaying the next appropriate image
<3> Lord_Loki: table user ( user_id ); table medal ( medal_id) ; table user_medals (user_id, medal_id) <- this sort of thing is what they were recommending
<6> so my question is... how do i being by setting up my tables correctly
<3> Lord_Loki: So you have a row in user_medals for each medal that each user has
<7> domas my problem is that i cannot access the login page
<7> what about you
<4> Skretch: you don't need to access login page to get to mysql!
<7> domas i want to check my account there
<3> domas: maybe not much cheaper there than TN anyway :P
<6> a row in the user table yes
<6> but i am being told thats wrong
<4> Therion: bigmac - 2$ ;-)
<3> domas: about same
<6> and even if i link it,.. how will the db/php know that they have more than one medal?
<6> thats still the same as adding fields to the user table no?
<3> Lord_Loki: no
<4> Lord_Loki: user_medals
<3> Lord_Loki: :)
<6> now i am confused
<3> !tell us about normalization
<9> Therion asked me to tell you this: http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
<4> anyway, you may aggregate some data
<3> Lord_Loki: Reading that might help you a lot
<6> I am sir iam
<3> mhillyer: Serve this poor man, you wretched evil man!
<4> doh, this week I had one not normalized database that made me sick
<3> Leithal: WAKE UP!!!!!!!!!!!!
<3> Leithal: IT'S MORNING!!!!!!!!!!!
<6> i need to explain the medals better
<4> why the **** is default keepalive time on linux 2 hours?
<4> that's not keepalive
<4> that's keepcoma
<3> lol
<6> 42 different medals, 9 different medal images (or levels of each medal) for all 42; ie 42x9 rows with 3 fields, id, image1, image 2
<6> lets suppose i have nothing else
<6> each user can have 1 of every medal
<6> what do i need to make
<6> and where
<7> domas may you open the following link -> http://www.google.com/adsense?hl=en_US&sourceid=aso&subid=us-et-ads
<6> so that i can manipulate that according to medal and user
<7> and let me know whether it is working or no
<10> how do you reset the mysql root p***word ?
<3> Lord_Loki: same thing I said before... but if you had 42 medals, 2 users, and both users had one of every medal, you would have.. 2 rows in user table, 42 rows in medals table, and 84 rows in user_medals table
<3> Lord_Loki: that intro to normalization article will explain some of the reasoning behind that
<3> !m [Dameon] reset root
<9> [Dameon]: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<4> user_medals (user_id,medal_id,medal_level,primary key(user_id,medal_id,medal_level)), medals(medal_id,medal_level,medal_file,primary_key(medal_id,medal_level))
<4> \o/
<6> and from that i can tell a php nut what i have and they would get it easily to be able to write the code?
<3> is a basic join, yes
<6> I am going to read this article and get back to you.. hopefully i will have a better more consise understand of what your talking about LOL
<10> ty :)
Return to
#mysql
or
Go to some related
logs:
#perl
#ubuntu
nalioth troll
#php
#debian
Mismatch between target UID suphp
#linux
+www.bluebit.gr/matrix-calculator
#centos
#web
|
|