| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> yes there are
<0> and a copy of mysql_safe
<1> devie: okay, you need to close all copies of mysqld (and mysqld_safe) first, *then* start mysqld with the skip-grant-tables option.
<0> and that will allow me to connect?
<1> devie: one way is just "killall mysqld ; killall mysqld_safe".
<1> devie: that will allow you to go through the sequence described on the webpage.
<0> thanks, I'll try it
<0> ok, did i
<0> it
<0> doesn't really give me any indication that anything has happened
<0> starting mysqld damon
<0> stopping server
<0> ended
<2> tetrarch thanks to you and 127.0.0.1 I can now open Mysql administrator great tool for a newbie like me
<1> devie: seems clear enough...? "stopping server", that's what you want. Do that "ps" command again to check there aren't any more around.
<1> devie: then you can run mysqld with the --skip-grant-tables option, which lets you log in w/o authentication.
<0> tetrarch: that's the info I got when I ran the p***word changing line
<1> davidohm: haven't used that one either ;)
<1> devie: which step number?
<1> devie: 4?
<0> yes
<1> devie: okay, probably means it worked then. Try restarting (with /etc/init.d/mysqld restart, or whatever you use normally)
<0> same thing
<0> doesn't even ask me for a p***word
<0> just says NO
<0> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<1> waitaminute, how are you connecting? mysql -uroot -p?
<3> hi
<0> doh
<0> that was it
<0> lack of -p
<0> well, the p***word works now... I'm just trying to setup phpBB
<0> but it keeps erroring
<0> so I was sure my p***word must be wrong
<3> just checked out the mysql workbench current trunk according to this wiki: http://forge.mysql.com/wiki/Building_MySQL_GUI_Tools_on_Linux ./configure --... fails with: config.status: error: cannot find input file: Makefile.in ?
<4> Tetrarch:Ifound what I was looking for now, thanks very much! :D
<1> kris: good luck with it, sounds like a major task to me :)
<4> yeah, but it's fun for the moment heh
<0> Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in /var/www/forum/db/mysql4.php on line 48
<4> I'm extremely intimidated by object oriented programming and this is forcing me to get over it
<2> tetrarch any suggestions on the syntax for the GRANT command??
<1> devie: heh. what's your DB connection line? (w/o p***word, of course...)
<1> davidohm: yep - check the manual!
<1> !m grant
<5> Incorrect usage. See 'help m'
<4> oh well, back to work I go hehe :)
<1> heh. sql doesn't love me today. http://www.mysql.com/doc/G/R/GRANT.html
<1> kris: soon you will learn to love OOP. it is teh great.
<0> tetrarch: I've been trying to use the same database that I'm using for drupal... do you think I need to make a separate database for phpBB?
<1> devie: nah, should be okay to use the same DB, just make sure you have a valid user to connect (preferably something other than root).
<0> well I'm confused :)
<0> when I installed Drupal, it told me to use root
<0> and now I can't connect using the install.php file from phpBB
<0> I forget which file my $db_url string was even in
<1> devie: then Drupal ****s and should be treated as potentially Evil.
<1> devie: grep -ir "db_url" *
<0> I didn't know i was getting myself into so much headache when I wanted to make a simple website
<0> I did this all on my mac once before
<0> and everything went smoothly
<1> devie: it's straightforward enough, just make sure to follow instructions step by step. at least, it usually works like that. haven't used phpBB in a loong time.
<0> I've configured phpBB before
<0> it's usually no problem
<0> so I can't figure out why I can't connect to mysql
<1> devie: check the Apache error_log for more info, or maybe the mysql error log.
<1> try #phpbb, they might be awake.
<0> thanks for the help
<0> I appreciate it
<0> I don't want to read 10,000 pages of MySQL documentation
<0> I'm already doing that for Oracle
<6> normaly you only need to read 2-3 pages to get most questions answered
<1> heh. yeah, most of the mysql documentation is irrelevant for setting up and connecting.
<0> doh, tetrarch I got it
<0> I put my actual domain name in the field
<0> but my 'root' account is @localhost
<0> so I put localhost in there, and it worked
<7> <javabot> JViz, php is the solution of choice for relaying mysql errors to web users
<1> devie: mysql likes to distinguish between "localhost" and "external IP address" even when connecting from the local system, it's a PITA.
<0> So, I got it working, thanks for the help
<0> I'm trying not to learn too much MySQL... afraid it will counterbalance all the oracle docs I've been reading
<0> (we use oracle at work)
<1> devie: Oracle is a beast, mysql is more of a quick hack (in a nice way, of course). but yeah, once you have it connecting, you can safely forget all the mysql you learned.
<7> yeah, quick hack, that's why it took like 3 years for version 5 to come out
<2> tetrarch you said !m grant I am entering !m grant at the command line I get "no manual entry for grant"
<1> davidohm: no, that was to get the SQL bot to provide the information.
<1> Look at the webpage I sent.
<2> yes I am reading that link that you sent
<2> !m grant
<5> Incorrect usage. See 'help m'
<2> help m
<1> davidohm: see topic for info (/msg SQL commands)
<2> tetrarch where do i find the topic?? here in IRQ??
<0> tetrarch: yeah, this is just for a personal site... for some of my friends and I to trash talk one another in this game we all play
<1> davidohm: yes. where to find it depends on the IRC client you're using.
<2> tetrarch i am using Snak
<1> davidohm: then it will be in the documentation for Snak, whatever that is...
<1> devie: mysql usually behaves itself well enough once it's been set up, it's not nearly as maintenance-heavy as oracle can be :)
<0> hehe, I hear that. I have to go in and manipulate data in SQL*Plus every single day
<8> devie: for example?
<7> devie: sounds like leaky programming
<0> it is crappy programming
<0> it's old-*** programs written in Pro*C
<0> like god knows how long ago
<0> and every day, my users complain that they're unable to process something
<0> and I have to dig through the tables and find the errant entry
<9> hello.
<9> i have two "root" users. root@localhost and root@domain.net if i try to remove either i get an error. i only want root@localhost. how can i remove the other?
<1> DragonD: use mysql; delete from user where user='root' and host='domain.net' limit 1;
<9> thanks, it worked
<1> sure thing.
<10> is there a way to do a (distinct) select on a column and order it by the frequency?
<2> !m grant
<5> Incorrect usage. See 'help m'
<8> delete ... limit 1 is your bozo mode? :)
<2> help m grant
<1> perl_cont: limit 1 means if it was fun the first time, there's a chance it can be done again :)
<8> select count(distinct) c, crap from table group by crap order by c;
<8> but distinct is seldom a good thing
<8> it just means nulls are ignored
<8> I usually use select count(*) c, crap from table group by crap order by c;
<8> count(*) is faster on myisam too
<8> actually, it's instant
<11> myisam maintains a row count, but it's no longer instant if you're selecting a subset :P
<11> *then* it needs to actually count
<8> I wasn't :)
<11> I wish Archive did the same
<8> I was.
<10> perl_cont: thanks, that works great.
<11> show table status shows a row count, but select count(*) from is ****-all slow
<11> inconsistent!
<8> which fs?
<8> myisam or innodb?
<11> me? Archive. :P
<11> innodb has a guess in show table status, actual count in count(*)
<11> AFAIK archive's row count is actually correct in show table status
<11> but select count(*) is not optimized
<8> ok
<11> think it has to do with **** not being counted if it's in the compression buffer
<11> a select will flush that buffer then get the actual count
<11> may be missremembering
<12> ok i've done something really bad and i need to undo
<12> how can I unde a query?
<12> undo*
<12> in a MyISAM table
<1> davanger: no can do. revert to backup is only way out afaik.
<12> no backup
<8> wahaha
<12> god dam it
<8> there's binary logs if you're smart enough to use them. doubt it.
<2> !m davidohm errors
<5> davidohm: (General Information) : http://dev.mysql.com/doc/mysql/en/Introduction.html
<2> !m davidohm code 1044
Return to
#mysql
or
Go to some related
logs:
#web
#web
#python
forms having heirselect
how to start portmapper fedora
charleze therion
run .sh file fluxbox
run ut2004 in ubuntu
#postfix
kpersonalize suse
|
|