| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> will: inviso: yes. same result.
<0> error 1045, access denied for user root@localhost. well, a little different, baut same end result.
<0> Oh, that was for msyql -u root -p
<0> sorry.
<0> the result for the mysqladmin command was idnetical, connect failed, access denied for user root at localhost p***word: YES
<0> As shabbs suggested earlier, I've also commented out the bind line in the /etc/mysql/my.cnf file, if that matters at all. Seems to me it just reduces the requirements, rather than increasing them.
<0> I've also done the reset p***word bit with the mysql-init file from teh manual, SET P***WORD ummm.. let me get the url.
<0> SET P***WORD FOR 'root'@'localhost' = P***WORD('newp***word') url is: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<1> So uh... is it working?
<0> will: no it's "not working". I still can't log in.
<1> Paste the command you typed in exactly, and the output exactly.
<1> WE WILL HOLD YOUR HAND
<0> which command?
<1> mysql -u root
<0> mysql -u root returns " ERROR 1045 (28000): Access denied for user 'root'@'localhost' ( using p***word: NO)
<1> mysql -u root -p
<0> now I'll try mysql -u root -p
<0> mysql -u root -p prompts me for a p***word, which I enter. then I get in response "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: YES)
<1> So you don't know the p***word... :(
<1> Ok, now that's established! Have you tried the root reset procedure?
<2> yep
<2> exactly
<0> I just reset it to 'p***word' with the SET P***WORD trick.
<0> Yes, from this URL: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<2> we went from a "not allowed to connect" to "access denied" by messing with the hosts
<2> Now it's a p***word issue
<0> foloowed to the T.
<0> I'll do it again.
<1> inviso, SO YOU GOT IT FROM HERE!
<2> will[werk]: lol, just got back
<1> Great!
<1> How fast can you run if I'm in your kidney?
<2> hehe
<0> Ok, I created the file, which contains, exactly "SET P***WORD FOR 'root'@'localhost' = P***WORD('p***word');
<2> obviously, much faster than you :)
<0> stopping mysql with /etc/init.d/mysql stop
<0> running mysqld_safe --init-file=./mysql-init as root
<3> hello
<0> Starting myssqld daemon with databases from /var/lib/mysql <CRLF> mysqld_safe[8648]: started <CRLF> STOPPING server from pid file /var/run/mysqld/mysqld.pid <CRLF> mysqld_safe[8862]: ended
<3> i have a mysql table run, and with some regists
<1> myssqld?
<3> how can i set the autoencrement to > 1000 ?
<1> secher, Check /var/lib/mysql for a .err file.
<0> ps shows mysql is not started.
<1> Yeah. Your error said ended
<1> inviso, WHERE ARE YOU SLACKER?
<2> !m MalMen using auto_increment
<4> MalMen: (Using AUTO_INCREMENT) : http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html
<2> will[werk]: trying to flush you out of my kidney ;)
<1> oh
<0> will: inviso: I dont' see one.
<2> secher: /var/log/mysql
<0> I have 2 ib_logfilex
<1> Stupid debian package haha
<0> inviso: figured that, checked there too.
<5> itty-bit ?
<2> secher: nothing?
<6> debian is in /var/log/daemon.log
<6> it logs to syslog
<6> because christian hammers hates me
<0> in /var/lib/mysql/ I have loads of MYD, MMYI nd from files, noting else.
<0> checking there as well. one sec.
<0> pasting to pastebin..
<6> that's my least favorite debianism about the packages i think
<6> that and the damned debian-sys-maint user
<2> gleam_: yeah, that user is ugly
<0> paste/1891
<0> http://hashmysql.org/paste/index.php
<6> ah
<6> the mysql-init file
<6> where did you put it?
<0> paste/1891
<6> try putting it in tmp or /var/lib/mysql and then starting with --init-file=/tmp/mysql-init
<0> http://hashmysql.org/paste/1891
<6> or /var/lib/mysql/mysql-init
<0> gleam_: whre did I put what?
<6> as appropriate
<6> the mysql-init file
<6> --init-file=...
<0> one sec.. looking for one.
<0> Hrm, I don't seem to have one, save the one I created to reset the root p***word.
<0> I ***ume that that's not quite what I should be expecting, yes?
<6> that's what i'm referring to
<6> where did you put it?
<0> in root's home dir., but I gave mysql the path. I'll put it in tmp.
<6> yes, putting it in /root won'tw ork since the file is read by mysqld notmysqld_safe
<6> and mysqld runs as the user "mysql"
<6> so it can't read /root/mysql-init
<0> trying a couple of iterations of this.. ome sec.
<0> WOOTR%$)(%*$_)(*$#U%_)($*
<1> wtf?
<1> Looks like a corrupted connection
<0> YES! It worked!!
<6> gleam wins a prize
<0> dpkg beer gleam_
<6> works for me
<1> gleam_, You're prize? YOU GET TO HELP OUT OTHER PEOPLE NOW
<6> boo :(
<0> gleam_, inviso, will[werk], thanks SO much!
<0> Do I have to keep that init file? is there another I should have? Or can I just touch it in /etc/mysql or wherever?
<6> no, blow it away
<6> change your root p***word
<1> NO WE CONNECT
<6> and then restart mysql :P
<0> doing now. LOL..
<1> mysql -h 10.0.1.13 -u root -pp***word
<1> OOOOOOOH
<0> will: too late.
<1> That's what you think.
<1> Now for this remote exploit...
<0> Sorry, I locked up proftpd, and I think googlenotes is pretty secure.
<0> unless you can find a hole in sshd or exim, I think you're out of luck.
<0> but feel free, I always like learning. <grin>
<0> Really, thanks everyone, very much. I appreciate your time and experience.
<1> Wow, look at all this porn on secher's computer...
<1> Everyone, I cracked into secher's computer!!! http://10.0.1.13/crack/haha.html!
<0> LOL. WHERE?? Who's been in here? all of myt PrOn is on my server at home so I can get to it.
<0> That's be pretty impressive, if you can get that IP to route.
<0> That'd
<2> We route some rather interesting IPs around here... :)
<0> I guess. <grin>
<7> can I set privileges per table instead of per database on mysql 4.x?
<6> 4.0 or 4.1, not that i'm sure it matters
<6> which one?
<7> 4.1.x
<8> check out the docs on grant in the 4.1 docs
<7> I just had a discussion with somebody and I wasn't sure anymore...
<6> yeah, it doesn't matter
<6> yes, you can
<6> and per-column
<7> gleam_: Ahh ok... thanks
<9> Hi everyone, I have a mysql server installed on linux Redhat, and i changed the IP but now MySQL doesn't start, anyone knows which files do I have to take care about it?
<0> AlexCTI: check your /etc/hosts, make sure your host name matches the correct IP
<10> hi leute...hab ne frage
<10> kennt jemand das "problem", d*** phpmyadmin beim anzeigen der tabelleninhalte (=browse) immer sowas wie zB [BLOB - 6 Bytes] anzeigt, anstatt den inhalt der tabelle?
<10> ich hab das erst seit kurzem
<10> oder seit einer bestimmten, mir nichts-sagenden config der datenbank
<9> oki i'll check
<2> XrMbNone: Versuch # phpmyadmin und Versuch mit http://babelfish.altavista.com/tr, die Frage zuerst zu bersetzen
<9> it has 127.0.0.1 which is fine, when I run mysql on shell i get this: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
<10> achso, ist englischsprachig hier...lol
<11> hello
<2> !perror 2
<4> System error: 2 = No such file or directory
<2> AlexCTI: is mysqld running?
<9> no, is not
<10> uhm, hi guys. i've some sort of problem (maybe it's just a feature). the browse-button on my phpmyadmin-interface lists the sql-table correctly, but doesn't show its content, but some text like [BLOB - 6 Bytes]. what shall i change to see the table's content every time?
Return to
#mysql
or
Go to some related
logs:
#javascript
ubuntu build package from source
#gentoo
#web
tunap utility
dbix date_format
reset gnome settings breezy
mysql FUNCTION CONCAT does not exist
SIXY LIBS
gentoo changing chost
|
|