CSCWiki - User contributions [en]

MySQL

2017-11-03T04:11:38Z

Ekfong: /* Creating new MySQL databases */

=== 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:

# 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.
# You can now connect to the MySQL database (from [[Machine_List#caffeine|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.

=== Replication ===

See the history of this page for information on the previous replication setup.

=== Deleting MySQL databases ===

Users can delete their own MySQL databases.

SSH into [[Machine_List#caffeine|caffeine]].
mysql -u yourusernamehere -p
Enter password: ******
DROP DATABASE database name goes here
Login info and database name was created on database creation in <tt>ceo-mysql-info</tt> in your home directory.

[[Category:Software]]

MySQL

2017-11-03T04:11:23Z

Ekfong:

=== 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:

# 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.
# You can now connect to the MySQL database (from [[Machine_List#caffeine|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.

=== Replication ===

See the history of this page for information on the previous replication setup.

=== Creating new MySQL databases ===

Users can delete their own MySQL databases.

SSH into [[Machine_List#caffeine|caffeine]].
mysql -u yourusernamehere -p
Enter password: ******
DROP DATABASE database name goes here
Login info and database name was created on database creation in <tt>ceo-mysql-info</tt> in your home directory.

[[Category:Software]]