2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
Added "User Accounts"
(Initial creation) |
m (Added "User Accounts") |
||
| Line 1: | Line 1: | ||
== User Accounts == | |||
=== Create Users === | |||
To give full privileges to a user coming from any location use; | |||
* <code> GRANT ALL PRIVILEGES on <database>.* to '<user>'@'%' identified by '<password>' with grant option; </code> | |||
=== Display Users === | |||
To display all configured users; | |||
* <code> <nowiki> SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') FROM mysql.user </nowiki></code> | |||
Then use the displayed lines to see the detail of each user | |||
== Data Types == | == Data Types == | ||
=== IP Addresses === | === IP Addresses === | ||