Difference between revisions of "MySQL"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
$ mysql -uroot -p | $ mysql -uroot -p | ||
Enter password: ****** | Enter password: ****** | ||
| − | + | ||
mysql> CREATE DATABASE someusername; | mysql> CREATE DATABASE someusername; | ||
Query OK, 1 row affected (0.00 sec) | Query OK, 1 row affected (0.00 sec) | ||
| − | + | ||
mysql> GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY 'longrandompassword'; | mysql> GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY 'longrandompassword'; | ||
Query OK, 0 rows affected (0.06 sec) | Query OK, 0 rows affected (0.06 sec) | ||
Revision as of 15:21, 9 July 2009
Creating new MySQL databases
$ mysql -uroot -p Enter password: ****** mysql> CREATE DATABASE someusername; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY 'longrandompassword'; Query OK, 0 rows affected (0.06 sec)
For random passwords run 'makepasswd --chars 20'. For the administrative password for the cluster see /users/sysadmin/passwords/mysql.
Write a file to the club's homedir readable only by them containing the following:
Username: clubuserid Password: longrandompassword Hostname: localhost
Try not to send passwords via plaintext email.