This is an old revision of the document!
http://comsci.liu.edu/~murali/cvs/pserver.htm
A. Adding the CVSROOT environment variable Add the following two lines to your .cshrc (or equivalent) file: umask 007 (this will replace any existing umask) setenv CVSROOT $HOME/.cvsroot (.cvsroot is the main CVS repository) This sets up the CVSROOT environment variable, which is needed by CVS (for example, $HOME = /u2/rmflatt/ ). Logout and log back in for these changes to take affect B. Setting up the CVS repository so that other group members and yourself can checkout/in files. Go to your root directory type: groups (this determines which groups you are a part of. Remember the group name you wish to use CVS with) type: umask 007 (all new files will be locked to outsiders but readable and writable by the owner and group of the file) type: mkdir .cvsroot (this is the CVS repository) type: chgrp group_name .cvsroot (allows the group 'group_name' access to the .cvsroot repository - substitute group_name with a group name from step 2 [i.e. cs354_31] ) type: chmod 2770 .cvsroot (makes the repository owner and group readable and writable) type: mkdir .cvsroot/CVSROOT (all the files that CVS needs are stored within this directory) type: mkdir .cvsroot/project (where project is the name of the project you're working on. Make as many 'project's as desired. A module with the name 'project' will be used [this name goes in the file modules, as described on step 12]) type: cvs init (this populates the .cvsroot/CVSROOT directory with the files that CVS needs. This step assumes the CVSROOT environment variable has been set) Go to your root directory type: cvs checkout CVSROOT/modules (this creates a CVSROOT directory tree in your root) Edit the file (~/CVSROOT/modules) and insert a line that defines the module(s) you're working on (i.e. 'project'). Add the following line at the end of the file (you can add as many modules as needed): project_name project (where project_name is the name of the module you want defined, and project is the name of the directory containing the files [as created on step 8]) Save ~/CVSROOT/modules type: cvs commit -m "The message to log with this change" CVSROOT/modules (this commits this changed file into the repository) type: cvs release -d CVSROOT (this releases (and deletes) the CVSROOT working directory, which you just checked out/in) To import an existing directory (with files) into the repository: Go to the directory that contains any directories/files that you want to import into CVS type: cvs import -m 'Initial checkin' project_name VENDER_TAG RELEASE_TAG (This imports (recursively) any directories/files in the current directory into the project_name repository. VENDER_TAG and RELEASE_TAG can be anything)
Installing MySQL with APT Install MySQL by the following command: shell> sudo apt-get install mysql-server Starting and Stopping the MySQL Server The MySQL server is started automatically after installation. You can check the status of the MySQL server with the following command: shell> sudo service mysql status Stop the MySQL server with the following command: shell> sudo service mysql stop To restart the MySQL server, use the following command: shell> sudo service mysql start
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> WITH GRANT OPTION; mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> WITH GRANT OPTION; mysql> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin_pass'; mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> CREATE USER 'dummy'@'localhost';
#! /bin/bash mysql --user=root --password= --host=162.209.124.42 wrb@media-labs-server-2:~/queue/sql$ cat c #! /bin/bash mysql --user=wrb --password= --host=162.209.124.42 parks create database parks;
netstat -tln Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN tcp6 0 0 :::8080 :::* LISTEN tcp6 0 0 :::80 :::* LISTEN tcp6 0 0 :::22 :::* LISTEN tcp6 0 0 127.0.0.1:8005 :::* LISTEN tcp6 0 0 :::8009
# vi /etc/my.cnf Step # 3: Once file opened, locate line that read as follows [mysqld] Make sure line skip-networking is commented (or remove line) and add following line bind-address=YOUR-SERVER-IP For example, if your MySQL server IP is 65.55.55.2 then entire block should be look like as follows: [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = 65.55.55.2 # skip-networking .... ..
nc -z -w1 54.87.112.192 3306 Connection to 54.87.112.192 port 3306 [tcp/mysql] succeeded!
show tables; show grants; use mysql; describe user;
mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | event | | func | | general_log | | help_category | | help_keyword | | help_relation | | help_topic | | host | | ndb_binlog_index | | plugin | | proc | | procs_priv | | proxies_priv | | servers | | slow_log | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---------------------------+ 24 rows in set (0.00 sec) mysql>