| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> but I'm looking for something to also prevent troubles with other chars which might occus...
<0> lokus, oh, charset...mh....wait...
<0> mh where can I see what charset I have in mysql? never set this
<0> ah here we go, latin1
<1> hi guys, I have a problem, one of our servers is hacked and I suspect they tried to mess with the mysql server too, is there a good way to look at the ib_log files?
<2> nope
<2> lonki: you would want binlogs for that
<1> ok
<3> :)
<4> Hello. I've inherited a linux box where the mysql admin p***word has been lost. There is no need to recover any data. uninstalling mysql, deleting /var/lib/mysql and reinstalling did not create a p***wordless root for mysqladmin to use, as I expected. How do I return mysql to a "factory" state?
<5> "man reset root
<5> !man reset root
<6> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<4> archivist: Where is the root p***word information stored, if not in the mysql table itself?
<7> well unless /var/lib/mysql was just like the rpm location and mysql was installed via source
<7> so the db's were actually somewhere else
<5> in the user table in the mysql db
<8> hi all
<8> ohw can i add user in mysql DB ?
<8> and how can i check DB users?
<8> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
<8> mysql>
<8> i'm here
<5> !man adding users
<6> (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<4> archivist: So, unless there is another mysql database somewhere, what I did should have worked, right?
<5> do whatever the link i gave you says, or go to db dir (for loc see my.cnf) delete contents and run mysql_install_db
<5> do whatever the link i gave you says, or go to db dir (for loc see my.cnf) delete contents OF SUBDIR mysql and run mysql_install_db
<4> archivist: Yes, this is what I already said I did.
<4> I was asking a different question, but never mind.
<8> how can i see users list?
<4> Dr-Linux: They are stored as rows in the users table in the database named mysql.
<8> queuetue: yeah but how can i see how many users there?
<4> Dr-Linux: Using sql.
<9> [15:04] parag0ndoes anyone here know anything about MySQL database synching?
<9> [15:05] parag0nif we set 2 servers up, is there any way to synchronise the databases between them?
<4> parag0n: http://dev.mysql.com/doc/refman/5.0/en/replication.html
<9> thanks
<2> xlx: poke me if you're able to reproduce
<10> I'll choose to interprete that in the technical debugging sense..
<4> Dr-Linux: If you have mysql questions, please ask them here - there is not need to discuss them in private.
<8> how can i see MySQL users? :S
<8> show tables; ?
<8> or whats the command?
<7> use mysql
<7> select * from users;
<8> jy thanks
<8> Jy: how can i create a databse name?
<11> !m Dr-Linux create database syntax
<6> Dr-Linux: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<7> why don't you read the docs?
<12> hallo
<12> how do i put a text from form to comuln in database?
<12> $fileDateOd = $_FILES['userfile']['date_od'];
<12> in form .. name=date_od ?
<11> !m lada insert syntax
<6> lada: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<11> !m lada update syntax
<6> lada: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<13> can anyone help me fix this for my forum
<12> shabbs: thX
<13> http://www.zizzom.xn-host.com/forum/
<13> i am new at MySQL
<13> stuff
<14> !m cobra01 grant
<6> cobra01: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<13> i have seen that don't understand it
<11> cobra01: you need to grant privileges to the user in order to allow them access to the db
<13> i know that but i don't what i am doing in the MYSQL
<13> i mean what is the 1st thing i need to do
<15> So i'm having trouble understanding the specifics of setting up a mysql cluster
<11> cobra01: you either need to login using the cli or use something like phpmyadmin
<13> ?
<11> !m cobra01 tutorial
<6> cobra01: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<11> start there
<13> k
<16> hi. I'd like to have the number of the row as the first fild in the listing on console. What function should be used?
<11> scorphus: you need to have an auto_increment field in your table to do that. mysql doesn't number rows internally
<16> sorry, I think I wasn't clear enough... I'm selecting data, ordered by some VARCHAR field. But would like to have a number identifying the row number (not the tow id). Just as when listing ordered by id...
<17> scorphus: For what purpose?
<18> how do i login using a single command... "mysql -u root -p***word=root" does not work :(
<18> i dont want the prompt because im scripting something
<16> mhillyer: for line numbering. I'll create a text output for revision
<11> |XO|: mysql -u root -p p***word
<17> Well such functionality is not built-in to MySQL, could you just run a counter in your display loop?
<18> shabbs that doesnt work
<2> shabbs: no space
<18> but i for it to work :)
<18> thanks
<2> |XO|: mysql -u root -pp***word
<2> or --p***word=p***word
<18> works :)
<18> thanks
<11> close enough
<2> sure it does, it's in every manual
<18> i know i was just typing it wrong
<18> i did "-" instead of "--"
<2> shabbs: yeah, you ended up connecting to p***word database ;-)
<11> scorphus: or you could run it on *nix shell and pipe the output to nl, that would number your lines for ya
<11> *shrug* :D
<16> nice trick, shabbs, thx
<2> =)
<2> unix has so many various tricks
<2> but quite steep learning curve to use them :)
<2> I tend to forget newline conversion methods 5minutes after I use them :)
<19> heh
<19> there is a program that does that
<19> rather a command
<19> I don't know if it's actually a fullfledged program or just a regex wrapper :P
<20> everytime i try to restore a data base i get an error You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'option varchar(50) NOT NULL default '',
<21> need help with getting the last of a order by query
<21> SELECT LAST(id) FROM msgs LAST 1 ORDER BY id DESC
<11> rawsweets: select id from msgs order by id limit 1; or simply select max(id) from msgs;
<21> so use limit instead of last?
<11> oops +desc on the first one
<11> yeah
<21> okay lemme give it back to you, so I get it right
<11> last must be an oracle thing I'm guessing
<21> Don't know - I just used MS SQL, and that's what they used
<11> rawsweets: what is this for?
<11> are you trying to get the id of something you just inserted?
<21> no
<21> I'm just getting the greatest id number in the table
<11> ah, then use the 2nd one
<11> SELECT MAX(id) FROM msgs;
<21> cool
<21> this would return one row, yes?
<11> yes
<21> awesome - thanks
<21> can't seem to find a good reference online - got any urls?
<11> for what?
<21> MySQL syntax, statements, functions, etc
<11> !m rawsweets mysql manual
<6> rawsweets: Nothing found
<11> doh
<11> !tell us about manual
<6> shabbs asked me to tell you this: If you're asking those sorts of questions, you should probably start with some reading. http://dev.mysql.com/doc/
<21> kewl - I'll bookmark it
<20> shabbs can you help with my problem?
<21> thx much - catch you later! :-)
<11> Zach^^: pastebin your query and the full error you get
<20> error #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'option varchar(50) NOT NULL default '',
<20> ordering int(11) NOT
<20> http://pastebin.com/557700
<11> well obviously you'r not using that exact query
<11> otherwise it'd be to user near '`option` varchar(50)...'
<20> shabbs is there away to fix the whole DB ? it is about 350k
<22> hello
<23> how long does it take to learn to use mysql for most applications?
Return to
#mysql
or
Go to some related
logs:
debian etch setup pppoe
#osdev
how to reset ntfs permissions in ubuntu
source list apt phpnuke
#linux
#fedora
#openzaurus
#perl
ip check which country php
cracker tricknology
|
|