Difference between revisions of "MySQL"

From CSCWiki
Jump to navigation Jump to search
(note that this can be done through ceo)
(expand the line detailing the use of ceo for MySQL databases)
Line 1: Line 1:
==== Creating new MySQL databases ====
+
=== Creating new MySQL databases ===
   
  +
==== Using ceo ====
Users can now create their own MySQL databases through [[ceo]]. To create a MySQL database manually:
 
  +
 
Users can create their own MySQL databases through [[ceo]]. Users emailing syscom asking for a MySQL database should be directed to do so. The process is as follows:
  +
  +
# SSH into any [[Machine_List|CSC machine]].
  +
# Run <tt>ceo</tt>.
  +
# Select "Create MySQL database" and follow the instructions.
  +
# Login info will be stored in <tt>ceo-mysql-info</tt> in your home directory.
  +
# The user can now connect to the MySQL database (from [[Machine_List#caffeine|caffeine]] only).
  +
  +
==== Manually ====
  +
To create a MySQL database manually:
   
 
$ mysql -uroot -p
 
$ mysql -uroot -p

Revision as of 13:28, 13 March 2010

Creating new MySQL databases

Using ceo

Users can create their own MySQL databases through ceo. Users emailing syscom asking for a MySQL database should be directed to do so. The process is as follows:

  1. SSH into any CSC machine.
  2. Run ceo.
  3. Select "Create MySQL database" and follow the instructions.
  4. Login info will be stored in ceo-mysql-info in your home directory.
  5. The user can now connect to the MySQL database (from caffeine only).

Manually

To create a MySQL database manually:

$ 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 (usually ~club/mysql) 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.