You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2019/06/10 19:36:18 UTC
svn commit: r1860975 - /vcl/site/trunk/content/docs/installphpmyadmin.mdtext
Author: jfthomps
Date: Mon Jun 10 19:36:18 2019
New Revision: 1860975
URL: http://svn.apache.org/viewvc?rev=1860975&view=rev
Log:
fixed indentation of user grant sql commands section
Modified:
vcl/site/trunk/content/docs/installphpmyadmin.mdtext
Modified: vcl/site/trunk/content/docs/installphpmyadmin.mdtext
URL: http://svn.apache.org/viewvc/vcl/site/trunk/content/docs/installphpmyadmin.mdtext?rev=1860975&r1=1860974&r2=1860975&view=diff
==============================================================================
--- vcl/site/trunk/content/docs/installphpmyadmin.mdtext (original)
+++ vcl/site/trunk/content/docs/installphpmyadmin.mdtext Mon Jun 10 19:36:18 2019
@@ -57,21 +57,21 @@ it was at /usr/share/phpMyAdmin/sql/crea
Save the following in a file named pmaprivs.sql to grant the pmacontrol user access to various parts tables:
- <div><pre>
- GRANT USAGE ON mysql.* TO 'pmacontrol'@'localhost';
- GRANT SELECT (
- Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
- File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
- Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
- Execute_priv, Repl_slave_priv, Repl_client_priv
- ) ON mysql.user TO 'pmacontrol'@'localhost';
- GRANT SELECT ON mysql.db TO 'pmacontrol'@'localhost';
- GRANT SELECT ON mysql.host TO 'pmacontrol'@'localhost';
- GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
- ON mysql.tables_priv TO 'pmacontrol'@'localhost';
- GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pmacontrol'@'localhost';
- </pre></div>
+ <div><pre>
+ GRANT USAGE ON mysql.* TO 'pmacontrol'@'localhost';
+ GRANT SELECT (
+ Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
+ Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
+ File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
+ Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
+ Execute_priv, Repl_slave_priv, Repl_client_priv
+ ) ON mysql.user TO 'pmacontrol'@'localhost';
+ GRANT SELECT ON mysql.db TO 'pmacontrol'@'localhost';
+ GRANT SELECT ON mysql.host TO 'pmacontrol'@'localhost';
+ GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
+ ON mysql.tables_priv TO 'pmacontrol'@'localhost';
+ GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pmacontrol'@'localhost';
+ </pre></div>
:::BashLexer
mysql < pmaprivs.sql