| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> mySQL error: Unknown column 'f.id' in 'on clause'
<0> Can anyone help me to fix it?
<0> ;>
<1> Platyna> please use pastebin and copy your statement where you got this error and the create table statement, please
<1> Pastebin: hashmysql.org/paste/
<0> Oh well I fixed it myself. :P
<2> 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..
<3> !m ErZo reset root p***word
<4> ErZo: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<2> lsmith: Thank you. I'll sure to read up. :)
<5> hm
<5> how do I use a value from a table in a statement?
<5> like I want to use var=value somewhere, where value should be the value of one particular field in the same table
<1> !tell Shariff about trees
<4> Alrighty.
<2> Does it PM him now? :P
<2> !tell ErZo about trees
<4> Alrighty.
<2> yay
<3> heh
<2> Nice bot. :)
<6> hello
<6> how can i create users in mysql
<1> bwelmers> I'm not sure if it's possible but that would require a subselect in the insert/update statement.
<1> dramen> http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html
<6> thx
<3> bwelmers: col1 = col2 ..
<2> !tell ErZo about p***words
<4> But I don't know a thing about that.
<2> Can I encrypt the root p***wd with the P***WORD type field ?
<2> encrypt/hash
<6> Shariff, sorry but this was not what i meant
<5> ok how does a subselect work?
<1> dramen> then what do you mean?
<6> i just want to create a user
<7> hi
<6> for example create user dramen;
<6> hi siesel
<1> Then you're going to need to do insert statements on the user table in the mysql database
<6> in postgresql i can use createuser dramen when i log in as postgres
<1> dramen> Unfortunately mysql isn't postgresql :)
<8> !m dramen create user
<4> dramen: (CREATE USER Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_USER.html
<6> i need it just because of vpopmail
<1> Oops :D
<1> Sorry about that one :)
<9> :)
<6> oaky thats it
<7> GRANT ALL PRIVILEGES ON mytable TO user@host IDENTIFIED BY "p***word";
<7> can someone help me with this errormessage: ERROR 1305 (42000): FUNCTION mydb.UPPER does not exist
<8> !m siesel UPPERCASE
<4> siesel: Nothing found
<8> umm
<8> might need to use convert
<7> 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");
<7> if I just do select UPPER("lowerstring"); everything is alright
<8> I've never seen that error
<7> happens to occur with both UCASE and UPPER
<7> is there any way to specify a global namespace?
<6> CREATE USER user [IDENTIFIED BY [P***WORD] 'p***word']
<6> [, user [IDENTIFIED BY [P***WORD] 'p***word']] ...
<8> dramen: ok and?
<6> this doesn't work
<8> it does work.
<6> create user dramen;
<8> no
<6> mysql> create user dramen;
<6> ERROR 1064 (42000): Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann fr verschiedene Server-Versionen unterschiedlich sein) bei 'user dramen' in Zeile 1
<6> it's in german
<10> siesel: Remove the space between the function name and the (.
<7> I found the error: UCASE ("sd") ~ dbname.UCASE, but UCASE("sd") is correct
<8> create user dramen indetified by 'foobar';
<10> siesel: Remove the space.
<7> thanks Xgc, I found it out in this very second
<7> I just wonder about this behavior.
<6> mysql> create user dramen identified by 'foobar';
<6> ERROR 1064 (42000): Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann fr verschiedene Server-Versionen unterschiedlich sein) bei 'user dramen identified by 'foobar'' in Zeile 1
<6> hehehe
<8> !m frank- grant syntaxt
<4> frank-: Nothing found
<8> erm
<11> 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'
<11> ?
<10> "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."
<10> The problem is identifying the applicable rules.
<12> asdf
<13> Hi
<12> prff.. What company you work for? MySQL ... Ah, no sir, no reduction for the fitness center... DAMN! .. still wondering why :P
<13> Is there anyway of viewing what mysqld is doing? What tables are accessing? What queries it is running?
<12> archangle25: general query log, SHOW [FULL] PROCESSLIST, strace
<12> bin log shows where it was succesfully updating stuff
<12> ah, weerr
<12> arianne_rpg thus
<13> yeah, I understood you were talking me :)
<12> I hope it was as good as it was for me then :P
<13> That show me the connections
<13> but is there any way of seeing what a connection does?
<12> well, when they do something, it will show, if you lucky
<12> yes
<12> arianne_rpg: general query log
<13> Kemurii: sorry, but how I see it? RTFM? :)
<12> arianne_rpg: hire me
<12> I mean, yes, manual
<12> how this bot works again
<12> !m general query log
<4> general: (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<12> yeah, wheee me
<13> thanks
<12> de nada
<14> can someone tell where mysql databases are usually stored?
<14> in a linux filesystem
<12> poser: RedHat?
<12> poser: /var/lib/mysql
<14> yeah
<15> 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.
<14> thanks
<15> i just get access denied for user. is there a way i can wipe everything and start again?
<12> poser: connect to mysql, do SHOW VARIABLES LIKE 'datadir'; -- that shows the location
<12> foxpaul: you need to be root to do that first
<15> Kemurii: but on ubuntu there's no root account
<12> foxpaul: only the root user has by default the permissions to do that.. he can create users which have 'WITH GRANT OPTION'
<12> foxpaul: that can not be, broken, f*** unbuntu
<15> Kemurii: is there a way i can see who might have the right permissions?
<12> foxpaul: put in the my.cnf skip-grant-tables , that starts MySQL totally open, and check the mysql.user table for entries
<12> foxpaul: I think it is best to ask the Unbuntu folks there.. :/
<15> ok cheers
<12> foxpaul: there should be a root user, I mean, if it is missing.. that's an installation problem
<12> foxpaul: this is installed using the packages of Unbuntu/Debian?
<15> Kemurii: ubuntu is like osx, there's no root. just a user who has root access via sudo
<12> foxpaul: not talking about system user root there, the MySQL root user
<12> MacOSX has a root user
<12> ah
<12> nvm, now I see what you mean with sudo :P
<15> what do i do in the case of no mysql.user table exists?
<12> :)
<12> foxpaul: mysql_install_db script must be run
<15> Kemurii: thanks a lot for your help - i'll try that
<12> foxpaul: worries me that it you got problems like that on Unbuntu
<12> need to check that
<12> foxpaul: what Unbuntu is that?
<12> Ubuntu
<12> why I call it Unbuntu.. huh
<15> 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
<16> 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
<16> i meant row
<12> 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
<12> ph8: you missing quotes
<12> ph8: datefield > '2005-12-12'
<16> 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
|
|