| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> !m ebow revoke syntax
<1> ebow: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<2> ah revoke FROM
<2> thanks
<3> I've got a data drive pulled over from someone's Mac. And they have folder names like "My Picture's". I want to do a find ./ -type d | xargs .... but I cannot because it says unmatched single quote. Anyone know how I can manipulate xargs so it correctly escapes quotes in input?
<3> oh wait, chit, wrong room
<3> srry about that
<4> room! teeheehee
<5> I have a couple of questions. One may be rather silly, one is sor tof theoretical... 1. Where is the database I created using the command, from the mysql prompt, create database craig ?
<5> 2. Can I use mysql and something like tinapos to replace a $50,000 setup a friend of mine bought for his lumber yard?
<6> "My Picture's"? obviously the long term solution is to learn them how to spell...
<7> Uberriffic: if they didn't tell you.. i think its xargs -0
<8> hello do I have to install mysql to create a database
<8> [08:35] <8> Hello
<8> [08:35] <8> =)
<8> [08:35] <8> I have a question
<8> [08:35] <8> I previously installed mysql and phpbb on my freebsd box and was running a forum
<8> [08:36] <8> I upgraded from freebsd 5.4 to 6.0 , I copied my forum folder but I forgot to keep the database
<8> [08:36] <8> is there anyway to put a database back into the forum
<8> [08:36] <8> this is the errror msg from the site
<9> erf_: please don't paste large blocks
<8> http://www.stagmatech.com/forums/index.php
<5> Oh wait, here's a third.... when I try to log into mysql as anyone but root, access is denied
<5> erf_, I'm pretty sure you do
<8> ok
<8> can I use pastebin
<9> yes
<8> ok
<8> http://pastebin.com/552545
<10> hi all, can anybody spot the syntax error in this: http://rafb.net/paste/results/MWtrvF68.html
<10> Is it the # as comment? I've seen that in mysql scripts before, I could swear
<10> oohh I just read that it is supposed to be --, let me try it
<8> anyone ?
<10> no, it still says I have an error "near '' at line 1"
<10> I found it, I am missing a }
<10> err a )
<5> erf_, I'm just starting with mysql; I know nothing
<8> craigb***?
<5> Still waiting to hear why I can't log in as anyone but root, and where the actual database is located.
<7> craigb***1976: you have to create the users
<7> generally they are in /var/lib/mysql
<5> I did, with p***words.
<7> did you flush privilages?
<5> And logged in once with one of the users.
<5> How do I do that?
<7> flush privilages;
<4> mysql users != linux users in /etc/p***wd, just in case you hit that
<5> SpComb, What's that mean?
<7> did you create the users IN MYSQL?
<4> you have to GRANT <whatever> on <db>.* to '<username'>@'<host>' identified by '<p***wd>'
<5> Yep, I did that.
<4> hmm
<5> And I jsut flushed privileges, then restarted the mysqld, but still get the access denied message
<10> craigb***1976: the databases are usually stored in /var/lib/mysql
<10> your db users are not the same as your unix users
<10> d'oh I see that's covered
<5> misty, called db.opt in the folder with the same name I gave the database?
<5> Well, when I created the mysql users, I gave them the same names and p***words as the regular linux users.
<5> At least for now, I didn't want to confuse myself
<10> craigb***1976: my databases are in /var/lib/mysql, I have lots of them
<10> one directory for each db
<10> how did you create thema/
<5> ?
<10> you have to give them SOME privileges for the mysql db itself
<10> how did you create them?
<5> hang on....
<5> grant create, create temporary tables, delete, execute, index, insert, lock tables,
<5> select, show databases, update on *.* to username identified by 'p***word';
<10> I found it really confusing actually
<10> you want to give all your users access to delete every db?
<10> err nevermind, that would be drop
<5> This is on my laptop, and I'm just trying to get a pos program running.
<10> you need to 'username'@'host'
<10> maybe 'localhost'
<10> it does seem to matter
<10> I used 'username'@'%'
<5> so if I add @mybox after username, I'm good?
<10> you need to pay attention to the ' '
<11> Can I replicate only one table in a database eg host1 : db1.db_replicate to host 2 : db2.db_replicate
<10> http://dev.mysql.com/doc/
<5> Well, the first one I created worked, but now it won't. I'm windering if it's because I'm logged into fedora as the second user, and that user owns the terminal I'm trying to log in with. But that didn't seem to matter with root..... Balls....
<10> dimi3: I don't know about replicate but it will be easy enough to make a batch job to export and import that table, if you don't need real-time accuracy
<10> craigb***1976: it doesn't have anything to do with your unix user
<11> misty: ok
<5> Ok. How do I delete the accounts and start over?
<5> WIth the @hostname
<10> use mysql; delete from user where user like 'username'
<10> ;
<10> don't delete the rooto ne
<10> root one, rather
<5> the command goes like mysql>delete from user where user is 'craig' ?
<5> with a ; at the end?
<10> where user LIKE 'craig';
<5> wait a minute.... I can't do it because no database was selected. I think there's a light going on over my head.... this is startign to make sense I think....
<5> You don't just create a mysql user. You have to create one for a database? So I can't create craig unless there's a database for him to use?
<10> mysql has a master db, which includes info about whqt users and what db's exist
<10> that db is called mysql
<10> craigb***1976: you would be better served by reading the manual.
<5> Ahhhh, so the use mysql; command makes it so that when I delete the user craig, it jsut takes it out of that databse?
<5> I have a book, but it's only making sense with the extra info from you folks
<5> Publishers need to stop with the idiot and dummy books and make them for complete dumb***es, like me :)
<10> well read the manual online, it takes you step by step
<10> people here will quickly lose patience with answering questions that are easily found out from the manual
<5> ok. Thanks for getting me this far. Perhapsit was the push I needed to understand all I've read so far.
<11> I try a GRANT REPLICATION but I get the following http://bultis.net/error.txt
<11> It's something like illegal grant for the table, but i want to limit the account privileges to that table;
<12> dimi3: you're trying to grant on the wrong scope
<12> dimi3: you can't grant replication on a single table
<12> !m dimi3 grant
<1> dimi3: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<13> havign some utf8 issues, using phpmyadmin 2.7.0-pl1 on mysql 4.1.12, I am unable to read varchar fields if they contain utf8 characters - looks weird. If I utf8_decode() beforehand it's all good - but I would like to avoid this AND still be able to read the data in phpmyadmin - any ideas ?
<14> Is this even possible with SQL? - http://hastur.ext.fi:8000/friend-fan.txt
<12> raspi: can't connect to server
<11> Darien: so is there any way i could limit the replication only to one db?
<14> Darien: now
<12> dimi3: don't specify a specific table, for one
<12> dimi3: add replicate-do-db=databasename to your my.cnf
<11> Darien: ok
<15> why mysql makes a difference of upper and lowercase tablenames ? create TABLE; select * from table , will fail... or is this a "problem" of the oracle mode ?
<16> hi, I'm a n00b to MySQL. I'm sitting in Lnux/MySQL 5.0.17 admin. panel and looking at basic user/data conf. Have few basic questions?
<14> Darien: ideas?
<16> *Linux/MySQL
<12> raspi: I didn't look
<12> I'm cooking breakfast
<14> ah :)
<12> oh, that again
<12> I *still* don't know what the heck you want
<16> Is there a major sec. issue by allowing TC/IP connection to MySQL?
<17> By allowing remote access?
<16> malchias: kind of, over LAN only
<17> aloof: if everything is setup to accept from local scripts only, they have to break into your machine. If it's remote access they can write a dictionairy or brute force attack and hammer away directly as MySQL
<17> ( from a remote machine )
<17> at least that's my best guess :)
<18> aloof: there have been some pretty stupid bugs with p***words in the history of mysql
<16> malchias: yep
<18> aloof: but imho, if you p***words are good, there shouldn't be much of a problem using it in a lan
<17> just make sure that p***words are set for every user too, like the little message says when you first install mysql :)
<19> !man securing
<1> (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<16> that, I took care of 1-st, got the root p***wd in :)
<16> there is also a FW-IPsec router that is set-up not to allow direct outside connection to ports like 3306, but ...
<20> hi
<20> why when i use grant to set privileges
<20> at the end of a session i loose that
<21> in myisam, does row deletion lock the entire table from updates?
<16> why do do they include the "test" user with initial install of MySQL - and then say "remove it" heh ?
<22> I am using mysql with PHP. if I have an INSERT statement in a table with an auto_inrement feild, is there a way to get the value of what the index is without doing a select statement?
<23> aloof: By the name, I'd have to guess that it's included for testing.
<13> how do I get phpmyadmin to show unicode chars ?
<7> paulgb: yes.. did you even bother to check the php mysql section?
<22> yes, i couldnt find a functino that did what i needed
Return to
#mysql
or
Go to some related
logs:
#lgp
#lisp
email sent two places sendmail
#centos
sounddex
dma_timer_expiry dma status == 0x21 Compaq ARMADA
#css
ubuntu change workgroup
#web
ubuntu userflags
|
|