1.安装 VMware tools,方便后续文件的共享
因为安装完以后,机器上一直是安装盘占用着
所以需要通过命令行弹出光盘,然后换成 linux工具安装盘
a.在终端中输入
eject
将光驱弹出(否则Ubuntu会保护)
b.选择安装 Vmware Tools(T)
c.将安装程序拷贝到本地
sudo mkdir /mnt/cdrom
sudo mount /dev/cdrom /mnt/cdrom
cp /mnt/cdrom/*.gz .
gunzip *.gz
tar -xf *.tar
cd vmware-tools-distrib
sudo chmod 777 *.pl
sudo ./vmware-install.pl
d.执行重启
参考网页:
https://www.cnblogs.com/QuLory/archive/2012/10/23/2735489.html
2.配置ubuntu使用ssh登录,方便后续通过windows来使用终端
2.1.安装openssh-server:
dpkg -l | grep ssh
sudo apt-get install openssh-server
sudo apt-get install openssh-client
sudo service ssh reload
2.2.修改配置文件
sudo vi /etc/ssh/sshd_config
将PermitRootLogin prohibit-password 注释后
改成
PermitRootLogin yes
然后
sudo service ssh reload
参考网页
https://blog.csdn.net/weixin_43319854/article/details/104181545
https://www.linuxidc.com/Linux/2018-01/150591.htm
3.安装postgresql
更新源,然后安装 postgresql 9.5
sudo apt-get update
sudo apt-get install postgresql-9.5
------------------------------------------------
修改root密码
sudo passwd root
以root登录
su - root
清空密码
sudo passwd -d postgres
设置密码
sudo -u postgres passwd
登录并使用 psql
sudo -u postgres psql
ALTER USER postgres WITH PASSWORD '123456';
\q
sudo iptables -A INPUT -p tcp -m state --state NEW -m tcp --dport 5432 -j ACCEPT
sudo vi /etc/postgresql/9.5/main/postgresql.conf
1.监听任何地址访问,修改连接权限
#listen_addresses = 'localhost' 改为 listen_addresses = '*'
2.启用密码验证
#password_encryption = on 改为 password_encryption = on
sudo vi /etc/postgresql/9.5/main/pg_hba.conf
在文档末尾加上以下内容
host all all 0.0.0.0 0.0.0.0 md5
重启服务
sudo /etc/init.d/postgresql restart
参考网页:
https://www.cnblogs.com/zhangpengshou/p/5464610.html
4.安装mysql
sudo apt-get install mysql-server
sudo netstat -tap | grep mysql
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
加上
skip-grant-tables
sudo service mysql restart
mysql
mysql> use mysql
update mysql.user set authentication_string=password('lyr1115') where user='root' and Host='localhost';
flush privileges;
grant all privileges on *.* to 'root'@'%' identified by 'lyr1115' with grant option;
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
加上
character_set_server=utf8
找到 bind-address = 127.0.0.1 在前面加上#注释掉,如下:
#bind-address = 127.0.0.1
加上
skip-external-locking
skip-name-resolve
sudo service mysql restart
参考网页:
https://blog.csdn.net/weixin_42209572/article/details/98983741
https://blog.csdn.net/mq75956672/article/details/78248370