|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.|
|hacim||CareBear\: any suggestions of what or where to read?|
|CareBear\||hacim : Chapter 10 in the manual|
|CareBear\||No problem. http://dev.mysql.com/doc/refman/5.0/en/charset.html|
What about gaps before index records?
Specifically "before" ?
|Kazan||i'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?
|chadmaynard||Kazan: you granted with the grant option?|
|seekwill||Can anyone help me? I need someone to visit porn sites and enter in my E-mail address?|
|Kazan||chadmaynard: do you mean the user has GRANT?|
|chadmaynard||seekwill: see ##php|
|Kazan||chadmaynard: yes, globally and on the DB|
|chadmaynard||Kazan: do SHOR GRANTS; when logged in as the problematic user. Pastebin that. Also pastebin the grant that errors out|
i got it.. two lines
i can waste a pastebin on two lines.. or copy it here
the global has "identified by password".. but the dba specific one doesn't
(this user was setup by phpMyAdmin)
|chadmaynard||whats with the backslash (\) ?|
|Kazan||_ is a wildcard in db names when used in GRANT|
so you have to escape it
|chadmaynard||so its spelled right? minerva?|
|chadmaynard||what are you running that causes an error?|
|Kazan||GRANT 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?|
|chadmaynard||CareBear\: with a hammer|