Difference between revisions of "More MySQL Examples"
From Free Knowledge Base- The DUCK Project: information for everyone
(New page: Just Some More Examples Here: GRANT USAGE ON mysql.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, ...) |
m |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
Just Some More Examples Here: | Just Some More Examples Here: | ||
| + | |||
| + | == user management == | ||
GRANT USAGE ON mysql.* TO 'username'@'localhost' IDENTIFIED BY 'password'; | GRANT USAGE ON mysql.* TO 'username'@'localhost' IDENTIFIED BY 'password'; | ||
| Line 12: | Line 14: | ||
alter table movies add mediatype varchar(8); | alter table movies add mediatype varchar(8); | ||
| + | == version and installation info == | ||
| + | |||
| + | at the mysql prompt type: | ||
| + | mysql> status | ||
| + | details about your installation | ||
| + | |||
| + | on a running mediawiki installation the special page "Special:Version" also has version information | ||
| + | /index.php/Special:Version | ||
| + | |||
| + | | ||
| + | |||
| + | | ||
[[Category:Computer Technology]] | [[Category:Computer Technology]] | ||
[[Category:Programming]] | [[Category:Programming]] | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
| + | [[Category:SQL]] | ||
Latest revision as of 09:13, 1 July 2017
Just Some More Examples Here:
user management
GRANT USAGE ON mysql.* TO 'username'@'localhost' IDENTIFIED BY 'password';
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 ) ON mysql.user TO 'username'@'localhost'; GRANT SELECT ON mysql.db TO 'username'@'localhost'; GRANT SELECT ON mysql.host TO 'username'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'username'@'localhost';
insert into tablename ( field1, field2, field3 ) values ( 'LNX', 'RZ1', 1 );
alter table movies add mediatype varchar(8);
version and installation info
at the mysql prompt type:
mysql> status
details about your installation
on a running mediawiki installation the special page "Special:Version" also has version information
/index.php/Special:Version
