Differences

This shows you the differences between two versions of the page.

--- auth:mysql [2014-01-14 08:42] – [Real World Examples] 14.161.32.199
+++ auth:mysql [2021-09-09 12:45] – [Configuration] Klap-in
@@ Line 27: / Line 27: @@
   * [[mysql_projectpier|ProjectPier]] - collaboration system: [[http://projectpier.org|http://projectpier.org]]
   * [[http://thedeadone.net/software/getting-dokuwiki-to-use-wordpress-authentication/|WordPress]] - a blogging system
+  * [[plugin:authmysql:wordpress_4.0|Wordpress >= 4.0]] - a blogging system
   * [[mysql_typo3|Typo3]] - an enterprise related content management system (CMS)
   * [[mysql_vbulletin|VBulletin]] - a message board / forum
   * [[mysql_wbb|Woltlab Burning Board]] - a message board / forum
   * [[mysql_moodle|Moodle]] - an elearning system
-  * testtttttttttttt
 ===== Configuration =====
-Add these configuration options to ''conf/local.php'' to use MySQL as your [[:Auth]] information store.
+Add these configuration options to ''conf/local.php'' to use MySQL as your [[:oldauthbackends|Auth]] information store.
 At least as of [[:changes#release 2006-03-09]], all options below are in the distribution in ''/conf/mysql.conf.php.example''.  Rename the file to ''mysql.conf.php'', edit it for your settings, and then add the line
@@ Line 170: / Line 170: @@
 <code php>
-$conf['auth']['mysql']['getGroups']   = "SELECT name as `group`
+$conf['auth']['mysql']['getGroups']   = "SELECT name
                                          FROM groups g, users u, usergroup ug
                                          WHERE u.uid = ug.uid
@@ Line 345: / Line 345: @@
                                          AND gid='%{gid}'";
 </code>
 ===== Example Database =====
@@ Line 612: / Line 613: @@
 > Good luck!  --- [[user>Klap-in|Klap-in]] //2013/04/13 10:18//
+==== More Help ====
+For users with less experience with MySQL I created a documentation page of my implementation of this plugin for my site. It can be found here: https://www.getshifting.com/wiki/upgradethissite2#mysql_authentication