| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> lol
<1> winmutt: No wonder PHP folks removed it from mysqli
<2> archivist: but why. the only problem with pconnect is when people dont properly configure the mysql daemon
<2> imo
<3> no your just wrong
<4> ya but i mean using GRANT, does a user already have to exist? or can GRANT also add a user
<2> how am i wrong
<4> like if i use: grant all on *.* to username@example.com identified by 'p***word';
<2> give me one reason why its bad
<4> does that create a new user called username and p***word 'p***word' ?
<5> which version of mysql do I need to use EXCEPT and UNION?
<6> How do I JOIN another table b to table a so that b.col is the heighest possible match for b.col<=a.col
<6> The thing is there is already a GROUP BY a.x, a.y
<2> the only problem i have ever had is with innodb and transactions
<4> paging: RainMkr
<1> hacked``: Why don't you take a look at the manual?
<1> !m hacked`` adding users
<7> hacked``: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<4> salle, i came to the realization that the manual is too technical for me
<8> !m hacked`` tutorial
<7> hacked``: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<8> maybe you should start there then :)
<4> thx
<1> hacked``: If the manual is too technical for you MySQL will be even more difficult for you ;)
<1> hacked``: You didn't open any of these URL :)
<4> im reading tutorial now
<4> probably gonna pick up a book too
<2> skip learning sql
<2> learn realtion database theory
<2> then sql
<2> then mysql
<9> Maybe look at MySQL Crash Course hacked``
<2> s/realtion/relational
<9> Oh yes, first read everything at www.dbdebunk.com
<5> does mysql support set operations?
<10> how can i ***ociate the options in ~/.my.cnf with an actual user in mysql?
<2> Snadder: mysql.org/set
<2> why would you use set?
<11> Are you allowed do this in a query ... SELECT * FROM REMINDER WHERE CURRENT_TIME() > TIMESTAMP ... compare a function against a col ?
<5> winmutt, I want to use set operations.. like EXCEPT and UNION
<2> Snadder: rtfm
<5> winmutt, mysql.org/set is not the right place.
<5> winmutt, http://dev.mysql.com/doc/maxdb/en/ed/1f2a40ce93185de10000000a1550b0/content.htm <-- the nearest I came..
<5> winmutt, but that dosnt work it seems
<2> http://dev.mysql.com/doc/refman/5.0/en/union.html
<2> i am not a help index
<2> or google
<12> o/ hello
<13> which way round do to do locks and transactions with innodb tables...
<13> do i start the transaction
<13> then get the lock
<13> and release the lock, then do the rollback
<2> star? why do you need a lock?
<2> thats what the transaction does
<12> any help here with getting mysql to work with PHP?
<2> stron?
<13> winmutt: nah i need to stop people inserting at all into the table while i'm doing this operations
<2> StarScream: why?
<13> because i use max(auto_increment)+1
<2> that sounds like bad programming
<13> i messed up
<13> yeh it is
<13> but i can't do anything else atm
<2> you can use sequences
<5> winmutt, sorry to bother you.. but I cant find EXCEPT.. only UNION.. on that page you just pasted.
<13> winmutt: sequences ?
<12> PHP Startup: Unable to load dynamic library '.\ext\php_mysql.dll' - Access is denied. HEEELP! :)
<13> Stronith: is mysql installed ?
<14> is there a limit to the amount of data that can be stored in a mysql DB?
<12> Star: yes
<13> Stronith: is php built with mysql support
<5> winmutt, union works nice. but except dosnt
<15> how can i grant all privileges on the anonymous user (ODBC on Windows, I guess?) without requiring a p***word?
<12> Star: apparently not
<2> starscram: create a table with one col called id and one row and increment the value as needed
<13> and is it looking in the right place for the library
<15> (don't worry, i know this is a security problem - it's running on a VM that has a non-persistent disk and isn't on long term)
<12> Star: I am not a experienced 'builder' I used the windows installer and grabbed the req DLLs .. (should be in the right place.. although now they are in a few places.. trial and (losts of) errors)
<2> StarScream: the way you ar going about it is backwards, might as well not even use innodb.
<13> winmutt: yeh i realise this now, but i've got existing users on this system. I know i messed up but i only need to lock the whole table on very rare occasions
<5> damn.. I cant use mysql without EXCEPT..
<15> i
<15> i'm trying "grant all privileges on *.* to '*'@'localhost', but i get this error: "can't find any matching row in the user table"
<13> winmutt: i need innodb for the foriegn key. i don't understand what you mean by going about it backwards. i wanted to know which one of the two it was
<15> GhettoJava: heh - you the author of the blog with the same name?
<8> PSquad32: anonymous user is just ''@'localhost'
<4> shabbs, i did grant all on *.* to 'gay'@'192.168.%' identified by 'lame';
<4> it said query ok, 0 rows affected
<4> but then when i try logging in using gay/lame on phpMyAdmin, doesnt work
<15> shabbs: i get the same error :(
<2> StarScream: locking tables is bad for everything but maintenance. why dont you insert a row first get the id and then do what you have to do
<8> !tell us about doesn't work
<7> shabbs 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.
<4> k, cant login, no access
<8> what's the error message
<13> winmutt: doesn't myisam lock the whole table for insert anyway ?
<9> winmutt: And if someone inserts a row between your insert and the getting of the id?
<4> no error, i just cant log in with gay/lame
<13> winmutt: so you think i should insert a row, get the id, then delete it and use that id ?
<8> hacked``: well if there is no error how do you know you can't login?
<4> shabbs, cause im typing gay as username, lame as p***word and i get a reprompt for user/p***
<4> like user/p*** is wrong
<8> hacked``: why don't you try it from the command line first mysql -ugay -plame and see if it works
<8> and if it does, it's a pma config problem
<4> i get an access denied
<8> full error
<13> mhillyer: do you know which order i need to use locks / transactions ? is it get lock, start transaction, commit / rollback, unlock....or start transaction, get lock ,release lock, commit/ rollback ?
<13> i'd like to just try this
<13> to see if it will even work
<9> What do you want to do StarScream?
<4> ERROR 1045 (28000): Access denied for user 'gay'@'localhost' (using p***word: YES)
<8> that's cuz 'localhost' != '192.188.%'
<8> or whatever
<13> mhillyer: i have 3 sql statments i need to exectute in a transaction..i also need to lock the table while doing this insert incase someone inserts a row between me getting the max(auto_increment field) and updating the row
<15> shabbs: was that "doesn't work" notice directed towards me?
<8> PSquad32: you too yes
<4> ya but when i connect from other pc on lan in same subnet, ie. 192.168.1.10, i cant log in either
<13> mhillyer: i realise this isn't generally a good idea, its a hack for something i've been asked to do, but it should work fine for what i want
<9> That is how you want to do it StarScream, I asked for what you want to do.
<15> why? i said, "same error"
<8> same error what?
<15> look 3 lines up :)
<15> "can't find any matching row in the user table"
<8> ah
<15> heh
<13> mhillyer: ah well..i can do everyhting i want..i just thought i needed to prevent the above scenario from happeneing
<8> PSquad32: is it cuz it's already in there?
<15> trust me, i'm not the "doesn't work" kind of person :)
<15> i did pretty much a default install of mysql on windows. i haven't created any users or granted any permissions
<9> Ok nevermind then.
<15> my goal is to allow for someone to do "mysqladmin create foo" without being prompted for a p***word
<15> as well as connect to said database and create tables, etc
<8> PSquad32: iirc anonymous user is created by default
<16> !m jink INT
<7> jink: (Overview of Numeric Types) : http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html
<15> currently when i do "mysqladmin createdb foo" i get this error:
<15> 'Access denied for user 'ODBC'@'localhost' (using p***word: NO)'
<13> mhillyer: i don't need to lock the tables ?
<8> PSquad32: do a 'SHOW GRANTS FOR ''@'localhost'
<9> You don;t need to answer my question, apparently.
<15> not sure where ODBC is coming from - my windows username is "user"
<9> I asked you what you want to do, you keep telling me how you want to do what you want to do.
<15> shabbs: "There is no such grant defined for user '' on host 'localhost'"
<8> hrm
<8> !man grant syntax
<13> erm..ok, not really sure what you want without going in depth into how i messed up my tables
<7> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<15> i read that
<13> basically i want to update a column of a table (which is also an auto_increment) with the next available auto_increment value
<15> the problem is, what the heck is "ODBC"? you're asking me to do "", but the errors i see are about "ODBC".
<4> shabbs, anyways you were right about the localhost crap, but i mean, how can i add 2 hostnames for 1 user
Return to
#mysql
or
Go to some related
logs:
#perl
#lisp
#qemu
thumbplus wine
#centos
href=javascript: popupWin
azureus saq
python returns ascii VALUE
#gentoo
#fluxbox
|
|