| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> have a nice day
<1> #include <libmysql.c> is probably a good start
<2> poor wgwinn, he could do it in 5 lines of php
<3> 4 if you code it right :P
<4> Good evening all
<5> what should BLOB values default to ?
<6> nothing?
<5> like for doubles
<5> I have DEFAULT '0.0' NOT NULL in create table
<5> what do I use for blobs ?
<6> i'm if corrrect, I think you can't ***ign a default value to blob
<6> but i'm maybe wrong :)
<7> so does anyone know why UPDATE `tables_priv` SET `Host` = '', `Table_name` = 'D%', `Timestamp` = NOW( ) WHERE `Host` = 'localhost' AND `Db` = 'MGM' AND `User` = 'bindsys' AND `Table_name` = 'DSOA'; doesnt allow that user to see all tables beginning with D
<7> seems I only ask when no one is paying attention
<8> kib: don't mess with the mysql.* tables directly, use the proper grant commands
<7> jink: well how do I form a grant command to do this then?
<7> D% just doesnt seem to work
<8> correct
<7> what would work in tha tinstance?
<8> % only works in LIKE, and mysql doesn't do that for table_privs
<7> then does it work in db?
<7> is there something else that I can use in table_privs?
<8> you would have to grant access to every single table. i'm wondering though: why only allow access to d% and not just to MGM?
<7> because the program in question shouldnt be accessing anything else inthat db
<7> only the tabled begining with D ar related to bind
<7> so this is a secruity measure to make sure certain apps are not used in the wrong ways
<7> we normally take permissions right down to the field
<7> often giving write without giving sleect for things such as p***word
<8> and you can't put that in a different database?
<7> I am trying to make this not only simple and easy to manage but secure giving only the actual access each login needs
<7> jink: well if I can use % with dbs then thats possible
<9> alright, I updated the libs and that error still occurs :/
<8> !m kib grant
<10> kib: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<7> there are some thing that need access to more then one part of MGM
<8> i think that pretty much explains what you can and can't do
<7> so it would be like GRANT ALL ON MGM.D*
<7> so * will work?
<11> Could not connect to the database
<11> what can i do?
<12> Is there anyway to make my mysql 5.0 compile update with my old tables from 4.1?
<8> kib: donno. check the grant syntax and/or test it
<11> how can i change the user of mysql?
<7> GRANT SELECT ON MGM.D* TO bindsys@; gives me an error
<7> jink: what did I do wrong there?
<1> kib; specify a domain
<1> kib: "%" for all domains
<7> MalMen: try /etc/my.cnf
<7> aidan: I dont use % because it doesnt allow access form localhost
<8> bindsys@... what?
<1> kib: ... yes it does
<7> my current user tables dont have % or localhost so the login can be used form anywhere
<7> no % doesnt allow localhost
<7> that much I read in the docs
<7> jink: the host field is blank
<7> should I not include @ then?
<7> but trying GRANT SELECT ON MGM.D* TO bindsys@%; also gives error
<1> kib: 'bindsys' not bindsys
<1> kib: these are strings
<1> 'bindsys'@'%'
<11> wpc2388 ~ # mysql -u root -D tracker -p
<11> Enter p***word:
<11> stop here
<11> nots happend nothing :S
<7> GRANT SELECT ON MGM.D* TO 'bindsys'@%; gives error
<7> syntax error
<1> kib: read what I just said!
<7> ok will try quoting the % as well
<1> kib: '%' allows localhost! It's a wildcard! 'localhost' is just another string
<7> GRANT SELECT ON MGM.D* TO 'bindsys'@'%'; is what I just tries
<7> aidan: actualy it doesnt
<7> I tried it many many times
<1> kib: if you have '%'@'localhost
<7> it only matches things not localhost
<1> kib: if you have '%'@'localhost' as an anonymous user, then that account will take precidence
<7> I didnt use '%'@localhost
<7> I sued GRANT SELECT ON MGM.D* TO 'bindsys'@'%';
<7> so its only accepting user bindsys
<1> I wish I could punch people over the internet
<7> but I stil get syntax error
<8> kib: even when forcing tcp? (mysql --protocol=TCP ...)
<9> alright, so, the only option I have is to use an old library? :/
<1> kib: if you have '%'@'localhost' as another account, an anonymous user, then that account will take precidence
<7> jink: I dont have access to what your talking about
<1> kib: but % DOES match localhost
<7> these are applications they dont have a --protocol option
<8> kib: how do you connect to localhost then?
<7> aidan: well why doesnt GRANT SELECT ON MGM.D* TO 'bindsys'@'%'; work
<1> kib: what is the error?
<7> jink: it uses a socket in /tmp/mysql.sock
<7> or something similar
<1> kib: MGM.D* ... what is that meant to be?
<8> kib: that i know. i was referring to the software
<7> aidan: its meant to be any table beginning with D inside of the db called MBM
<7> MGM
<1> kib: well, read the docs on allowing wildcard access to databases
<7> MySQL said: Documentation #1064 - 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 '* TO 'bindsys'@'%'' at line 1
<7> aidan: I did and it showed the use of *
<7> I tried % in the table/db names but those dont seem to work any better
<11> i cant access to sql, neither php nor with ssh
<11> whats can be that????
<11> plz help me
<7> MalMen: is it running?
<11> ywa
<8> kib: try quoting ?
<7> check ps to see if its running
<11> yes
<11> wpc2388 ~ # mysql -u root -D tracker -p
<11> Enter p***word:
<11> i put p***word
<7> jink: are you saying I should use GRANT SELECT ON MGM.D% TO 'bindsys'@'%'; ?
<11> and nots happens more nothing
<7> or GRANT SELECT ON 'MGM.D%' TO 'bindsys'@'%'; ?
<1> kib: no, can you pay attention? If it's not a database or table name, it's a string
<8> kib: no, quoting. like ON `MGM`.`D*`
<7> MalMen: what does ps tell you..is it running?
<11> ****!!!!!
<11> im know now whats be
<11> /dev/hda5 68G 66G 0 100% /
<11> :SSSS
<11> ****!!!!
<11> :S
<7> jink: when what di dyou want me to quote thatIW asnt quotting already?
<8> kib: the database/tables you're granting on
<7> GRANT SELECT ON MGM.D* TO 'bindsys'@'%'; <-- what idd I not quote tha tI should have?
<1> kib: LISTEN
<7> ok
<8> `MGM`.`D*`
<8> quoting
<7> ok so GRANT SELECT ON 'MGM'.'D*' TO 'bindsys'@'%';
<7> I will try that then
<8> aidan: ^_^
<1> I think I want to explode
<8> aidan: take some more breaths :)
<7> GRANT SELECT ON 'MGM'.'D*' TO 'bindsys'@'%'; also syntax error
<7> #1064 - 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 ''MGM'.'D*' TO 'bindsys'@'%'' at line 1
<8> kib: you have trouble reading, isn't it?
<7> jink: I showed yout he command IW as sending andyou said it looke dok
<8> kib: ' != `
<7> I copy/pasted it
<7> jink: that looks the same
<8> kib: but it isn't
<7> single quotes
<8> no, backticks
<7> where to I find backtics?
<1> above the tab key
<8> to the left of your '1'
<7> ~
Return to
#mysql
or
Go to some related
logs:
cciss genkernel
#suse
alsaconf package dapper
gentoo nfs nfssvc function implemented
gnome-mount pendrive
PHP per_dir IIS
sounddex
ubuntu check if a package is installed
php page not found when submit file multipart
#kde
|
|