| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> !m jxmiller tutorial
<1> jxmiller: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<0> !m jxmiller create d
<1> jxmiller: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<2> I'm having a tuff time here. can someone give me an example query to change a users p***word? I've tried SET P***word = P***WORD("myp***word"); and UPDATE mysql.user SET P***word = P***WORD("myp***word") WHERE User = "myuser";
<0> Only do the first one.
<2> will: that doesnt work
<0> Yes it does.
<2> the p***word isnt changed
<0> !tell us about doesn't work
<1> will asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message. Tell us what it does and/or does not do.
<0> How do you know?
<2> when I issue that query, and exit the mysql client, then log back in with the new p***word I get error, if I use same old p***word it lets me in
<2> thus p***word isnt changed
<0> Try it again?
<2> k
<2> same
<0> Try ' instead of "
<2> the only way I seem to be able to change the p***word is with MySQL Administrator
<0> http://hashmysql.org/1924 I don't know what to tell you.
<3> what is MySQL Administrator used for?
<3> lol nevermind its obvious
<2> ok, works from command line but not from my app now. Logs show this. when run from command line "SET P***word = P***WORD('myp***')" when same query is run from my application the log shows this: "SET character_set_results=NULL"
<3> mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using p***word: NO)'
<3> when i run mysqladmin it gives me a bunch of help type text, when I run 'mysqladmin versions' it errors
<0> jxmiller, Because you don't have a p***word
<0> Led-Hed, Your app problem then :)
<2> will: any idea what the latter log message means?
<0> Nope.
<3> mysqladmin versions 'p***wordhere' ?? like this?
<0> jxmiller, mysqladmin -uuser -pp***word version
<0> EXACTLY like that.
<3> so no space between -u and 'root' like this '-uroot' ?
<0> I will kickban you if you don't start listening to me.
<3> cmon
<0> I said EXACTLY.
<0> Why don't you listen?
<0> If I wanted you to put a space in there, I would tell you.
<3> ok i will type this in exactly unaltered 'mysqladmin -uuser -pp***word version'
<4> FINISH HIM
<0> Well actually haha... You do want to replace literal user and p***word since I don't know your user name or p***word. I ***umed it and that was my fault.
<0> What is your root p***word? Then I will make bold statements.
<3> it is actually 'new-p***word'
<0> ugh
<0> Ok
<0> Then do this. ***uming root. mysqladmin -uroot -p version
<3> boom got it
<0> What did you do?
<3> mysqladmin -uroot -pnew-p***word version
<5> you actually gave us your root p***word.
<0> ok. Wasn't sure if the - in the p***word would mess it up.
<5> wow
<0> frank-, Drop it.
<3> thats not actually my p***word
<3> hey sorry for the 500000 questions but for what its worth I am following a guide its just not a great one
<3> and for reference its this one http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
<0> That's a pretty good one actually.
<3> for me though not having exact syntax hurts
<3> I was on step 4 trying the mysqladmin versions thing and its syntax is not like mysqladmin -uroot -pnew-p***word version whatsoever
<0> Eh. I have only briefly looked at it, and I already knew it, so I can't say from a beginner's point of view.
<0> That's because you already set the root p***word. That guide thought you didn't.
<2> will: you use vb at all?
<0> Nope!
<0> jxmiller, #9 tells you to secure the accounts...
<3> awesome crap is working
<4> that's good. I like it when "crap is working."
<6> hello
<6> where can i get a good tutorial on making stored procedures and functions for mysql
<7> Ryugi: try www.mysqldevelopment.com not sure if it is still live or not
<7> Ryugi: i thought there is a o'reilly book specifically on mysql stored procedure
<8> hehe i love mysql
<8> you can do some neat things with it
<0> Like what?
<8> lol just everything that you can do, and different schemas you can design
<8> the potential that mysql has is great
<7> everything?
<8> lol i just like mysql
<0> lol
<8> yea everything
<0> tdd1984, What other RDBMS have you used?
<8> this is it
<8> this is my first one
<0> :)
<0> Glad you love MySQL.
<8> whys that?
<8> i've never used asp ms sql or anything like that
<7> tdd1984: first one, nothing to compare
<8> well isnt mysql the better ones?
<0> Depends on what you need.
<8> true
<0> Are you saying a hammer is better than a screwdriver?
<8> lol
<8> i get your drift
<8> :)
<9> hammers are better for crushing toes
<9> ;-)
<10> how can I perform a query that checks a field but ignores spaces?
<11> example?
<5> like '<expr>' and not like '% %'
<5> perhas
<10> example:
<10> product number is = '304 453 34'
<10> I want a query where I search for '30445334' to match for a record with product number = '304 453 34'
<5> try REPLACE()
<11> rlike can do that, albeit slowly
<10> hmm
<10> which is best ?
<11> frank-: you have a manual link for replace()?
<11> I can't find it
<5> not sure
<5> replace ('field', 'value', 'new value')
<5> I think
<11> http://dev.mysql.com/doc/refman/4.1/en/string-functions.html
<11> it works
<5> great
<11> select username from user where replace(username,' ','') = 'sample';
<11> it would be slow too
<11> need to benchmark rlike vs replace()
<11> trym__: you need to fix your data. otherwise you can't index any of this.
<10> well I would be happy to remove the spaces
<10> but then I would have to store how it is supposed to be divided
<10> so it can be displayed properly
<5> how about using 3 fields to store it?
<5> integer fields, at that
<5> you'd get a huge performance bebefit
<10> frank-: the problem is the numbers are divided differentlyu
<5> ok then
<10> I think the easiest way would be just storing one plain integer
<5> store them in a seperate table
<10> and then a varchar that represents how it will be displayed
<5> link them by OK's
<5> PK's
<5> trym__: I disagree
<10> Im listening :)
<5> table a, with a OK.
<5> err PK
<5> table b, storing ONE integer, with a PK linking to table a's PK
<5> inner join both, you can have as many integral segments as you want
<5> order by PK on table b, or a similar scheme, and you can order them too
<5> it'll be faster than your solution
<10> ah sweet
<10> thanks :)
<5> WAY faster.
<5> and scalable
<12> hello!
<10> nice.. thanks :)
<10> HELLO DOMAS!
<5> I prefer tables will less fields any day
<5> it's called normalizing your tables.
<12> this is called...
Return to
#mysql
or
Go to some related
logs:
#css
howto gtkipod
Keybindings MX1000 SuSE
alex kun
Build-dependencies for wine could not be satisfied.
#postfix
#openzaurus
#fedora
#linuxhelp
how do I get sigint?
|
|