#mysql - Thu 12 Apr 2007 between 00:28 and 00:53

NY Lost Funds



CareBear\hacim : Read up on how character sets and encodings work in 5. It's a very handy system, but you'll have to tell MySQL what you want so it does the right thing.
hacimCareBear\: any suggestions of what or where to read?
CareBear\hacim : Chapter 10 in the manual
hacimthanks
CareBear\No problem. http://dev.mysql.com/doc/refman/5.0/en/charset.html
What about gaps before index records?
Specifically "before" ?
Kazani'm having problems with permissions - specifically a user who is supposed to be able to GRANT other users permissions getting denied access... anyone able to lend me a hand?
CareBear\How are index records ordered?
Ie. what would come before an existing index record?
chadmaynardKazan: you granted with the grant option?
seekwillCan anyone help me? I need someone to visit porn sites and enter in my E-mail address?
Kazanchadmaynard: do you mean the user has GRANT?
chadmaynardseekwill: see ##php
Kazanchadmaynard: yes, globally and on the DB
CareBear\Hahaha.
chadmaynardKazan: do SHOR GRANTS; when logged in as the problematic user. Pastebin that. Also pastebin the grant that errors out
SHOW**
Kazanyup
i got it.. two lines
i can waste a pastebin on two lines.. or copy it here
chadmaynardpastebin
the_wenchtry http://pastebin.ca
Kazanhttp://pastebin.ca/435713
the global has "identified by password".. but the dba specific one doesn't
(this user was setup by phpMyAdmin)
chadmaynardwhats with the backslash (\) ?
Kazan_ is a wildcard in db names when used in GRANT
so you have to escape it
chadmaynardso its spelled right? minerva?
Kazanyes
chadmaynardwhat are you running that causes an error?
KazanGRANT SELECT,UPDATE,INSERT,DELETE ON `minerva\_test`.* TO 'testuser'@'%'
gives me ERROR 1044 (42000): Access denied for user 'cs309r4'@'%' to database 'Minerva\_test'
cs309r4's priveleges were flushed weeks ago
well... a week
so it's not that :D
the server has been rebooted a good 20 times :D (i kept breaking ldap very nastily :D)
CareBear\These deadlocks are making me insane. Assuming I'm not the first person ever to run into this trouble, how do people debug lock contention?
chadmaynardCareBear\: with a hammer

Page: 2 9 16 23 30 37 44 51 58 65 72 79 86 93 

IrcArchive

NY Lost Funds