I read it’s an alias of, so.

Dammann: J_hertz123: both of those things are possible

Umland: Hi, does mysql workbench support granting replication slave to a user or is that only a command line priv?

Dammann: Skywise: workbench can execute arbitrary SQL statements, which would include any GRANT statement you’d execute using the command-line client

Balwinski: Kolbe: my experiance is that if there are keys on the tables mysql will use does and the data will be returned in some kind of order, but the user can sort create order by on the data which removes that problem

Mcgurl: Much to learn, I have

Dammann: Skywise: i have no idea whether workbench includes support for clicking on buttons and checkboxes to grant the replication slave privilege, though

Higashida: Kolbe, understood, but i’m wondering if that is in a menu i haven’t seen

Dammann: J_hertz123: if you don’t write ORDER BY, you have zero guarantee about the order of the data you get back

Dammann: Skywise: i have no idea.

Cabada: Kolbe, yeah thats what i was asking, i’ll do it via command, but i was just checking

Dammann: Skywise: you can try #workbench, maybe?

Muellerleile: Oh, i didn’t know about that, thx

Dammann: Skywise: or look at the do***entation :

Dammann: Skywise: https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html

Kunesh: Kolbe: I get that, but in my opion the behaviour seems to be that most of my tables are returned in a predictable way, if that is not the case it is not very hard to add a default order by

Dammann: J_hertz123: stop saying that you think you’ve observed some behavior. i’m telling you that at best it’s coincidental and at worse probably just wrong

Clerf: Kolbe, thx, i see i have to first enable replication admin for them to show up, thats not exactly inuitive

Dammann: It’s fairly hard to add a default order by, since that could drastically change the execution plan of the query

Dammann: Skywise: or you can select “Custom” presumably

Dammann: Skywise: i think “not exactly intuitive” is a great description for the entirety of MySQL Workbench, and I must wonder why you are trying to do this silly task in the first place instead of just granting the privileges you know you want to grant using a GRANT statement

Segota: Kolbe: now, you probably know more then I do about MySQL, but you have no idea what my use case is, so please stop telling me what I can and can not say

Dammann: J_hertz123: i already asked you want your use case is, so you’ve had an opportunity to share that information

Dammann: If indeed that’s the case, and you want to provide some additional contextual information, go for it

Dammann: Otherwise the very best i can do is provide generic warnings that the kind of thing you appear to be doing is unwise or unsafe or otherwise objectionable

Junker: Kolbe: which is absolutely ok, but there is a difference between that and telling someone that they can’t have an opinion. no matter how wrong you think it is

Dammann: J_hertz123: yeah, it’s absolutely fine to tell someone that their *opinion* is incorrect or based on faulty information

Dammann: But i’m gonna leave you and your opinions alone for a while and get back to some other work : good luck!

Milson: Kolbe: Thank you, I appreciate that you took the time to answer my questions and pointed out where there might be problems with my approach :

Anderholm: Oh “drop” means “delete” 😀

Mattiace: Kolbe, only because i thought it should work and i was missing something, but yes at this point the command would be simpler

Chillo: Hmmm no delete is actually something else

Neumiller: Tylak: MySQL Tutorial: http://dev.mysql.com/doc/refman/5.6/en/tutorial.html SQL Tutorials: http://www.sqlcourse.com http://tut.php-quake.net/en/mysql.html and sqlzoo.net

Perruzza: Is “SERIAL” just “BIGINT” ?

Newcome: I read it’s an alias of, so i ***ume they are used interchangeably without issue?