| |
| |
| |
|
Page: 1 2
Comments:
<0> can someone please explain the correct procedure to *remove* a user from mysql? I'm following the instructions here: http://dev.mysql.com/doc/refman/5.0/en/grant.html ... i'm apparently doing something wrong, but i do not know what...
<0> if i do "revoke all from username", i get a syntax error... if i do: REVOKE ALL PRIVILEGES, GRANT OPTION FROM username, i get this: ERROR 1269 (HY000): Can't revoke all privileges, grant for one or more of the requested users
<0> "drop user username" results in:ERROR 1268 (HY000): Can't drop one or more of the requested users
<0> ideas anyone?
<0> right then... i'm wiping what i have and going back to postgres. this is utterly insane.
<1> I can't find on the mysql site where they talk about considerations when upgrading from 4 to 5. Is anyone using 5 in a production environment?
<1> I really would like triggers and foreign keys with myisam tables.
<2> please, i have a field in my table that i insert things like: 01:1, 01:70, 01:90
<3> funny leandro
<3> i do to have a field in my table that i insert things in
<3> strange coindence
<2> but when have 01:99 or 10:100
<2> and i need got the max substring : -1
<2> it return 99 is max
<2> not 100, 101, 102..
<2> grazzy lol sorry, i was typind
<2> *typing
<3> why not store them separated?
<2> because its a code of products you know
<2> i'm using SELECT MAX(substring_index(id,':',-1)) FROM...
<2> what i need to do?
<4> hi, a simple question: what command line is necesary to pause, for example, the data of a long table?
<4> i write:
<4> shell>DESCRIBE mytable;
<4> but it is too long, amd i need to view it by parts---
<4> oh
<4> thanks anyway
<5> Hey, in tables_priv, what the grantor is for ?
<2> SELECT cast(MAX(substring_index(id,':',-1)), int) FROM kb_mercadorias WHERE id LIKE '01:01:01:02:01:%' LIMIT 1
<2> whats wrong?
<6> I need some help with mysql administration and use. I'm new to it and am having difficulty.
<6> Is anyone able to help me out?
<7> anyone?
<7> K_F?
<7> Dark_Rain?
<8> yes?
<7> http://rafb.net/paste/results/e6gFkj69.html
<7> if i have 100 ips graned... i need 100 revokes???
<9> is there an internal mysql function for "and bits" .. ie SELECT * from table where accessmask & id
<10> hey, i installed XAMPP on my linux, how do i enable CLI mode? ...
<11> get the **** out
<11> if you're not able to install some applications manually we certainly don't want you here
<12> Deface K_F ? (c:
<12> oops
<12> shesh
<13> huh?
<12> I've been talking to drunk people
<12> Decafe K_F
<12> (c:
<13> not had any coffee so long..
<12> Don't mind me, I speak backwards 2
<13> just put a pot on the maker
<12> hehe
<14> not yet no
<14> oopz, wrong window
<15> i recently upgrade from mysql 5.0.2 alpha to the latest 5.0 build, i noticed that now when i start the server i see only 1 process of mysqld running, what setting do i change in my.cnf so it will spawn more daemon processes
<15> i recently upgrade from mysql 5.0.2 alpha to the latest 5.0 build, i noticed that now when i start the server i see only 1 process of mysqld running, what setting do i change in my.cnf so it will spawn more daemon processes
<13> would be a compile setting, but it probably does
<13> just as threads..
<13> man ps
<13> look into the -L flag for one
<15> before when i do a ps -fax i used to see more than 1 mysqld
<15> now i only see 1 mysqld
<13> <13> look into the -L flag for one
<15> its -m
<15> i guess ur on sun :-)
<15> aha
<15> it does it does :-)
<15> thx
<13> the sound certification system?
<13> damn I like this new server, fast as hell
<15> cool
<13> has a 10000rpm SCSI drive in it
<13> The server I ordered is a Dell PowerEdge SC1420. I ordered one with a Intel Xeon" prosessor (3.00GHz, 2MB cache, 800MHz FSB) and 1GB DDR2 SDRAM (2MB 400MHz DIMMs). It come with a 73GB SCSI Ultra320 (10000rpm) 12 68 pin harddisk.
<15> nice
<13> the ****ers delivered it in just a week as well
<15> we stoped ordering dell and went with compaq because compaq had the ILO
<13> ordered it last friday
<15> cool.
<15> with dells we had to maintain Alterpaths for remote KVMs and power with ILO we dont need that anymore
<16> someone can help me
<13> 911?
<16> box01# /usr/local/bin/safe_mysqld --skip-networking --user=mysql
<16> Starting mysqld daemon with databases from /var/db/mysql
<16> 060127 12:23:32 mysqld ended
<13> and the error log says?
<16> 060127 12:23:32 /usr/local/libexec/mysqld: Can't create/write to file '/var/db/mysql/box01.myftp.org.pid' (Errcode: 13)
<16> 060127 12:23:32 /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist
<16> 060127 12:23:32 /usr/local/libexec/mysqld: Error on delete of '/var/db/mysql/box01.myftp.org.pid' (Errcode: 2)
<16> 060127 12:23:32 mysqld ended
<16> do u can help me or not ?
<3> the problem(s) are clearly described there?
<16> how to solve the problem
<16> i want to know this
<17> k is there a way to overcome gaps that occurs in auto_increment fields when they are rolledback?
<13> you shouldn't
<13> http://www.kfwebs.net/links/59 if you need to refreshen your DB designing skills
<18> y can remove and recreate the colume
<13> Eldritch: you can alter it, the point is you shouldn't
<13> the DB logic shouldn't conflict with the business logic
<13> or rather, you shouldn't use db logic for business logic
<13> so gaps shouldn't matter
<18> depends on the circumstances
<17> k then how could i solve this situation where i got 2 tables lets say t1 and t2 , where 1 to many relation exists between them
<17> i am inserting values from same form to them first to t1 and then according to the result to t2
<17> when ever a rollback situation comes up
<17> id colum of t1 keeps incresing
<17> and i m doing it form web
<17> :(
<17> php/mysql web based way
<17> so it could be exploited
<17> if i keep tring to insert data with invalid format it will rollback and if i do it like (2^32)-1 times and then insert a valid data then i dunno what would happen
<3> a properly designed db shouldnt be depending on increasing primary keys
<3> you should be able to use a random value
<17> k then how could i solve this situation where i got 2 tables lets say t1 and t2 , where 1 to many relation exists between them
<17> <17> i am inserting values from same form to them first to t1 and then according to the result to t2
<17> <17> php/mysql web based way
<17> <17> so it could be exploited
<17> yea but how can be sure that randomness would give me uniqueness as well?
<17> time seeds?
<17> with a formula?
<17> i m not that good at math
<17> so i wouldnt know if anything i do would produce %100 unique ids any time
<13> a unique constraint..
<3> http://se2.php.net/uniq_id
<13> heck use a random sha512 string
<17> k ty
<13> huh?
<17> i ll use unique constraint with uniq_id() in php
<17> but auto_increment way could be cheaper and easier if worked :\
<17> well this seems to work too
<17> and seems more secure as well
<13> if you want security you mix two fields
<13> put a clustered unique constraint on it
<17> :)
<13> ?
<17> no need to execurate
<13> why do you think they moved from only specifying a p***word to specifying a username AND p***word
<17> i am just doing a simple orders form for a local network
<17> not that i found it silly
<13> hmm, hint, don't talk security with me..
<13> you'll get bored within 10 minutes
<17> only security i know of are ready to setup security packs like firewalls virus,rootkit,trojan scanners
<17> but i am gonna try to compile mysql with ssl when i am done with what i am doing
<13> http://www.secure-my-email.com if you want to read up on OpenPGP
Return to
#mysql
or
Go to some related
logs:
#linux
cyberblade ubuntu 3d
12WHO WAS THE TITLE CHARACTER IN THE MERCHANT OF VENICE ?
#php
#linux
#chatzone
#php
qalbi/ london
#teens
linuxhelp postfix dovecot
|
|