#mysql
31 October 2007
Total 29 pages. You are browsing page 4/29.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:06 <****> might have lunch now
03:19 <****> question guys
03:19 <****> trying to set the root password after installing mysql-server in debian etch yields the following:
03:19 <****> mot: how much wood would a woodchuck chuck?
03:19 <****> ascot:/var/run/mysqld# mysqladmin -u root password 'a5c0t'
03:19 <****> mysqladmin: connect to server at 'localhost' failed
03:19 <****> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
03:19 <****> suggestions?
03:19 <****> oh you are asking us a question
03:20 <****> mot: looks like a password is already set
03:20 <****> well, that's what i thought. so i removed the packaged and reinstalled.
03:20 <****> and get the same thing.
03:20 <****> did you delete the datadir when you did that?
03:20 <****> nah, do you know where it is in debian?
03:21 <****> probably /var/lib/mysql ?
03:24 <****> great.
03:24 <****> so i removed /var/lib/mysql
03:24 <****> apt-get'ed mysql-server
03:24 <****> ascot:/var/lib# /etc/init.d/mysql start
03:24 <****> df: `/var/lib/mysql/.': No such file or directory
03:24 <****> df: mysql_install_db
03:24 <****> mot i mean
03:25 <****> heh
03:25 <****> hi guys I have something like 200k records of data from a data drill, with a very basic format. just 8 levels of a menu with each level having a column. i.e. level1 = string, level2 = tring etc.
03:25 <****> I need to speed up displaying hierarchical menu display, and since I now just GROUP BY certain columns, it's slow
03:25 <****> any tips you may have about improving? I bet I'll need to transform somehow the data
03:25 <****> ascot:/var/lib# /etc/init.d/mysql start
03:25 <****> Starting MySQL database server: mysqld ..
03:25 <****> Checking for corrupt, not cleanly closed and upgrade needing tables..
03:25 <****> /usr/bin/mysqladmin: connect to server at 'localhost' failed
03:25 <****> error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
03:26 <****> sweet.
03:26 <****> this sucks =\
03:26 <****> mot: you can find the grants for that user online
03:26 <****> i never saw that when starting the service originally.
03:26 <****> and what are grants?
03:26 <****> try without password
03:27 <****> i wasn't trying to use a password
03:27 <****> i just tried to start the service via /etc/init.d/mysql start
03:27 <****> (using password: YES) is a hint a password is entered
03:28 <****>' WITH GRANT OPTION
03:28 <****> the password is in Find your debian-sys-maint password in /etc/mysql/debian.cnf.
03:29 <****> question: how come mysql -u root didn't ask me for a password, just gave me a prompt?
03:29 <****> mot: you haven't set a password
03:29 <****> you did not use -p
03:29 <****> hey rainmkr
03:29 <****> that's what mysqladmin -u root password '' is for
03:30 <****> chadmaynard, i ran that command and threw in that hashed password
03:31 <****>" prompt, not asking me for anything
03:31 <****> but i'm afraid to ctrl+c break out of it.
03:31 <****> mot tyep ";"
03:31 <****> woot
03:31 <****> anyone here gotten mysql working good on Leopard yet?
03:31 <****> Updating to 5.x. Some of my MySQL are in the swedish charset... for some reason, whereas all the rest in in UTF8. How can I convert the swedish ones to UTF8 ?
03:31 <****> so then, mysql -u root password 'password' will set the root password?
03:31 <****> mot: now "quit" and /etc/init.d/mysql restart. shouldn't get any errors
03:31 <****> (hi)
03:32 <****> mot: mysqladmin not mysql
03:32 <****> Starting MySQL database server: mysqld already running.
03:32 <****> /usr/bin/mysqladmin: connect to server at 'localhost' failed
03:32 <****> error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
03:32 <****> regarding charset, if I just change them in PHPmyadmin, will it corrupt my beautiful PHP app ?
03:32 <****> that's what i get when i restart the service. i however, i ran that command you gave me and it said "query ok"
03:34 <****> mot: what exactly did you type? can you paste it?
03:34 <****> can i just http://cpp.tastethepaste.org/1194
03:34 <****> blah sorry ^^ that's the paste.
03:35 <****> hmm are you sure you got the right password from the /etc file?
03:36 <****> yea
03:36 <****> http://cpp.tastethepaste.org/1195
03:36 <****> the bit after my little pseudo-divider is the contents of /etc/mysql/debian.cnf
03:38 <****> hmm it should've worked then.
03:38 <****> i've never run into any of this before.
03:47 <****> fixed it.
03:47 <****> by removing all mysql-related packages
03:47 <****> and reinstalling about half a dozen of them
03:47 <****> odd way to solve problems
03:47 <****> works like a champ. not sure why. but since it works, i won't question. probably some stale config somewhere.
03:48 <****> alright. now that i've got the password set for root user
03:48 <****> how do i simply create a user so that i can setup myphpadmin? :)
03:57 <****> how can you return results in order of relevancy with FULL TEXT? is this done by automatically? btw this is mysql
03:59 <****> How can i move a primary ID and its associated fields from pendingplayers to bannedplayers
04:02 <****> limit 1;
04:11 <****> unbeatabl: i remember it is automatic, you might want to confirm it
04:19 <****> hello... is there a utility to import csv files into mysql?
04:23 <****> How can i move a primary ID and its associated fields from pendingplayers to bannedplayers
04:23 <****> GENTOODUDE: see answer earlier
04:24 <****> is it possible to SELECT the first 15 words of a field?
04:24 <****> if it is separated by a space
04:24 <****> yes
04:25 <****> klotho: load data infile
04:25 <****> !m Shai_Tan substring_index
04:25 <****> Shai_Tan: (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
04:26 <****> perfect, thanks
04:30 <****> kimseong: thanks
04:30 <****> okay, how about this question: in Windows MySQL, if I want to use load data local infile, how do I specify the file location? It doesn'
04:30 <****> t like 'c:\filename'
04:31 <****> oh, nevermind
04:32 <****> *sigh* people still use windows? :(
04:32 <****> yes, unfortunately
04:33 <****> ToeBee, if you said "people still use mysql? :(" you'd be closer to the truth
Total 29 pages. You are browsing page 4/29.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last