MySQL Server和Client安装
2020.9.9
跳转目录:
- 01 Ubuntu换源
- 02 Ubuntu Server 配置静态IP
- 03 Ubuntu与主机共享文件
- 04 Ubuntu安装MySQL Cluster
- 05 Ubuntu配置数据结点
- 06 MySQL Server和Client安装
- 07 MySQL Server安装验证
一、MySQL Cluster依赖包
cd install
sudo dpkg -i mysql-common_8.0.19-1ubuntu16.04_amd64.deb
sudo dpkg –I mysql-cluster-community-client-core_8.0.19-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-cluster-community-client_8.0.19-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-client_8.0.19-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-cluster-community-server-core_8.0.19-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-cluster-community-server_8.0.19-1ubuntu16.04_amd64.deb
当安装mysql-cluster-community-server时,会出现配置提示,请求为mysql数据库root用户设置密码。请选择一个强安全密码然后敲 . 提示时重新输入这个root 密码,再次敲 ,完成安装. (实验为了避免遗忘,可以:123456)
二、安装并配置MySQL Server
sudo dpkg -i mysql-server_8.0.19-1ubuntu16.04_amd64.deb
接下来,配置MySQL server。MySQL Server 配置文件默认为 /etc/mysql/my.cnf,打开这个配置文件:
sudo vim /etc/mysql/my.cnf
在其尾部追加以下内容:
[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
[mysql_cluster]
# Options for NDB Cluster processes:
ndb-connectstring=192.168.50.129 # location of management server
保存后重启MySQL Server即可,sudo systemctl restart mysql
。将MySQL设为开机启动,sudo systemctl enable mysql