/Work-BU-Docs/HARVEYV/Migration-HarveyV-BingDEV-Steps

https://docs.google.com/spreadsheets/d/1Am05mrkqbfEpsZu40wXrCUfqtAZj0LwxQs62C5CawBM/edit#gid=0

BingDEV
01 - make the account
        if user useradd
        if vhost groupadd and useradd
	NewUserAdd.bash

        add a passwd

HarveyV
02  rsync content to bingdev
    cd /u0/users/<username>
    /usr/bin/rsync -arvz exclude \"./.*\" *   root@34.238.23.117:/local/htdocs/<username|vhost>/.
   


BinBingDEV
03  chmod -R 755 /local/htdocs/<username|vhost>
    chown  -R <un>:vhosts
    chown -R <vbhost>:<vhost>

    -- reset content
    if  files dirs in base
    mkdir DESKTOP
    move files and directories to DESKTOP
    cd public_html; mv * ../.
   
04  Test web site for content display

05  cleanup as needed

HarveyV
06 in /u0/users/<username>
    mv index.html orig-index.html
    in index.html
     <meta http-equiv="Refresh" content="0; url='https://bingdev.binghamton.edu/<usernmame>'" />"
       -- or --
     <meta http-equiv="Refresh" content="0; url='https://<vhost>.binghamton.edu/'" />"
        Test the redirect

<meta http-equiv="Refresh" content="3; url='https://bingdev.binghamton.edu/###'" />

<pre>
<font size="+2">

c

<b>
harveyv.binghamton/~### has been migrated to <a href="https://bingdev.binghamton.edu/###">https://bingdev.binghamton.edu/###</a>
Please note the new URL
</b>
</font>
</pre>


mysql> CREATE USER 'craig'@'localhost' IDENTIFIED by 'letm31n';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON materialsmatter.* to craig@localhost;
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

ERROR 1045 (28000): Access denied for user 'craig'@'localhost' (using password: YES)



GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON *.* TO 'craig'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;




mysql -u chouck -p -h bingdev-db.binghamton.edu



CREATE USER 'matmat'@'172.31.17.113' IDENTIFIED by 'letm31n';
GRANT ALL PRIVILEGES ON materialsmatter.* to 'matmat'@'172.31.17.113';
FLUSH PRIVILEGES;
select user,host,authentication_string from mysql.user;
mysql -u matmat -p -h bingdev-db.binghamton.edu

CREATE TABLE notes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    body MEDIUMTEXT NOT NULL
); 

https://bingdev.binghamton.edu/myDBadmin/index.php?token=033338b535a453a661c9a7f9cfe09d15#PMAURL-0:index.php?db=&table=&server=1&target=&token=033338b535a453a661c9a7f9cfe09d15


l<@1nA1

Neha Khanna <khanna@binghamton.edu>


https://bingdev.binghamton.edu/xyong/