#mysql
07 November 2007
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:35 <****> im on the http://dev.mysql.com/doc/refman/5.0/en/grant.html , but I'm very confused.
02:36 <****> I guess [(column_list)] and ON [object_type] {tbl_name | * | *.* | db_name.*} are confusing me
02:36 <****> select instead of select_pirv
02:36 <****> okay
02:37 <****> and can I ask what column_list is and the reason for | * | *.* | db_name.*
02:37 <****> column list is restrict priv to the listed col
02:37 <****> dbname.tablename
02:37 <****> for a particular db or a particular table in a db
02:38 <****> Xye: analogy will be permission to a file, or all files in a directory
02:45 <****> GRANT select ON table user *mysql.* TO php 'f00';
02:45 <****> would that be correct?
02:45 <****> no
02:45 <****><
02:45 <****> Will you point out my mistake?
02:46 <****> !m xye grant
02:46 <****> xye: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
02:46 <****> learn to read syntax
02:46 <****> I am looking at the page now
02:46 <****> the syntax is right there, learn how to interpret syntax
02:47 <****> yea I have been practicing, that is why I am asking about GRANT ^_^
02:47 <****> * | *.* | db_name.* confuses me
02:47 <****> | means OR, choose one
02:48 <****> * is a wildcard here
02:48 <****> GRANT select ON table user mysql.* TO php IDENTIFIED BY 'f00';
02:48 <****> almost there
02:49 <****> where does user comes from
02:49 <****> mysql database?
02:49 <****> mysql.user then
02:49 <****> ooh
02:49 <****> mysql.* all tables in mysql db
02:49 <****> okay I see what you are saying
02:49 <****> hi how can I see the name of the columns only
02:50 <****> JZA: infromation_schema.columns
02:51 <****> GRANT select, insert, update, delete ON table user mysql.user TO php IDENTIFIED BY 'f00';
02:51 <****> would grant multiple priv?
02:51 <****> multiple priv is fine
02:51 <****> but user is a problem
02:52 <****> table user?
02:52 <****> select column_name from testdatabase.columns where table_name='test_table' and table_schema='testdatabase'
02:52 <****> testdatabase?
02:53 <****> should be information_schema.columns
02:53 <****> testdatabase.columns ?
02:56 <****> there is a problem with GRANT select ON table user ?
02:56 <****> yes
02:59 <****> what is the problem?
02:59 <****> name of table is user, no?
03:00 <****> Xye: ON [object_type] {tbl_name | * | *.* | db_name.*}
03:01 <****> see the |
03:01 <****> { | | | } choose one
03:01 <****> ok
03:01 <****> and read the description on the differences
03:03 <****> GRANT select, insert, update, delete ON table mysql.user TO php IDENTIFIED BY 'f00';
03:03 <****> correct I think.
03:05 <****> i have a server on a internal home network..wouldn't this be correct for allowing access from anything...including localhost / console access? grant all on *.* to root@'%' identified by 'foo' with GRANT option
03:05 <****> when i do this and remove some of the other root accounts...i can no longer log in from my ssh console
03:08 <****> yay, thank you kimseong
03:11 <****> Hello, is there a problem with storing php code in a database? I am trying add a php include code in the database, but when I pull up the page, nothing is happening to the code
03:11 <****> when I browse the source of the page, the codee is printed in the source
03:12 <****> why would you store php code in the database?
03:12 <****> Yea I never though you could actually put code into the database
03:12 <****> but I could be wrong
03:12 <****> you can put anything in the database
03:12 <****> rhavenn: try to connect from remote machine
03:12 <****> maybe he is storing his scripts or something
03:13 <****> Well I am adding the code via fckeditor, as part of a document, so it executes when I pull up the page for this particular document
03:13 <****> save it as a non .php file?
03:13 <****> its not a file, all text is stored in the database
03:13 <****> but i think that's one of the easiest ways, historically, to end up being featured on thedailywtf
03:13 <****> thanks..don't have mysql on any other machine at the moment..i'll dink around with it..
03:14 <****> it was just one of those "shouldn't this work" type of things :)
03:14 <****> rhavenn: suspect you have user ''@localhost
03:15 <****> hey kim is that query supposed to return a blob
03:15 <****> rhavenn: which take precedence over root@'%'
03:15 <****> slb_: what query?
03:15 <****> the one you gavem e before
03:15 <****> no
03:15 <****> haha ok
03:15 <****> nope, removed all users except the root@'%' user
03:15 <****> oh, it returns the week in 1 single field
03:16 <****> not 5 separate fields
03:16 <****> it says BLOB-20 bytes
03:16 <****> so i suppose its working?
03:16 <****> slb_: no idea, try runs in phpmyadmin or mysql client
03:16 <****> how can i calculate how much memory mysqld might use?
03:16 <****> flyingparchment: not easy but a max might be possible
03:17 <****> it just decided to use all my swap space then run out of memory and crash, so i'd like to know why :)
03:19 <****>, it works fine when I add it to the template page, but when storing and retriving nothing happens.
03:19 <****> do I need to do something to it when adding it?
03:20 <****> bor1cua: this is not php channel
03:20 <****> I understand, I am trying to figure out if this is a mysql issue, as the script works fine.
03:21 <****> I dont understand much about mysql besides storing and retriving my data hehe
03:21 <****> kimseong: phpmyadmin returns it and says [blob-20 bytes] but thats it
03:21 <****> slb_: hmm, can you pastebin the query you using
03:22 <****> slb_: select version() to see what version is the mysql server
03:23 <****> drop do I drop a user if the host: is a % value/
03:24 <****> Hi, I'm using mysqldumpslow to diagnose database performance issues, and am finding the the reported times are sometimes ludicrously large. Thoughts?
03:25 <****> For instance, a simple query taking upwards of 20s to execute once?
03:25 <****> fbond: lock time?
03:25 <****> kimseong: 0
03:26 <****> no idea
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last