| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> why does it refuse to let me access :(
<1> try without -u
<0> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<0> :(
<1> did set the root p***word?
<1> oops, make that without the -p
<0> thats the bit i screwed up, initially setting root p***word, i've tried the mysql.com way of reseting it, the --skip-grant-tables way, which just tells me i cant change p*** when mysql was started with that option
<1> sorry
<0> same again
<1> what os?
<0> freebsd 6
<1> did you shutdown the server before doing all that stuff?
<0> doing all the --skip-grant-table?
<1> before the mysql_install_db script?
<0> yeah
<0> hm, i can't kill the server now >.<
<0> just restarts :/
<1> kill the process
<0> i am lol
<0> www# kill -9 21543
<0> www# Killed
<0> 060327 21:06:37 mysqld restarted
<0> er, nice one mysqld...
<2> DONT -9 mysqld use -15
<1> i've never had these problems, never even heard of them
<3> Hi, how do i delete "relationshiplines" in mysqlworkbench? really anoying?
<0> ah, -15 worked, thanks
<2> -9 does not allow the server to clean up , you will likely damage your data
<0> :o
<1> with the install_db script i just ***umed there wasn't any yet
<4> i have an error
<4> anybody can help pelease
<4> [root@LHR-PBX asterisk-perl-0.08]# /home/cron/astguiclient/ADMIN_area_code_populate.pl
<4> Access denied for user 'cron'@'RHEL-TAC-TEST' (using p***word: YES) at /home/cron/astguiclient/ADMIN_area_code_populate.pl line 19
<2> use the correct user/p***word
<4> archivist: sir, were can i check this p***word? :S
<5> to be safe, is it good to always wrap columns with `<column>` so that mysql doesn't misinterpret column names that may conflict with internal functions/types (?), like "char"?
<6> yes
<6> Dr-Linux - try logging in manually
<4> sjrussel: i can login to mysql using "cron" user with it's p***word it works
<5> okay, because i've always made a habit of doing so but i often (and i mean often) see people simply write column names without wrapping them in anything like `
<4> but this command gives me an error :S
<6> from the same server, to the same database/tables?
<5> i guess it's okay shorthand sometimes when you're typing in by hand rather than a script or something.
<6> its good for future proofing.. but you probably should avoid reserved words anyway
<4> Access denied for user 'cron'@'RHEL-TAC-TEST' (using p***word: YES) at /home/cron/astguiclient/ADMIN_area_code_populate.pl line 19
<4> 'cron'@'RHEL-TAC-TEST' << where can i change this is not my server name anymore :S
<5> /etc/hosts
<4> jeef: lemme check
<7> any way to use DSNs for connections with connector/net?
<4> now this error ?
<4> [root@LHR-PBX astguiclient]# /home/cron/astguiclient/ADMIN_area_code_populate.pl
<4> Client does not support authentication protocol requested by server; consider upgrading MySQL client at /home/cron/astguiclient/ADMIN_area_code_populate.pl line 19
<4> even i changed the p***word but still same happend :S
<2> !man old client
<8> (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<3> Can someone help me understand why i cant paste this into mysql> http://pastebin.com/625591
<9> I know this is more of a general database topic, but I'm using a MySQL database in this case and I thought someone in here might have some input. I've got a table of categories. Each category can have a single parent (each record has a field to contain the primary key value for the parent category). I want to be able to quickly get a listing of all categories "under" a single "top-level" category. Any ideas on how to approach this problem?
<10> there's no simple way to do that in sql with that schema
<9> I had thought of adding an additional field to essentially "cache" the top-level parent category per record, but I wasn't sure if there was some better way I wasn't seeing.
<10> if you can muck with the table design, search around for the "nested sets" model
<9> fsweeter: Can you suggest an alternate schema that might be more conducive?
<10> it's a decent way of doing trees insql
<2> !tell Elazar about trees
<8> Alrighty.
<9> fsweeter: Cool, thanks for the info.
<10> no prob =)
<11> Those docs are really great! :D
<4> [root@LHR-PBX astguiclient]# /home/cron/astguiclient/ADMIN_area_code_populate.pl
<4> Access denied for user 'cron'@'localhost' (using p***word: YES) at /home/cron/astguiclient/ADMIN_area_code_populate.pl line 19
<4> ****, never solved this damn problem for me :( :(
<2> you didnt read the docs then
<12> Bah, the docs **** anyway.
<2> keep typing mhillyer to improve them
<12> lisdhfioahsdflkhljshvcmdbsfmhdsjlgfhljghjkeryjlghlsfdhgldshf
<2> ah yes
<12> That's going into the OS X install section.
<2> I dont care, cant afford over priced Apples
<13> hey.. not overpriced.. they are priced at the level they perform
<12> Get a mini ;)
<14> i have one table.. it contains images, each image has a field named "profile", which says what profile owns the image.. how can do i select statement that lists the profiles and the number of images each of them owns?
<12> Heh, I'm not sure there, I can by two good Intel boxn for the price of an Xserve, I'd have to know the Xserve could actually handle twice the traffic.
<12> SELECT profile, COUNT(profile) GROUP BY profile;
<5> is there a mysql function for generating something random (anything, text, numbers, whatever)
<5> ?
<12> RAND()
<5> good enough, thanks :)
<1> tech-, select profile, count(image) as count from table group by profile;
<14> beebum, mhillyer already gave me the answer :)
<14> thank you both :)
<15> mhillyer's answer is wrong!
<1> ah, i see it now
<15> mhillyer needs to learn SELECT syntax!
<1> yes, that just gives number of profiles not images
<16> and typing
<17> hello
<12> beebum: Not if you ***ume one big table with a row per image each of which has a profile entry.
<12> But I think will was criticizing the lack of FROM.
<15> ;)
<15> And ORDER BY... and LIMIT... and two joins...
<1> " the number of images each of them owns?"
<12> What he forgets is that I use a special custom build that requires all that.
<15> A few subselects would have been nice.
<0> i'm guessing
<0> www# /usr/local/etc/rc.d/mysql-server.sh status
<0> www#
<0> isn't a good thing?
<18> i buggered up my security on a server, anyone point me to a reset everything process?
<17> i need some advice on a particular 'problem'. i don't use auto increment, i was teached on school that it is bad. alright. but i know have numeric pk's like customer_id = 300. now when i insert a record, it must by last customer_id + 1
<17> how can i realise this in a good way?
<12> pyurt: rm -Rf
<16> !tell pyurt about reset root
<8> Alrighty.
<18> windows XP?
<17> i think saving the last id in a temp variable and then do a insert $var+1 is quite redundant
<17> (using perl + dbi)
<15> wouterrr, And bad...
<15> Just add the autoinc.
<19> wouterrr: er... why don't you use auto_incremente?
<16> wouterrr: alter table...
<15> osfameron, It's BAD
<19> or... if you're using Perl, you could use Data::UUID and have guaranteed unique uuids
<16> he was teached that
<17> no, because its a webapplication
<19> 32 bytes of storage admittedly
<15> wouterrr, So?
<17> somegeek: when i use uuid i get the uuid of the user running the cgi app
<17> not something i want :- P
<17> because that's always the same user id
<19> auto_increment is pish compared to real sequences but..
<16> wouterr: he's talking about using a specific perl module
<18> aplhablue or whillyer i cannot get to mysql prompt
<19> wouterrr: s/somegeek/osfameron/ ?
<15> lol
<17> but... how should one correctly insert a new record in this way
<19> yeah, a specific Perl module which has "guaranteed unique uuids" - just a thought, if you don't like auto_incrementing uuids
<17> without auto increment?
<19> wouterr: you shouldn't
<19> next?
<16> pyurt: ... read that page thoroughly.. understand your problem, and then come back
<15> wouterrr, Use Autoinc....
<15> You were learneded wrong.
<16> wouterr: the wrong way would be to to do a max(id) +1 , then double check to make sure that id doesn't exist in the able already.. if it doesn't..insert with that id
<19> unless they said "mysql auto_increment is less good than a real sequence" which might be true, but doesn't help you anyway, because that's what mysql has
<16> of course by the time you figure that out.. someone may have already entered that id
<15> LOCK THE TABLES!
<16> will: how's the dell ?
<16> oh duh! so silly of me
Return to
#mysql
or
Go to some related
logs:
#gentoo
install linux4geeks
etch sources.lists
#debian
qemu debootstrap sarge dhclient
pylab gentoo
lmbench Permission denied
grub.conf (nd) ifconfig
#centos
#fedora
|
|