| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Juggernaut_: they'll only be able to see database/table/view/etc information in there if they have permission on that database/table
<1> is there anything significant in there?
<1> that i wouldn't want them to see
<0> it has table structure information for the most part
<0> take a look yourself :)
<0> then decide
<2> http://pastebin.com/737482
<0> beccabedell: check the error log
<0> Juggernaut_: also connect with a non-privileged user and see what they can see
<3> any idea why I can log into the mysql console fine, but when I try to connect to a .php page that connects to my mysql database it gives me Access Denied?
<4> what ip are you using to connect
<3> localhost
<3> hehe
<4> tru 127.0.0.1
<0> what's the exact error?
<4> try
<5> I got a warning about corrupt tables, how can I fix it?
<4> chances are you are not seeing the true error and the webapp error which is vague
<3> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Administrator'@'localhost' (using p***word: YES) in C:\Program Files\Apache Group\Apache2\htdocs\RSS\user.php on line 6
<3> it worked yesterday, I have NFI what happened
<0> and you use Administrator as the user from the console as well?
<3> hmm
<3> when I get into the mysql console it just asks for a p***word, how do I specify a user?
<0> -u
<5> May 25 07:39:27 trelew /etc/mysql/debian-start[4049]: WARNING: mysqlcheck has found corrupt tables
<5> any ideas?
<6> hide under a rock
<0> order a pizza and some strippers
<5> how about you answer my question
<0> well that's my idea
<3> weird, when I use "Administrator", I get access denied
<3> hmm
<0> !m sanmarcos repair table
<7> sanmarcos: (REPAIR TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
<3> it worked with Administrator yesterday, wtf changed?..
<0> that's not something we can tell you :D
<3> :P
<3> how can I get Administrator to not get Access Denied?
<8> Log in correctly!
<8> Login with a user that has access
<0> Tu13es_: login with root and make sure administrator still exists
<3> how do I check?
<5> how can I get the SQL schema of a db?
<3> (I just started learning php and mysql on Tuesday, heh)
<0> show grants for administrator@localhost
<3> type that at console??
<0> sanmarcos: use db1; show tables; show create table table1;
<3> er, just one ?
<0> yeah
<0> yeah, once you login with a prived user do that (with ; at the end)
<3> aye, no grant defined
<0> also try 'administrator'@'localhost' for the fun of it
<3> ok, yeah, grants aren't defined
<0> !m Tu13es_ adding new user
<3> how do I set that up?
<7> Tu13es_: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<3> shabbs: ty :)
<0> np
<5> what does the lenght of an index column signify?
<9> how much of the column is indexed
<3> ah, worked. Thanks again.
<3> I'll probably be making use of this channel a bit in the coming days :P
<5> Darien, huh?
<5> my column is a TEXT field
<0> exactly
<0> you can't index the whole text field
<5> oh ok, so I put a thousand
<0> it only indexes the first x
<10> http://coolpix.org/links.phps .. link.* is not shown if referer doesn't exists .. is there a posibility to show 0?
<11> if you add an index do you add an index of the CONTENT of some table/field..or is the table/field itself
<11> so after ALTER TABLE bedrijven.dump_bedrijven ADD INDEX (url);
<11> is the url field ALWAYS indexed, even after i DELETE the dump_bedrijven table?
<11> DELET FROM dump_bedrijven;
<8> Does anyone know the difference between the Opteron 144 Venus and the Opteron 248 SledgeHammer?
<12> will[werk]: 1xx is for single-cpu platforms
<8> Oh
<12> I'd expect their baud rates differ too
<8> Can 2xx work in a single CPU board?
<0> HS^: delete from does not delete the table, just the contents of the table, so the index remains
<12> will[werk]: ummm, maybe ;-)
<0> HS^: if you DROP TABLE then it'll get rid of the index
<0> HS^: along with the rest of the table structure
<11> ok
<11> 1 other question, with this command INSERT INTO websites (website) SELECT DISTINCT website FROM input
<11> it will insert unique records into websites.website
<11> but how would i update it in its own record.....
<11> removing all duplicates
<11> in its own table..sorry
<8> domas, What's the diff between Athlon 64 and Opteron?
<12> will[werk]: opterons can address more ram
<3> Opterons sometimes have a larger L2 cache
<12> faster memory bandwidth
<3> and are supposed to run cooler and OC better
<8> This would be for a server, so no OC...
<12> um, can you use dual-core amd64?
<12> ergh, two-way that is
<12> I'm spoiled by branding
<12> for me opteron is ... eh... Opteron!!!!
<12> Athlon is difficult to pronounce
<3> I've got an Opty 148, I love it
<13> It hates you, though.
<8> And are Opteron's Dual cores really like having two CPUs?
<13> Late at night, it seethes with fury.
<12> will[werk]: slightly less efficient, but nearly that
<13> domas: Do you have no "th" sound in Lithuanian? :P
<12> I guess cores share same memory bandwidth
<8> I have Intel's dual core. Wasn't really impressed.
<12> dean: *nod*
<5> i hate mini plugs
<5> the break so easily
<12> dean: how many non-English languages have that sound?
<13> domas: I only know a couple non-English languages, am poor judge. ;)
<12> dean: which ones? :)
<12> gibberish? :)
<13> THE ONES THAT HAVE TH
<8> domas, I mean, all the ads say "Do an antivirus scan while surfing the Internet". AV scanning slows the system so much!
<13> some hebrew, some spanish
<13> some gaelic
<13> see, gaelick
<5> i love money
<5> i need more money
<12> =)
<5> I want to swim in euros
<12> sanmarcos: sell your kidneys
<5> domas, oh, there so many other things to sell
<12> dean: hey!
<13> domas: hey!
<12> I need that money more!
<12> and I've already sold my kidneys
<12> to pay my english lessons
<8> I'll sell my soul
<5> domas, you are related to the Argentine cook "El Gato Dumas" ?
<11> INSERT INTO uniek_bedrijven (url,bedrijf) SELECT DISTINCT url FROM dump_bedrijven
<12> will[werk]: it's already sold..
<11> how do i select bedrijf also, but not DISTINCT
<12> sanmarcos: not really.
<11> i only want DISTINCT on url
<12> sanmarcos: I was in Argentina once
<12> sanmarcos: (or twice)
<12> but no more relations
<11> ..
<12> HS^: GROUP BY
<11> hmm
<11> can you give the example?
<12> example
<13> domas: You already swim in euros, filthy rich Lithuanian mobster!!
<11> hehe
<3> will[werk]: is it a Pentium D, or a Core Duo?
Return to
#mysql
or
Go to some related
logs:
installing qt4 xubuntu
django ImportError: No module named pkg_resources
install JDK on Ubuntu
#perl
#suse
sar2gp gnuplot
Xinerama Fluxbox Maximize
madwifi-source etch
#ubuntu
munmap_chunk centos
|
|