#mysql
30 December 2007
Total 14 pages. You are browsing page 4/14.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:25 <****> Lazarus REVOKE ALL PRIVILAGES, GRANT OPTION FROM postfix;
03:26 <****> PRIVILEGES*
03:27 <****> hmm didnt work either
03:27 <****> Lazarus: on that page it says, "...Before MySQL 5.0.2, DROP USER serves only to remove account rows from the user table for accounts that have no privileges. To remove a MySQL account completely (including all of its privileges), you should use the following procedure..."
03:27 <****> threnody hm i read up but it's on the system level only.. no access to that kind of stuff within mysql query
03:28 <****> robboplus_: no, I don't believe so. You'll have to use your application code (php, perl, etc)
03:28 <****> REVOKE ALL PRIVILEGES, GRANT OPTION FROM postfix [, postfix];
03:28 <****> ERROR 1064 (42000): 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 '[, postfix]' at line 1
03:28 <****>
03:28 <****> :/
03:28 <****> im so lost
03:28 <****> rofl
03:29 <****> who told you to put that [] stuff there?
03:29 <****> no one
03:29 <****> threnody hm i will most likely use perl indeed
03:29 <****> it was in the doc
03:29 <****> Lazarus REVOKE ALL PRIVILAGES, GRANT OPTION FROM postfix;
03:29 <****> of course E* there
03:30 <****> REVOKE ALL PRIVILAGES, GRANT OPTION FROM postfix
03:30 <****> REVOKE ALL PRIVILAGES, GRANT OPTION FROM postfix;
03:30 <****> ERROR 1064 (42000): 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 'PRIVILAGES, GRANT OPTION FROM postfix' at line 1
03:30 <****>
03:30 <****> still doesnt work
03:30 <****> E*
03:30 <****> spelling
03:30 <****> of course E* there
03:30 <****> privileges
03:31 <****> yay it worked because he is not here :)
03:31 <****> haha it didnt work :p
03:31 <****> REVOKE ALL PRIVILEGES, GRANT OPTION FROM postfix;
03:31 <****> ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users
03:31 <****>
03:32 <****> i think i broke it
03:32 <****> yes and now you will die.
03:32 <****> Lazarus: let me know when you're desparate
03:32 <****> he h
03:32 <****> e*
03:32 <****> iam desparate
03:32 <****> :p
03:33 <****> maybe i should install phpmyadmin
03:33 <****> my "e" is so fuckin broken... i can't believe that it's happening to my T40 :(
03:33 <****> hell no.
03:33 <****> REVOKE ALL PRIVILEGES, GRANT OPTION FROM postfix;
03:34 <****> thats exactly what i put
03:34 <****> says i cant
03:34 <****> Atlantis# mysql --version
03:34 <****> mysql Ver 14.12 Distrib 5.0.51, for portbld-freebsd6.2 (i386) using 5.0
03:34 <****> that's because you are not leet enough
03:34 <****> atlantis is calling...
03:34 <****> prompt
03:35 <****> threnody woops he is going to learn it the hard way :s
03:36 <****> naw it didnt work after i USE mysql; either
03:36 <****> what?
03:36 <****> USE mysql;
03:36 <****> Lazarus: do 'show tables;'
03:36 <****> Reading table information for completion of table and column names
03:36 <****> You can turn off this feature to get a quicker startup with -A
03:36 <****> Database changed
03:36 <****> REVOKE ALL PRIVILEGES, GRANT OPTION FROM postfix;
03:36 <****> ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users
03:36 <****> REVOKE ALL PRIVILEGES, GRANT OPTION FROM postfix;
03:37 <****> mate, just wait what threnody tells you next
03:37 <****> k
03:37 <****> done i have a list of tables now
03:37 <****> Lazarus: 'select * from user where User = 'postfix';'
03:37 <****> or type: select user from mysql.user;
03:38 <****> threnody that will blow his mind away :)
03:38 <****> okay i see the users there now
03:38 <****> is there a query I can run that would alert me as to whether or not a particular product# is already in a table, aside from assigning product# to a primary key?
03:38 <****> both postfixadmin and postfix
03:38 <****> Lazarus: do you see one or more postfix users?
03:38 <****> that's it, now you get the picture what's there
03:39 <****> ya
03:39 <****> postfix |
03:39 <****> | postfixadmin
03:39 <****> and root of course
03:39 <****> Lazarus: do 'delete from user where user like "postfix%';
03:39 <****> Lazarus: do 'delete from user where User like "postfix%';
03:40 <****> 'delete from user where User like "postfix%';
03:40 <****> ERROR 1064 (42000): 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 ''delete from user where User like "postfix%'' at line 1
03:40 <****> Lazarus delete is a reserved word you could try `delete`
03:40 <****> not User
03:40 <****> ?
03:40 <****> err n/m
03:41 <****> its not working
03:41 <****> Lazarus: now do 'select * from user where User like 'postfix%';'
03:41 <****> btw how normal is it to have 3 root accounts in the table? :)
03:41 <****> robboplus_: depends on how many host grants have been made for root
03:42 <****> threnody hm.
03:42 <****> so each grant = additional row
03:42 <****> Lazarus skip those ''
03:42 <****> 'delete from user where User like "postfix%';
03:43 <****> type: delete from user where User like 'postfix%';
03:43 <****> one sec that last one fucked shit up
03:43 <****> the box went down
03:43 <****> not sure why
03:43 <****> down?
03:43 <****> yeah
03:44 <****> 'select * from user where User like 'postfix%';' <--this one?
03:44 <****> if you typed it in with '' it wouldn't even work, couldn't harm you
Total 14 pages. You are browsing page 4/14.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last