MySQL

From CSCWiki
Revision as of 15:17, 9 July 2009 by Mspang (talk | contribs) (New page: ==== Creating new MySQL databases ==== $ mysql -uroot -pSECRET-PASSWORD > CREATE DATABASE someusername; > GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Creating new MySQL databases

$ mysql -uroot -pSECRET-PASSWORD
> CREATE DATABASE someusername;
> GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY 'longrandompassword';

For random passwords run 'makepasswd --chars 20'. For the administrative password for the cluster see /users/sysadmin/passwords/mysql.