MySQL: Difference between revisions

From CSCWiki
Jump to navigation Jump to search
No edit summary
No edit summary
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.