| chadmaynard | lol |
| UltraVi01 | well, it seemed simple |
| chadmaynard | look: |
| Megiddo | Is it safe to compare TIMESTAMP with greater and less than? IE, NOW() < eventtime |
| SarahS | Megiddo: Yep |
| Megiddo | Sweet, thanks |
| chadmaynard | SarahS is sweet |
| Megiddo | Indeed |
| action | SarahS blushes |
| SarahS | blushes /quit |
| MysticOne | hi all, hopefully quick question ... I'm using MySQL 5.0 (haven't used it in a while), just created a database, created a user, set the password, granted the user all on the database ... but it won't let me access the database as that user I just keep getting access denied could anyone possibly point me in the right direction? |
| ollie | what are you trying to accesss it from e.g php? |
| MysticOne | mysql commandline client basically mysql --user=myuser -p databasename it prompts me for the password, I enter it, then it says access denied |
| ollie | create another user and see if that works, it is possible that you made a typo when setting password mysql does not ask for a confirmation |
| MysticOne | I'm certain I didn't, set it again to be sure :) I'll try creating another user anyway, though |
| ollie | also are you accessing it from the server or via ssh? |
| MysticOne | I'm logged into the server via ssh, and accessing it locally |
| raf256 | what typ to use to hold a yes/no value |
| ollie | boolean I ask because I think i remmeber having a similiar problem where by when i used shh it didn't work but when i logged into the server itself using a keyboard/video/mouse connected it worked |
| chadmaynard | bool = tinyint(1) |
| ollie | might of been something else though |
| MysticOne | Ollie: well the server is about 3k miles away ... so not going to be logging in that way :) |
| ollie | chadmaynard, :) |
| raf256 | so TINYINT length 1 yes? |
| ollie | fair enough |
| raf256 | but 1 is 1 digit not 1 byte? |
| MysticOne | it says 'user'@'localhost' when I attempt to login, though |
| ollie | yes so you store 1 for yes 0 for no |
| raf256 | also it can store like 4 or 7 can I have for just 0 or 1 perhaps binary would help? TINYINT length 1 binary? |
| ollie | yeah you could have any 1 length digit |
| luke-jr | SQL should have an IP-ADDRESS type or something so buggy coders can't use a varchar(15) for it :p |