docker服务器部署(ubuntu安装mysql有效)

ubuntu版本查看命令

cat /proc/version

Linux version 5.8.0-38-generic (buildd@lgw01-amd64-060) (gcc (Ubuntu
9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #43~20.04.1-Ubuntu SMP Tue Jan 12 16:39:47 UTC 2021

修改文件权限

sudo chmod -R 777 /opt

安装docker

sudo apt-get install -y docker.io

Linux安装docker

yum -y install docker

docker运行命令

systemctl start docker.service
systemctl enable docker.service
systemctl stop docker.service
systemctl restart docker.service

（1）查看安装过的包：yum list installed | grep docker

 本机安装过的旧版本：docker.x86_64，docker-client.x86_64，docker-common.x86_64

（2）删除安装的Docker相关的软件包：

 yum -y remove docker.x86_64

 yum -y remove docker-client.x86_64

 yum -y remove docker-common.x86_64

systemctl start docker
关闭docker systemctl stop docker
重启docker
systemctl restart docker
查看docker的运行状态
systemctl status docker

docker 添加 java8

sudo docker pull java:8

docker运行nacos命令
sudo docker pull nacos/nacos-server

docker run -d -e MODE=standalone -e SPRING_DATASOURCE_PLATFORM=mysql -e MYSQL_SERVICE_HOST=127.0.0.1 -e MYSQL_SERVICE_PORT=3306 -e MYSQL_SERVICE_USER=root -e MYSQL_SERVICE_PASSWORD=123456 -e MYSQL_SERVICE_DB_NAME=education-config -p 8848:8848 --restart=always --name nacos nacos/nacos-server

docker配置redis
//安装redis

sudo docker pull redis:latest
或者
sudo docker run --log-opt max-size=100m --log-opt max-file=1 -itd --restart=always --name redis -p 6379:6379 redis
或者
docker run -d --name myredis -p 6379:6379 redis:3.2 --requirepass “123456”
或者
docker run -d --name redis -p 6379:6379 redis --requirepass “123456”

ubuntu JDK配置

sudo  vi /etc/profile
sudo gedit /etc/profile

#profile底部添加
export JAVA_HOME=/opt/jdk  #jdk地址
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar 

保存后
sudo source /etc/profile

ubuntu安装mysql
#命令1 更新源
sudo apt-get update
#命令2 安装mysql服务
sudo apt-get install mysql-server
初始化配置
sudo mysql_secure_installation

VALIDATE PASSWORD PLUGIN can be used to test passwords...
Press y|Y for Yes, any other key for No: N (选择N ,不会进行密码的强校验

检查mysql服务状态

systemctl status mysql.service

通过apt 安装MySQL服务（推荐，会安装最新版）
#命令1 更新源

sudo apt-get update

1

#命令2 安装mysql服务

sudo apt-get install mysql-server

初始化配置

sudo mysql_secure_installation

配置项较多，如下所示：

#1

VALIDATE PASSWORD PLUGIN can be used to test passwords...
Press y|Y for Yes, any other key for No: N (选择N ,不会进行密码的强校验)

#2

Please set the password for root here...
New password: (输入密码)
Re-enter new password: (重复输入)

#3

By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them...
Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (选择N，不删除匿名用户)

#4

Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network...
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : N (选择N，允许root远程连接)

#5

By default, MySQL comes with a database named 'test' that
anyone can access...
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (选择N，不删除test数据库)

#6

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (选择Y，修改权限立即生效)

检查mysql服务状态

systemctl status mysql.service

配置远程访问

在Ubuntu下MySQL缺省是只允许本地访问的，使用workbench连接工具是连不上的；
如果你要其他机器也能够访问的话，需要进行配置；

找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf #找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)
或者

sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf #找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

sudo /etc/init.d/mysql restart #重启mysql

sudo mysql -uroot -p

输入用户密码

#切换数据库

mysql>use mysql;

#查询用户表命令：

mysql>select User,authentication_string,Host from user;

#查看状态

select host,user,plugin from user;

#设置权限与密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; #使用mysql_native_password修改加密规则
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #更新一下用户的密码
mysql> UPDATE user SET host = '%' WHERE user = 'root'; #允许远程访问

#刷新cache中配置 刷新权限

mysql>flush privileges; 
mysql>quit;

ubuntu 20.04版本安装mysql
#命令1 更新源

sudo apt-get update

#命令2 安装mysql服务

sudo apt-get install mysql-server

安装后直接无密码进入mysql

sudo service mysql restart # 重启mysql
sudo mysql # 回车进入

->mysql    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; #更改mysql的默认root用户密码
->mysql   FLUSH PRIVILEGES;
->mysql   quit; # 退出mysql
sudo service mysql restart # 重启mysql
再次登录使用   mysql -u root -p 回车后输入密码

远程链接mysql
总体运行语句:

总体运行语句:

mysql -u root -p

mysql>use mysql;

mysql>select 'host' from user where user='root';

mysql>update user set host = '%' where user ='root';

mysql>flush privileges;

mysql>select 'host'   from user where user='root';