Difference between revisions of "MySQL"

From CSCWiki
Jump to navigation Jump to search
(New page: ==== Creating new MySQL databases ==== $ mysql -uroot -pSECRET-PASSWORD > CREATE DATABASE someusername; > GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY...)
 
Line 1: Line 1:
 
==== Creating new MySQL databases ====
 
==== Creating new MySQL databases ====
   
$ mysql -uroot -pSECRET-PASSWORD
+
$ mysql -uroot -p
  +
Enter password: ******
> CREATE DATABASE someusername;
 
  +
> GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY 'longrandompassword';
 
 
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.
 
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

Revision as of 15:20, 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