Ubuntu 离线安装 MySQL 5.7.x
1. 下载安装包
地址:
https://downloads.mysql.com/archives/community/
版本选择 (mysql-server_5.7.27-1ubuntu19.04_amd64.deb-bundle.tar)
Product Version: 5.7.27 Operating System: Ubuntu Linux OS Version: Ubuntu Linux 19.04 (x86, 64-bit)
2. 解压缩安装包
tar -xzf mysql-server_5.7.27-1ubuntu19.04_amd64.deb-bundle.tar
3. 安装依赖包
sudo apt-get update sudo apt-get upgrade sudo apt-get install libaio1 sudo apt-get install libtinfo5
4. 开始安装
sudo dpkg -i mysql-common_5.7.27-1ubuntu19.04_amd64.deb
## #此步需要输入数据的root密码 sudo dpkg-preconfigure mysql-community-server_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i libmysqlclient20_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i libmysqlclient-dev_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i libmysqld-dev_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i mysql-community-client_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i mysql-client_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i mysql-common_5.7.27-1ubuntu19.04_amd64.deb
5. 安装其他依赖包
sudo apt-get -f install sudo apt-get -f install libmecab2
6. 安装mysql-server
sudo dpkg -i mysql-community-server_5.7.27-1ubuntu19.04_amd64.deb sudo dpkg -i mysql-server_5.7.27-1ubuntu19.04_amd64.deb
7. 检测安装
mysql -u root -p
8. 初始化配置
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) : Y (我的选项,选择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,修改权限立即生效)
9. 检查MySQL服务状态
systemctl status mysql.service
10. 配置远程连接
10.1 注释掉 bind-address
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf # bind-address = 127.0.0.1
10.2
登录 mysql mysql -uroot -p
>> use mysql
...
>> update user set host = '%' where user='root'
...
11. 修改配置
执行: vim /etc/mysql/my.cnf 增加以下配置 [mysqld] max_allowed_packet=100M wait_timeout=2073600 lower_case_table_names=1
数据库连接配置
jdbc:mysql://10.10.1.150:3306/xxx?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=GMT
tar文件解压方法
解压tar文件的方法取决于文件的扩展名。12
- 对于
.tar
文件,使用命令tar -xvf 文件名.tar
进行解压。 - 对于
.tar.gz
或.tgz
文件,使用命令tar -zxvf 文件名.tar.gz
进行解压。这里的-z
选项表示使用gzip进行解压缩。 - 对于
.tar.bz2
文件,使用命令tar -xjvf 文件名.tar.bz2
进行解压。这里的-j
选项表示使用bzip2进行解压缩。 - 对于
.rar
文件,使用命令unrar e 文件名.rar
进行解压。 - 对于
.zip
文件,使用命令unzip 文件名.zip
进行解压。
这些命令中的-x
表示执行解压操作,-v
表示显示详细的解压缩过程,-f
用于指定要解压缩的文件名。执行这些命令后,相应的压缩文件将被解压到当前目录下,或者如果指定了目标目录,将被解压到该目录中。