centos安装JDK1.8、Mysql5.7
2024-02-23 本文已影响0人
hongzhenw
安装JDK1.8
- 解压：jdk-8u191-linux-x64.tar.gz
tar -xvf jdk-8u191-linux-x64.tar.gz
- 编辑：vi /etc/profile，添加以下内容
export JAVA_HOME=/usr/local/soft/jdk1.8.0_191
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH}
- 刷新：/etc/profile
source /etc/profile
- 检测版本：java -version
java version "1.8.0_191"
Java(TM) SE Runtime Environment (build 1.8.0_191-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode)
安装Mysql5.7
- 解压：mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
tar -xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
- 修改名称为：mysql5.7
mv mysql-5.7.22-linux-glibc2.12-x86_64 mysql5.7
- 在mysql5.7下，创建data文件夹
mkdir data
- 创建一个名为mysql的用户组
groupadd mysql
- 在用户组下创建用户
useradd -g mysql -d /usr/local/soft/mysql5.7/ mysql
- 初始化数据
./bin/mysqld --user=mysql --basedir=/usr/local/soft/mysql5.7 --datadir=/usr/local/soft/mysql5.7/data --initialize
执行结果如图：
2024-02-24T05:31:57.671559Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-02-24T05:31:58.235941Z 0 [Warning] InnoDB: New log files created, LSN=45790
2024-02-24T05:31:58.516474Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2024-02-24T05:31:58.608913Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 07858368-d2d6-11ee-9407-001c42732b9c.
2024-02-24T05:31:58.611113Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-02-24T05:31:58.613261Z 1 [Note] A temporary password is generated for root@localhost: j;;28nM(ft%=
- 修改/etc/my.cnf文件，修改后内容如下
[mysqld]
basedir=/usr/local/soft/mysql5.7
datadir=/usr/local/soft/mysql5.7/data
character_set_server=utf8
init_connect='SET NAMES utf8'
[client]
default-character-set=utf8
- 修改/usr/local/soft/mysql5.7/support-files/mysql.server文件，添加basedir以及datadir,如所示
basedir=/usr/local/soft/mysql5.7
datadir=/usr/local/soft/mysql5.7/data
- 启动mysql服务
./support-files/mysql.server start
成功如下
Starting MySQL.Logging to '/usr/local/soft/mysql5.7/data/CentOS6.5.err'.
[确定]
- 一些配置
# 创建软链接
ln -s /usr/local/soft/mysql5.7/bin/mysql /usr/bin/mysql
#拷贝启动文件
cp /usr/local/soft/mysql5.7/support-files/mysql.server /etc/init.d/mysqld
#增加执行权限
chmod 755 /etc/init.d/mysqld
#增加自启动mysqld
chkconfig --add mysqld
#设置开机启动
chkconfig mysqld on
- Mysql服务的停止/启动/重启
[root@CentOS6 mysql5.7]# service mysqld stop
Shutting down MySQL.. [ OK ]
[root@CentOS6 mysql5.7]# service mysqld start
Starting MySQL. [ OK ]
[root@CentOS6 mysql5.7]# service mysqld restart
Shutting down MySQL.. [ OK ]
Starting MySQL. [ OK ]
- 通过命令行登录mysql数据库服务器
mysql -uroot -p
成功如下
Enter password: j;;28nM(ft%=（从第6步拷贝）
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
- 通过命令行修改密码
mysql> set password=password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
- 更改编码如下
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show variables like 'character%';
+--------------------------+------------------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/soft/mysql5.7/share/charsets/ |
+--------------------------+------------------------------------------+
8 rows in set (0.00 sec)
mysql> set character_set_database=utf8;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show variables like 'character%';
+--------------------------+------------------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/soft/mysql5.7/share/charsets/ |
+--------------------------+------------------------------------------+
8 rows in set (0.01 sec)
- 远程授权
mysql> grant all on *.* to 'root'@'%' identified by '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)
#或
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)
- 防火墙开放3306
#编辑
vi /etc/sysconfig/iptables
#增加以下内容
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
#重启防火墙
service iptables restart
- 安装完成，可使用数据库连接工具，连接使用！
