| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<Platyna> mySQL error: Unknown column 'f.id' in 'on clause'
<Platyna> Can anyone help me to fix it?
<Platyna> ;>
<Shariff> Platyna> please use pastebin and copy your statement where you got this error and the create table statement, please
<Shariff> Pastebin: hashmysql.org/paste/
<Platyna> Oh well I fixed it myself. :P
<ErZo> I'm using mysql-4.1.14. And in some bizzare way, I made my p***word too strong and forgot what it ws. I'm meaning, the root p***word of course..
<lsmith> !m ErZo reset root p***word
<SQL> ErZo: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<ErZo> lsmith: Thank you. I'll sure to read up. :)
<bwelmers> hm
<bwelmers> how do I use a value from a table in a statement?
<bwelmers> like I want to use var=value somewhere, where value should be the value of one particular field in the same table
<Shariff> !tell Shariff about trees
<SQL> Alrighty.
<ErZo> Does it PM him now? :P
<ErZo> !tell ErZo about trees
<SQL> Alrighty.
<ErZo> yay
<lsmith> heh
<ErZo> Nice bot. :)
<dramen> hello
<dramen> how can i create users in mysql
<Shariff> bwelmers> I'm not sure if it's possible but that would require a subselect in the insert/update statement.
<Shariff> dramen> http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html
<dramen> thx
<lsmith> bwelmers: col1 = col2 ..
<ErZo> !tell ErZo about p***words
<SQL> But I don't know a thing about that.
<ErZo> Can I encrypt the root p***wd with the P***WORD type field ?
<ErZo> encrypt/hash
<dramen> Shariff, sorry but this was not what i meant
<bwelmers> ok how does a subselect work?
<Shariff> dramen> then what do you mean?
<dramen> i just want to create a user
<siesel> hi
<dramen> for example create user dramen;
<dramen> hi siesel
<Shariff> Then you're going to need to do insert statements on the user table in the mysql database
<dramen> in postgresql i can use createuser dramen when i log in as postgres
<Shariff> dramen> Unfortunately mysql isn't postgresql :)
<frank-> !m dramen create user
<SQL> dramen: (CREATE USER Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_USER.html
<dramen> i need it just because of vpopmail
<Shariff> Oops :D
<Shariff> Sorry about that one :)
<Sembiance> :)
<dramen> oaky thats it
<siesel> GRANT ALL PRIVILEGES ON mytable TO user@host IDENTIFIED BY "p***word";
<siesel> can someone help me with this errormessage: ERROR 1305 (42000): FUNCTION mydb.UPPER does not exist
<frank-> !m siesel UPPERCASE
<SQL> siesel: Nothing found
<frank-> umm
<frank-> might need to use convert
<siesel> this is the statement: SELECT t0.gnue_name, t0.gnue_module, t1.gnue_id, t0.gnue_id FROM gnue_cl*** as t0 LEFT JOIN gnue_module as t1 ON t1.gnue_id = t0.gnue_module WHERE (UCASE (t0.gnue_name) = "PERSON") AND (UCASE (t1.gnue_name) = "ADDRESS");
<siesel> if I just do select UPPER("lowerstring"); everything is alright
<frank-> I've never seen that error
<siesel> happens to occur with both UCASE and UPPER
<siesel> is there any way to specify a global namespace?
<dramen> CREATE USER user [IDENTIFIED BY [P***WORD] 'p***word']
<dramen> [, user [IDENTIFIED BY [P***WORD] 'p***word']] ...
<frank-> dramen: ok and?
<dramen> this doesn't work
<frank-> it does work.
<dramen> create user dramen;
<frank-> no
<dramen> mysql> create user dramen;
<dramen> ERROR 1064 (42000): Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei 'user dramen' in Zeile 1
<dramen> it's in german
<Xgc> siesel: Remove the space between the function name and the (.
<siesel> I found the error: UCASE ("sd") ~ dbname.UCASE, but UCASE("sd") is correct
<frank-> create user dramen indetified by 'foobar';
<Xgc> siesel: Remove the space.
<siesel> thanks Xgc, I found it out in this very second
<siesel> I just wonder about this behavior.
<dramen> mysql> create user dramen identified by 'foobar';
<dramen> ERROR 1064 (42000): Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei 'user dramen identified by 'foobar'' in Zeile 1
<dramen> hehehe
<frank-> !m frank- grant syntaxt
<SQL> frank-: Nothing found
<frank-> erm
<Kound> If i want to add a '/' to every SELECT, do I need to add a view or is it simple to modify the SELECT Command to SELECT userid||'/' FROM addys WHERE mail_addy='%s'
<Kound> ?
<Xgc> "white space: Characters used to separate tokens in SQL text; white space may be required (for example, to separate <nondelimiter token>s from one another) and may be used between any two tokens for which there are no rules prohibiting such use."
<Xgc> The problem is identifying the applicable rules.
<Kemurii> asdf
<arianne_rpg> Hi
<Kemurii> prff.. What company you work for? MySQL ... Ah, no sir, no reduction for the fitness center... DAMN! .. still wondering why :P
<arianne_rpg> Is there anyway of viewing what mysqld is doing? What tables are accessing? What queries it is running?
<Kemurii> archangle25: general query log, SHOW [FULL] PROCESSLIST, strace
<Kemurii> bin log shows where it was succesfully updating stuff
<Kemurii> ah, weerr
<Kemurii> arianne_rpg thus
<arianne_rpg> yeah, I understood you were talking me :)
<Kemurii> I hope it was as good as it was for me then :P
<arianne_rpg> That show me the connections
<arianne_rpg> but is there any way of seeing what a connection does?
<Kemurii> well, when they do something, it will show, if you lucky
<Kemurii> yes
<Kemurii> arianne_rpg: general query log
<arianne_rpg> Kemurii: sorry, but how I see it? RTFM? :)
<Kemurii> arianne_rpg: hire me
<Kemurii> I mean, yes, manual
<Kemurii> how this bot works again
<Kemurii> !m general query log
<SQL> general: (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<Kemurii> yeah, wheee me
<arianne_rpg> thanks
<Kemurii> de nada
<poser> can someone tell where mysql databases are usually stored?
<poser> in a linux filesystem
<Kemurii> poser: RedHat?
<Kemurii> poser: /var/lib/mysql
<poser> yeah
<foxpaul> hi all. i'm struggling with getting mysql setup on an ubuntu box. i can log in using mysql -u user -p, but cant create or grant etc.
<poser> thanks
<foxpaul> i just get access denied for user. is there a way i can wipe everything and start again?
<Kemurii> poser: connect to mysql, do SHOW VARIABLES LIKE 'datadir'; -- that shows the location
<Kemurii> foxpaul: you need to be root to do that first
<foxpaul> Kemurii: but on ubuntu there's no root account
<Kemurii> foxpaul: only the root user has by default the permissions to do that.. he can create users which have 'WITH GRANT OPTION'
<Kemurii> foxpaul: that can not be, broken, f*** unbuntu
<foxpaul> Kemurii: is there a way i can see who might have the right permissions?
<Kemurii> foxpaul: put in the my.cnf skip-grant-tables , that starts MySQL totally open, and check the mysql.user table for entries
<Kemurii> foxpaul: I think it is best to ask the Unbuntu folks there.. :/
<foxpaul> ok cheers
<Kemurii> foxpaul: there should be a root user, I mean, if it is missing.. that's an installation problem
<Kemurii> foxpaul: this is installed using the packages of Unbuntu/Debian?
<foxpaul> Kemurii: ubuntu is like osx, there's no root. just a user who has root access via sudo
<Kemurii> foxpaul: not talking about system user root there, the MySQL root user
<Kemurii> MacOSX has a root user
<Kemurii> ah
<Kemurii> nvm, now I see what you mean with sudo :P
<foxpaul> what do i do in the case of no mysql.user table exists?
<Kemurii> :)
<Kemurii> foxpaul: mysql_install_db script must be run
<foxpaul> Kemurii: thanks a lot for your help - i'll try that
<Kemurii> foxpaul: worries me that it you got problems like that on Unbuntu
<Kemurii> need to check that
<Kemurii> foxpaul: what Unbuntu is that?
<Kemurii> Ubuntu
<Kemurii> why I call it Unbuntu.. huh
<foxpaul> Kemurii: it's breezy - but i have ran a few mysql admin programs on this machine, so they might have messed it up a bit
<ph8> Hi all, I've got a quick question about comparing DATE fields to string values, I'm using date > 2005-10-01 - but that doesn't seem to work, it's matching every column in the table and there are lots of 2004-09-03 etc in there
<ph8> i meant row
<Kemurii> foxpaul: anyway, best to download the Linux binaries from dev.mysql.com/download, follow the Install instructions in docs.. goes for all Linux distro's and works great
<Kemurii> ph8: you missing quotes
<Kemurii> ph8: datefield > '2005-12-12'
<ph8> hmm i'll give it a go
Return to
#mysql
or
Go to some related
logs:
#perl
udma osdev
septic tank nohup
unmasking packages with missing keywords
#lisp
module xt_state
#debian
libwx_gtk2u_core-2.6 debian
VNC and xgl
#php
|
|
