| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> just a hunch
<1> and amarok cant and mysqladmin cant
<0> try host as the first argument
<2> !perror 2
<3> System error: 2 = No such file or directory
<1> hm
<1> that's true:(
<1> wow
<1> work
<0> details?
<1> was a buggy config by default
<0> all is swell. fire uid 0
<1> by default made /var/run/mysqld/mysqld.sock, i fix to mysqld-500.sock
<4> just installed mysql, and after running it for the first time i got the message to change p***word, so i did...
<4> root@neo:/usr/share/mysql# /usr/bin/mysqladmin -u root p***word 'itdoesntmatter'
<0> then why did you specify --host ?
<4> /usr/bin/mysqladmin: connect to server at 'localhost' failed
<4> error: 'Access denied for user 'root'@'localhost' (using p***word: YES)'
<4> root@neo:/usr/share/mysql#
<0> blackthorne: -u <user> -p <database>
<1> thank you for the help
<4> what database? i have never acessed the service. Just turned it on
<0> consult man for the options then
<4> i have an installed mysqld running with settings by default but can't login or even change the p***word
<4> could someone help me?
<4> thanks anyway, try some other day with more pacience
<5> I've configured made && made install, but I don't have innodb tables. ./configure --help | grep innodb only gives the --without-innodb option
<6> moin
<7> I've been having problems with sorting a semi-large table. It fails after crunching for a while with error 28 in creating a file in /tmp. I'm pretty sure I have enough space.
<7> Now I'm noticing console messages and lines in syslog with "klogd: page allocation failure." Could this possibly be related?
<7> er, meant "kswapd0: page allocation..."
<5> I've configured made && made install, but I don't have innodb tables. ./configure --help | grep innodb only gives the --without-innodb option - how do I get innodb support?
<8> dont specify without-innodb
<5> damir: oh come on :)
<5> I've done that, no innodb
<9> aidan: well a good start is compiling again without "--without-innodb"
<9> Then it can be troubleshooted
<5> .. why would I compile with --without-innodb
<9> aidan, nevermind, I thought you already had.
<5> X13: I must have worded my question poorly, sorry
<9> aidan: probably not; it's late here
<5> $ ./configure --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/usr
<5> that's my configure line, according to config.log
<5> is there a command I get the supported data types from?
<10> is there something that needs to be invoked in mysql 5 before even root can add grant perms?
<10> as i'm guessing the following should work GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.2' WITH GRANT OPTION;
<10> but it doesn't seam to update as show grants doesn't list it
<10> i havn't done this is a while.. what am i missing here :)
<10> plaa: got a sec
<11> yes?
<10> great
<10> this should be reall simple
<10> i havn't done this is a while.. what am i missing here :)
<10> as i'm guessing the following should work GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.2' WITH GRANT OPTION;
<10> mysql 5
<10> just trying to add access to everything from a local machine
<10> that command is good sytax wise, but show grants; doesn't list a second entry
<10> just the regular local host
<10> any ideas?
<11> no idea sry
<10> worth a shot
<10> thanks
<12> can I have now() as default on a datetime field?
<13> Can it be even remotely safe to attempt to bring back a database from an older 5.x database FILES to a newer 5.x?
<13> If the old server is Totally Effed (tm)
<14> Say I have a datetime col, now can I get the amount of hours that has p***ed from a row? I.e. SELECT col - NOW() = time p***ed?
<14> SELECT UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP(NOW()) look good?
<15> is it possible to install 5.0 and 4.1 on the same machine
<16> can i ask permission to ask a question?
<16> | Innodb_buffer_pool_pages_free | 83200 |
<16> | Innodb_buffer_pool_pages_total | 83200 |
<17> how do i resolve this on my linux box,The version of mysql emerged now stils is _NOT_ the default
<17>
<16> looks like innodb is not in use, why is that?
<6> lazy_: because your tables are not created to use innodb?
<16> yes, so it seems
<18> i was looking at insert ... on duplicate key update
<18> and i want to use it but i dont have any unique cols
<19> thnee: then you will never have duplicates anyways
<18> only the combination of two cols are unique in my table, hence all WHERE's refering to the table has to have two statements
<19> thnee: you can have any number of columns inside a unique or primary key
<18> yes but i dont want the cols unique, only the combinations of values in them
<18> its like filename and category
<18> files can have the same name in diferent categories
<18> but every row is unique if you combine the two
<16> just do primary key(filename,category) and it works that way
<6> thnee: read above
<18> hm
<18> so if theyre both primary
<18> but doesnt that mean that they both have to be unique? unrelated to eachoter
<19> it means the combination needs to be unique
<18> oh =), great
<18> so on duplicate key will only think that its duplicate only one of them already exists
<18> will not think*
<6> WILL NOT
<6> aaarghhhh
<18> domas: arg arg to you too
<18> thanks guys
<18> this sounds really useful
<6> this is basics
<6> not 'useful'
<18> hah ok
<18> mysql> alter table downloads add primary key(`category`);
<18> ERROR 1068 (42000): Multiple primary key defined
<18> oh wait, i need to add them both at the same time
<20> Thank you for your offer to help. I have one simple question about a SELECT query. I have a table with these datas: (cartype, price) = (1,3) (1,2) (1,6) (1,7) (2,0) (2,6) (2,4). I want to select the cartypes with the highest prices, here (1,7) and (2,6). And how could I select the second highest prices? Thank you very much.
<20> I thought about using GROUP BY cartype , but that does not give me the highest price of the cartype ...
<6> MAX(price) GROUP BY cartype
<20> okay, thanks!!!
<20> my original table has one more field, so its (1,3,x) (1,2, x) (1,6,x) (1,7,x) (2,0,x) (2,6,x) (2,4,x) where x is different in each table. How could I select now the cartype with the highest price AND the x - value?
<20> It's like every car has a different color and I want to select the cartype, price and color from the priciest cartype.
<21> wont this do -> select carType, max(price), color as price from test1 group by carType
<20> Thanks karthik, I will check this!!!
<20> It's not working.
<20> Database tells me that "color" is not in aggregated function or something like this ... :-(
<21> it should work there was a slight mistake in alias placement otherwise the query is correct
<21> select carType, max(price) as price, color from test1 group by carType
<20> thanks, but there is no relation between color and max(price). All I know is that you could do this with SELECT DISTINCT ON (cartype) * FROM foo ORDER Y cartype, price; (but that does only work in postgre)
<10> hye guys, if i wanted to add a local machine 192.168.0.2 access to all databases as root, should i just add the following "GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.2' WITH GRANT OPTION;" (mysql5)
<10> i look syntaticly corect but i do not see it in show grants
<10> shoudl be simple root is there as local host i just need to permit 192.168.0.2 access to it
<10> if someoen could through that at me i'd realy apprciate it
<18> are all data supposed to be '-qutoted? or only strings but not numbers?
<22> only strings literal
<18> literal?
<22> strings that are actual strings
<22> as opposed to e.g. table names
<22> or keywords
<18> ah ok
<22> usr: what's the problem?
<18> yeah. ok thanks
<22> usr: your syntax is correct
<10> Darien: it went in but no rows were effected and show grants doesn't show the new grant
<10> Darien: Its been a bit so i'm not sure what i'm doing wrong
<10> Darien: Shouldn't show grants as root show all grants listed as root, so a second entry for 'root'@'192.168.0.2'
<22> no
<22> show grants for 'root'@'192.168.0.2';
<22> 'root'@'192.168.0.2' is a *different user* than 'root'@'localhost'
<22> so it's not going to show the grant
<23> is there a mysql cli command to dump a table's or a whole database's structure and contents to a file that i can pipe back to mysql on another machine to recreate everything ??
<10> mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.2' WITH GRANT OPTION;
<10> Query OK, 0 rows affected (0.00 sec)
<10> should it come back with 0 rows effected
<10> nm
<10> i'm a morrong
<10> thanks guys
<10> Darien: thank you
<22> :)
<22> np :)
<10> so this is all that is needed right
<10> now i can connect from 192.168.0.2
Return to
#mysql
or
Go to some related
logs:
#math
prototype NS_ERROR_NOT_AVAILABLE
ubuntu slow dns
#javascript
#debian
#osdev
+bash +space string
sh: -c: line 1: syntax error near unexpected token `newline'
#perl
#debian
|
|