Google Cloud - gqqnbig/cs145project GitHub Wiki

配置

sudo apt update
sudo apt-get install --yes git
sudo apt-get install --yes python3
sudo apt-get install --yes python3-pip 
sudo pip3 install kaggle
sudo python3 -m pip install sklearn
sudo python3 -m pip install matplotlib

git config --global user.email '[email protected]'
git config --global user.name 'QQ喵'
#let git remember my password
git config --global credential.helper cache 

git clone https://[email protected]/gqqnbig/LinuxSetup.git --depth=1
ln LinuxSetup/.vimrc .vimrc
vim .vimrc
mkdir .kaggle
vim .kaggle/kaggle.json
chmod 600 ~/.kaggle/kaggle.json

git clone https://github.com/magicmonty/bash-git-prompt.git ~/.bash-git-prompt --depth=1
# follow https://github.com/magicmonty/bash-git-prompt#via-git-clone



git clone https://[email protected]/gqqnbig/cs145project.git

安装MySQL

pip3 install mysql-connector-python

echo 'secure-file-priv=""' >> /etc/mysql/mysql.conf.d/mysqld.cnf
sudo /etc/init.d/mysql restart

sudo vim /etc/apparmor.d/usr.sbin.mysqld

add /tmp/** rwk, /home/** r, https://stackoverflow.com/a/13677611/746461

sudo /etc/init.d/apparmor reload

grant all privileges  on *.* to root@'%' identified by "password";

安装SQL Server

sudo apt-get install unixodbc unixodbc-dev sudo -H pip3 install pyodbc

https://docs.docker.com/install/linux/docker-ce/ubuntu/

sudo groupadd docker sudo usermod -aG docker $USER

重新连接SSH

这个是SQL Server 2014。

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -p 1433:1433 -d microsoft/mssql-server-linux

不能用 https://hub.docker.com/_/microsoft-mssql-server ，2017、2019版都不支持bulk insert。

User permission ADMINISTER BULK OPERATIONS is not supported on Linux at this time.

SSH公钥

ssh-rsa AAAAB3NzaC1yc2EAAAABJQAAAQEAhlY2vQ4E5YPKcrjdRp6+EuI7307YYLHVU4r8XlpLmkKYksr0TJkgiPjXqHqjDnUsRgE+lIOwsLL+34VI278MFigdQuyKd6w3VAwdYSvytGmpvC9R9dCC5L8KuCsV1M4w79Bjin2x9Nk5Kn31rtLQ40tb3sVQxWWEGRc7zbKhzkVhHYo5SO/84tTQhXSKDwWXW+1vy7iyi/oRr0+oCa23C/ofLOsXZhnOJ+aTiEcZZEgDvbSuY/sLE6T/B+TttB9DmabBajAB4o52VyNishV0EfZXT6qs8lhEl2iYAMu6tppAnEi4Iv5DOtZizRLBGJgokJLOPEKit/XGIAlRlKQz8w== guqq0717

ssh-rsa AAAAB3NzaC1yc2EAAAABJQAAAQEAnfQnzFI1ZOctDW3R7RP1eDjIS+shSC661VQ+l7fvKD7Ttn3cpUY6jiE4i0ActXgkWKDlUpuTsBmFMvRXQPVHARNlMKFv1WLIrHll6CGjW62XkXBYloLUcisGkoKFXeJonXo69DEYchxZ4VV1H10dtSepU+dpU4hoaiS3VLIbB1Fbwgi3bwnWUM1e8nXjAar/emMJRncoGv9zHkIDo3zRAuXaDwwQH8EHJxuvextiQwiKwiUWmoQWz4kXWj9Pu9JTN4dcDeszQv5OmkfqZhJYzp7UJzyC1OMN8ehS4wb5TNmmdCp0h+3g1U8VDtSbTjlBj1+iigA7VG+RRg0ipnj0zw== kelly-key-01

ssh-rsa AAAAB3NzaC1yc2EAAAABJQAAAQEAh+D4mmLhrsaHiMyfJ4bdKzrrbG684v3Q7mvSHmw94BITB3rbp3qAJkEFvzfdRku1gwcbNEwUi9HH7Ko0NiBISlT8QWspCT1q0kHF9cDz3d88FKE1dxspjwaGVJ09/KjGoXj7/zM64ektNCvDadksHLnRe4lPKeyFxV5lC5jXV+byVtfeGSKRyfsrc2qRSWAJqcQpX6VHYi63OMrGGQb02Z0yY7ZOJ62WIVwkV/nYevSgpBvt53t44gzpx0LMIeuAWVD98A0lgEb9eBUXCsvGOLKMUE290fmVri1Q0sQhVdxSl0gphS/PuokdJDNuM6R0WOlA6A8Vb+yaCZrIAc2zFw== zhaoxiao

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQD0qugWKa0aWw6yoDqwxMb+1u+wCdSVTX/c7EqAUtnOzLva9ytV4WBngkYfOuw+z+nzEH3hoGItl/YKFRNqkFktaKx7t1D6M57gf1Kpqjao39p7ZTSunyMG3Kzit2GIAgc1QqPowqeHBI0Fk0w8jlaJSYL6FXhYKCrK/kUxj6Z3hMUdJswyIO9E1X4HKMyc4aqOH5DJuBKD4MQlXi9nsExDxwXga8xVREO3FnV1pX2byr/h023PguIm2mDmy0xRbipYo9Da8HSMXHPwpuLkMKLnuWNHYreKdtYrx7CrQxQFd7lTostc4fjEMfS4b4tkkzLP2nAc4SxZnJeQgkiupjcGzr4L8kSdiiRU2iDQcyJQfSJcUsJuepDr/MmgHrpUGmcWgnQAKa7X5ZasSR3F7YtY8QGXVGxUgLehNPP5q3FNKm5nblmi00Zp/F/VavOf3iG3qnacwbnAdUDjkeGZ1gSyhMjDca66B8b81hBlgAWIuw+i3BoX1nguXNKdrDQwsDYiUZW1fKmCTnISj8juLdGIC/9LyZT4gHqDhGZ30Fde+4Z/9ZzdSMK1rcoxpzH6mIqe7hW1en68x0HTzr+s/bKtEjy/cQYMRwJqpRwKMGnhaBFYi3JcaDfvL2QsCZ5udJKPT0lep5Wzayr7t77Ef2cBawGIeg4958BBxj2fLKxitQ== [email protected]