Schiffert: Lmat: these roll-your-own functions/procedures have a serious problem in that it seems like they try to select from mysql.user first to see “if the user exists”. but normally someone really shouldn’t need permission to read from mysql.user to be able to issue GRANT or DROP USER statements .
Clock: Danfield: I want to drop the user because I want to create the user!
Keiter: Use REVOKE the GRANT and don’t worry about creating users.
Keiter: GRANT will create the user for you if it needs to!
Nicola: Keiter: That’s deprecated.
Blafield: Keiter: But it does sound nifty!
Stoviak: See http://dev.mysql.com/doc/refman/5.6/en/grant.html
Compo: Keiter: Maybe I should just use it until I have 10.1 after which I was have drop user if exists.
Keiter: However, use of GRANT to create accounts or define nonprivilege characteristics is deprecated as of MySQL 5.7.6. Instead, perform these tasks using CREATE USER or ALTER USER
Schaecher: Has anybody tried PAM for MySQL auth?
Keiter: So MariaDB is probably doing something similar in 10.1
Keiter: Lmat: I completely forgot that they were deprecating this.
Schiffert: Keiter: no, MariaDB probably won’t ever bother removing that, but who knows
Newmon: Keiter: Well.I’ll just use it since I’m not on 10.1 yet :-S
Schaecher: Brittman: what did you use on a server side?
Schaecher: Brittman: is it because there is no opensource alternative?
Brittman: Schaecher: express was free and worked well, source code be damned
Brittman: Winbind seemed pretty broken at the time, not sure if it was user error
Brittman: Obviously the goal was to auth against active directory
Losh: Snoyes: yer jobs err fine!
Reinschmidt: So I have table A which has a foreign key to Table B which one of the fields has a foreign key to table C. I would like to create a view using table A foreign key to table B to get elements from table C, Do I need to do a JOIN for this?
Brittman: SmashingX: views sometimes perform worse than queries against base tables, especially when you start stringing them together
Brittman: SmashingX: are you using this to implement security or save typing?
Tantum: Because I need that view for my website
Clolinger: Brittman: I need a view no matter what
Smolder: Because my website loads views
Warmington: I’m just thinking on how to approach this problem that I don’t know how to solve
Yeo: Trying to update a tables rows to match against another table in another database. I’m getting a foreign key constraint that I don’t understand how can be happening. http://pastebin.com/raw.php?i=5NphJLxH
Shimsky: I don’t know if a good way to do it would be with a JOIN or maybe I don’t need it
Rivenberg: An dprobably I’m just overthinking it
Kacik: It’s telling me that the attribute_id 51 would be duplicated, but if i issue the same as a select, rather than an update i can only see that attribute_id would be 51 once?
Moravek: More nicely formatted SQL – http://pastebin.com/raw.php?i=ea52Cntt
Binggeli: And simplified table structure, for point of the question
Correl: SmashingX: With what? All you need is trivial join
Drybread: Well sorry but I’m a noob for me is not trivial at all and I don’t know what would be the best approach
Correl: SmashingX: Learn SQL then
Correl: Aeiou: This error is not generated by MySQL
Affelt: Im not saying give me the SQL Risse, I’m saying how can I solve this problem
Bacha: SmashingX: Very basic join information: http://hashmysql.org/index.php?title=Introduction_to_Joins – For more indepth info: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf
Melsheimer: I mean if it’s join ok woul dbe good to know why and if I don’t need a join why