| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> :(
<1> hey, how do i make a table in mysql from terminal on mandriva
<2> inviso_ im trying what you said but i get an error that no db exists at ...information_schema
<0> mysql -u user -p youDB
<0> ^ Chrisx2
<3> computron: you'll need to upgrade mysql to 5.0 for that to work
<4> actually nm. i don't have access. heh :| the disk is totaly broken
<0> computron vers?
<3> kaber2: ouch
<1> erm whats the default p***, or how 2 change?
<4> yea
<3> !m Chrisx2 reset root
<5> Chrisx2: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<2> jax its access
<0> run: mysqladmin -u root p***word 'yourP***word'
<6> do mysql_install_db files get stored in /var/lib ?
<1> erm i do mysql -u user -p youDB <- changed but says *** aint a table
<3> blackthorne: typically, yes. /var/lib/mysql/mysql
<1> any1?
<6> inviso, if i remove that dir and create it again should the user db's get clean ?
<3> blackthorne: yes. Shutdown mysql before doing so and make backups first
<6> root@neo:..# pwd
<6> ..
<3> Chrisx2: that didn't even make a tiny bit of sense. My only response was "buh?" which didn't seem very useful at the time
<6> has this ever happened to you?
<3> blackthorne: eh?
<1> i was told to type this mysql -u user -p youDB to make a table but it says youDB isnt a table
<1> ...
<3> Chrisx2: that wouldn't make a table and it wouldn't give that as an error message. That would log you in so you could create a table
<1> how do i make a table?
<3> !m Chrisx2 tutorial
<5> Chrisx2: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<4> i guess about 50 people are goign to loose there accounts :/
<3> kaber2: heh, why?
<4> i have a box at ev1. the first drive failed..
<4> ext3_orphan_cleanup: deleting unreferenced inode 2987992
<4> ext3_orphan_cleanup: deleting unreferenced inode 262265
<4> ext3_orphan_cleanup: deleting unreferenced inode 262264
<4> EXT3-fs: hda5: 63 orphan inodes deleted
<4> lots of stuff like that
<3> ooo, excellent :) Good backups save lives
<4> and i did a mysqldump in the morning, forgot to do a dump before made that drive the slave
<4> yea
<4> i need a script that automates the backup process
<4> i didn't think we added new custoemrs
<4> but we did :|
<4> oh well. just put an annoucnement message
<3> They're human. Send them chocolate if you're worried ;)
<4> i can't seem to reset my dam root p***wrod though
<4> heh
<4> following these directions
<4> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<6> root@neo:/home/blackthorne# /usr/bin/mysqladmin -u root p***word 'whatever'
<6> /usr/bin/mysqladmin: connect to server at 'localhost' failed
<6> error: 'Access denied for user 'root'@'localhost' (using p***word: YES)'
<6> after a clean and succesfull install of mysqld...
<6> i've tried everything but no idea what can be the problem
<4> lol. i'm getting the same thing
<4> http://rafb.net/paste/results/JXw0TM26.html
<4> started mysql with mysqld_safe --skip-grant-tables
<3> blackthorne: check for /root/.my.cnf and look for user= and p***=
<6> isn't this supposed to be the command that defined user and p***word ?
<6> inviso, anyway i had configured that file
<3> kaber2: select User, P***word from mysql.user where User = 'root'
<3> blackthorne: if it's setup, it would be using a p***word when you didn't have one set. That would cause the mysqladmin command to fail
<4> Empty Set
<7> What's the best value to give to a field when you just want the values to be either '0' or '1'?
<3> kaber2: how about where User LIKE "%root%" ?
<3> daniel`js: TINYINT or ENUM
<7> inviso: Thought so, but which one is slightly faster? ;)
<7> enum?
<3> daniel`js: actually, BIT or ENUM.. BIT for sure if you're on 5.0+
<4> hmm
<7> Which I am =)
<4> Select User, where User LIKE "%root%";
<4> getting an error
<6> inviso, should i use mysqladmin ... -p and then enter the p***word?
<3> kaber2: select User, P***word from user where User LIKE "%root%";
<7> Now let's say if I have a few fields that only have the value of 0 or 1, but they're tinyint at the moment, would it be okay if I just changed that to bit? (no warnings or errors)?
<3> blackthorne: if it's a new install, you don't want -p or p***= defined. P***word is blank by default
<4> No database selected
<3> daniel`js: should be fine
<3> !tell us about disclaimer
<5> inviso_ asked me to tell you this: We are in no way responsible for the data you will delete, proceed at your own risk and know that backups save jobs.
<8> I thought backups saved data
<7> And jobs ;)
<3> kaber2: do USE mysql; first
<4> empty set
<9> how i select a limitated field?
<3> kaber2: that seems bad, doesn't it? You don't have a root user. At all.
<3> GNN_Ricardo: a what?
<9> i got a varchar with 100 chars, i wanna select only the 20~30 field(only print this 10 letters)
<4> hmm
<3> !m GNN_Ricardo string functions
<5> GNN_Ricardo: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<4> plesk is working, and if i do show databases, i get horde, psa & mysql
<4> hmm
<4> so if i don't have a root account, how am i supposed to make a user. cause it's not letting me if i use this --skip-grant-tables option
<6> inviso, thanks
<4> weird
<6> inviso, unfortunately i always need these kung fu's to set mysqld working. It's the only daemon where i still have these irritating issues.
<3> kaber2: you're not "making a user." You're *updating a p***word. Of course, that explains why the update didn't work :)
<9> inviso_ i only found: mysql> SELECT LEFT('foobarbar', 5);
<9> -> 'fooba'
<9> i need two parameters (string,start,finish)
<4> oh
<9> do you know any?
<4> so what your saying is that ther's no root sql account
<3> kaber2: true :)
<4> hmm
<3> GNN_Ricardo: seriously? Look a bit further. I didn't link the doc because I'm trying to be evil
<4> inviso: so i just CREATE USER root ?
<9> mysql> SELECT SUBSTRING('Sakila' FROM -4 FOR 2);
<3> kaber2: and it will need granted "uber" permissions. Read the grant docs carefully and you should be able to get it done
<9> -> 'ki'
<9> this inviso?
<3> !m kaber2 GRANT
<5> kaber2: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<3> GNN_Ricardo: did it do what you want?
<9> ya thanks :-)
<3> np, enjoy
<9> do you know the same for Microsoft SQL?
<3> no idea
<9> ojkz
<4> argh. these syntax's are so complicated without a sample
<4> heh
<10> how to skip each five records, when selecting?
<3> !m Drakas select
<5> Drakas: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<3> Drakas: see LIMIT
<10> sure?
<11> Drakas - I don't think you can
<4> inviso: it's not letting me create a new user account. telling me can't do it when running --skip-grant-tables
<4> but if it's not --skip-grant-tables i can't login
<10> can you tell me exactly, im on 4.0
<10> like record 1, record 6 , record 11...
<10> doesn'tlimit just select records from x to y?
<11> right, you can't do what you're trying to do
<11> and it doesn't make any sense anyway
<11> if you have a relevant id, you could do where id % 5 = 0 or something
<12> no it selectxts records starting at x and returns y number of records
<10> well, then x to (x+y(
<10> so i cant skip each five records, impossible?
<11> do it in code.
<10> ok, just washelpingsome one otu
<4> ooks like plesk was doing something
<7> Would unsigning fields slow down MySQL at all?
<3> Too bad he left. It would be possible with a row counter and a HAVING
<12> daniel`js, unsigning slow somethign down?
<12> daniel`js, I highly doubt it I could see it makign it faster
Return to
#mysql
or
Go to some related
logs:
error kio_media_mounthelper suse
#kernel
#perl
gnome VS gnome-light
fedora not init font path element unix 7100
suspend2ram 9600
kernel interrupt 80h NASM
(EE) AIGLX: Screen 0 is not DRI capable nvidia
#lgp
ubuntu limit bandwitch
|
|