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