Difference between revisions of "MySQL"

Jump to navigation Jump to search
17 bytes added ,  14:48, 18 January 2010
m
→‎Create Users: Added SyntaxHighlight
m (Added link to official MySQL documentation)
m (→‎Create Users: Added SyntaxHighlight)
Line 22: Line 22:
=== Create Users ===
=== Create Users ===
To give full privileges to a user coming from any location use;
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>
* <source lang="mysql"> GRANT ALL PRIVILEGES on <database>.* to '<user>'@'%' identified by '<password>' with grant option; </source>


=== Display Users ===
=== Display Users ===

Navigation menu