| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> :
<0> ok
<0> on 4.0 dont work :
<1> then it's user error.
<0> Check the manual that corresponds to your MySQL server version for the right syntax to use near ':flashchat_bots' at line 1
<0> so no : on 4.x
<1> DROP TABLE flashchat_bots;
<1> as I said, user error.
<2> TheBest: why do you have a ":" ?
<0> i dellete all
<0> [07:18:52] <1> DROP TABLE flashchat_bot;:
<0> i try more table to Delete 1 time
<1> that was a typo, and I attempted to correct it on the next line.
<0> +----------------------------+
<0> | Tables_in_web |
<0> +----------------------------+
<0> | osdate_admin |
<0> | osdate_admin_permissions |
<3> if I have root access to mysql how can I find out what users exist to a database? I've forgotten the name of the user for my database.
<2> sh4d03: if you have mysql5 use can use the information_schema
<2> sh4d03: you can also query mysql.db for a particular db name.
<3> TodoInTX: I have version 4.1 and I'm a very basic mysql user, can you explain that a little more?
<2> select user from mysql.db where mysql.db.Db='yourdatabase';
<3> ok, and to reveal their p***word when I'm root? Is that possible or should I just change the p***word?
<2> you can't see in clear text what the p***word is.
<2> you would have to reset it.
<2> !m sh4d03 set p***word
<3> ok, to do that I'm trying "UPDATE user SET P***word=P***WORD('xxxx') WHERE user='vpopuser'; but it's saying that "ERROR 1146 (42S02): Table 'vpopmail.user' doesn't exist"
<4> sh4d03: (SET P***WORD Syntax) : http://dev.mysql.com/doc/mysql/en/SET_P***WORD.html
<1> use mysql;
<3> "ERROR 1133 (42000): Can't find any matching row in the user table"
<1> then the user doesn't exist.
<1> !m sh4d03 grant
<4> sh4d03: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<3> but the command that TodoInTX gave me revealed that it *did* exist
<2> !m SQL SHOW GRANTS
<4> SQL: (SHOW GRANTS Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_GRANTS.html
<1> odd. perhaps your tables are out of sync.
<3> how do I fix that?
<1> I would just revoke and then re-grant the user access.
<3> the show grants only gives me root's grants - afaics
<3> !m sh4d03 revoke
<4> sh4d03: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<2> sh4d03: no, you can do "show grants for user@host"
<3> yeah, the user has grants to the dbase
<3> http://pastebin.com/569835
<5> how can i count(id) and select the same id, in the same query?
<2> sh4d03: ok so then you can do "set p***word for user@host = p***word('thep***')"
<3> TodoInTX: that's done it - thank you
<2> :)
<3> TodoInTX: mail works again now :D thakn you.
<3> *thank you
<6> hello, i've got mysql set up but when i ry to run phpmyadmin, i put in my user/p*** and it won't let me in
<7> someone showed me a script yesterday, something like http://pastebin.com/58..... , may I see it again?
<8> pastebin deletes old pastes...
<2> loef: do "select count(id), id from table group by id;"
<5> yea.. i got it
<9> hi
<1> B
<9> anyone able to help me setup mysql? im have a 2002 error and cant connect to mysql
<1> paste the exact error
<9> nor do I think mysqld is running nor can I su to user mysql
<1> you're not supposed to be able to su to the mysql user.
<1> but run the daemon, and you'll be able to connect.
<9> ERROR 2002 (HY000): Can't connect to the local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<1> ps auxww | grep -i mysql
<9> nothing
<9> besides my psaux
<1> run the daemon, then.
<9> as root?
<9> or as a user?
<1> yes, it will drop privileges itself.
<9> ok typed in mysqld
<9> returned a line no errors
<1> ps auxww | grep -i mysql again
<9> same thing
<9> just the grep
<10> check your syslog
<10> did you install it by hand or use a package?
<9> emerged
<9> via gentoo
<10> ugh
<10> ok
<10> run /etc/init.d/mysql start
<10> as root
<9> ok did that
<9> how do I create a new database called mythconverg?
<9> since that worked :)
<2> !m nvrpunk CREATE DATABASE
<4> nvrpunk: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<11> !m NOT EXISTS
<4> NOT: (EXISTS and NOT EXISTS) : http://dev.mysql.com/doc/mysql/en/EXISTS_and_NOT_EXISTS_subqueries.html
<11> Awesome :)
<11> !m INDEX
<4> Incorrect usage. See 'help m'
<11> !m Index
<4> Incorrect usage. See 'help m'
<1> !man index
<4> (Index Preloading) : http://dev.mysql.com/doc/mysql/en/Index_preloading.html
<11> Ah
<11> Thanks infi.
<11> Just learning the bot use :}
<9> :(
<1> !m nvrpunk tutorial
<4> nvrpunk: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<1> read it all.
<9> mysql> CREATE DATABASE mythconverg;
<9> mysql> USE mythconverg
<9> databse doesnt exist
<9> :/
<1> no error on the first command?
<9> nope
<9> BUT!
<9> mysql> SHOW DATABASES; gives an error
<9> :P
<11> After the first command, you should see:
<11> Query OK, 1 row affected (0.00 sec)
<9> im on step 1 of the tutorial
<11> What error does Show databases; give?
<9> unknown database, DATABASES
<9> heh
<12> is there any way to mask certain types of rows when i output from the command line? (ie, i don't want to see any text/blob types because of the damn newlines :P)
<9> nvm im stupid :p
<2> rows aren't text/blob columns are.
<12> whoops, sorry
<12> i meant columns
<2> just don't do select *.
<12> yeah, that's what i've been doing.
<12> typing in all the column names becomes a pain in the ***
<12> oh well
<2> grav: it is the best way to do things.
<11> TodoInTX: If I have a table of engine_parts and a table of engines and my engines have a foreign key referencing engine-parts for the parts in each engine
<11> and I have a third table for engine_parts_i_own and I want to find all engines I can build with the engine parts I own
<11> that is a double not exists scenario, right?
<2> UncleD: ugh... not sure.
<2> I'd have to play for that...
<12> yeah k
<11> You understand the problem though, right?
<2> yea
<11> I thought it up. It's an interesting one to say the least.
<11> I think I want to do select all of the engines that don't not exist in the list of parts i have that those engines require to be built.
<2> UncleD: would you mind giving me a sample db that I can toy with ?
<13> NO PIRACY!
<11> gimme a min
<11> i'll whip one up Todo
<14> when I try to start mysql5.0.18 using "mysqld_safe -u root", it starts but I cannot use "mysql -u root". I have also tried running mysqld_safe without any options and I get a ".... mysqld ended" error. Any ideas how I can troubleshoot this problem?
<13> As the root system user, run mysqld_safe --user=mysql
<13> What happens when you do mysql -u root?
<14> will: Access denied
<13> Two separate problems. First, start the server properly.
<13> Second, supply a p***word when trying to login as root. mysql -u root -p
Return to
#mysql
or
Go to some related
logs:
havp+sarge
SVGATextMode gentoo
#math
fedora your fstab installation release 5
vargux
#perl
#linux
gentoo altgr not working
Unrecoverable error reading M from
belgacom 6000ug
|
|