centos7安装mysql-5.6.43二进制包

最新推荐文章于 2024-10-25 14:20:58 发布
最新推荐文章于 2024-10-25 14:20:58 发布
阅读量124 收藏
点赞数
文章标签： 数据库 运维 操作系统
原文链接：http://www.cnblogs.com/djlsunshine/p/10907559.html
版权

卸载老版本的MySQL。查找并删除mysql有关的文件

# find / -name mysql

# rm -rf /usr/lib64/mysql /usr/share/mysql

[root@localhost ~]# find / -name mysql
/usr/lib64/mysql
/usr/share/mysql
[root@localhost ~]# rm -rf /usr/lib64/mysql /usr/share/mysql
[root@localhost ~]#

上传mysql安装包并解压

# tar -zxf mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz

[root@localhost ~]# ls
anaconda-ks.cfg  mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# tar -zxf mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz 
[root@localhost ~]# ls
anaconda-ks.cfg                      mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz
mysql-5.6.43-linux-glibc2.12-x86_64

选择安装位置并重命名

mv mysql-5.6.43-linux-glibc2.12-x86_64 /usr/mysql-5.6.43

[root@localhost ~]# mv mysql-5.6.43-linux-glibc2.12-x86_64 /usr/mysql-5.6.43
[root@localhost ~]# 
[root@localhost ~]# ls
anaconda-ks.cfg  mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# 
[root@localhost ~]# ls /usr/
bin  etc  games  include  lib  lib64  libexec  local  mysql-5.6.43  sbin  share  src  tmp

添加用户组和用户

# groupadd mysql

# useradd mysql -g mysql

# groups mysql

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd mysql -g mysql
[root@localhost ~]# groups mysql
mysql : mysql

更改MySQL目录权限，进入mysql目录

[root@localhost ~]# cd /usr/mysql-5.6.43/
[root@localhost mysql-5.6.43]# 
[root@localhost mysql-5.6.43]# ls
bin  COPYING  data  docs  include  lib  man  mysql-test  README  scripts  share  sql-bench  support-files
[root@localhost mysql-5.6.43]# 
[root@localhost mysql-5.6.43]# pwd
/usr/mysql-5.6.43
[root@localhost mysql-5.6.43]# chown -R mysql:mysql /usr/mysql-5.6.43
[root@localhost mysql-5.6.43]# ll
total 52
drwxr-xr-x.  2 mysql mysql  4096 May 22 19:20 bin
-rw-r--r--.  1 mysql mysql 17987 Dec 21 15:46 COPYING
drwxr-xr-x.  3 mysql mysql    17 May 22 19:20 data
drwxr-xr-x.  2 mysql mysql    52 May 22 19:20 docs
drwxr-xr-x.  3 mysql mysql  4096 May 22 19:20 include
drwxr-xr-x.  3 mysql mysql  4096 May 22 19:20 lib
drwxr-xr-x.  4 mysql mysql    28 May 22 19:20 man
drwxr-xr-x. 10 mysql mysql  4096 May 22 19:20 mysql-test
-rw-r--r--.  1 mysql mysql  2496 Dec 21 15:46 README
drwxr-xr-x.  2 mysql mysql    29 May 22 19:20 scripts
drwxr-xr-x. 28 mysql mysql  4096 May 22 19:20 share
drwxr-xr-x.  4 mysql mysql  4096 May 22 19:20 sql-bench
drwxr-xr-x.  2 mysql mysql  4096 May 22 19:20 support-files

安装相关的包

# yum install perl perl-devel autoconf -y

Installed:
  perl-devel.x86_64 4:5.16.3-294.el7_6

Dependency Installed:
  gdbm-devel.x86_64 0:1.10-8.el7                     libdb-devel.x86_64 0:5.3.21-24.el7              perl-ExtUtils-Install.noarch 0:1.58-294.el7_6       perl-ExtUtils-MakeMaker.noarch 0:6.68-3.el7
  perl-ExtUtils-Manifest.noarch 0:1.61-244.el7       perl-ExtUtils-ParseXS.noarch 1:3.18-3.el7       pyparsing.noarch 0:1.5.6-9.el7                      systemtap-sdt-devel.x86_64 0:3.3-3.el7

Updated:
  perl.x86_64 4:5.16.3-294.el7_6

Dependency Updated:
  libdb.x86_64 0:5.3.21-24.el7                                   libdb-utils.x86_64 0:5.3.21-24.el7                                   perl-libs.x86_64 4:5.16.3-294.el7_6

Complete!

数据库初始化

# ./mysql_install_db --basedir=/usr/mysql-5.6.43/ --datadir=/usr/mysql-5.6.43/data/ --user=mysql

[root@localhost ~]# cd /usr/mysql-5.6.43/
[root@localhost mysql-5.6.43]#
[root@localhost mysql-5.6.43]#
[root@localhost mysql-5.6.43]# ls
bin  COPYING  data  docs  include  lib  man  mysql-test  README  scripts  share  sql-bench  support-files
[root@localhost mysql-5.6.43]#
[root@localhost mysql-5.6.43]#
[root@localhost mysql-5.6.43]# cd scripts/
[root@localhost scripts]#
[root@localhost scripts]#
[root@localhost scripts]# ls
mysql_install_db
[root@localhost scripts]#
[root@localhost scripts]#
[root@localhost scripts]# ll
total 36
-rwxr-xr-x. 1 mysql mysql 34558 Dec 21 16:10 mysql_install_db
[root@localhost scripts]#
[root@localhost scripts]#
[root@localhost scripts]# ./mysql_install_db --basedir=/usr/mysql-5.6.43/ --datadir=/usr/mysql-5.6.43/data/ --user=mysql
Installing MySQL system tables...2019-05-24 20:01:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-24 20:01:00 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2019-05-24 20:01:00 0 [Note] /usr/mysql-5.6.43//bin/mysqld (mysqld 5.6.43) starting as process 7286 ...
2019-05-24 20:01:00 7286 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-05-24 20:01:00 7286 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 20:01:00 7286 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 20:01:00 7286 [Note] InnoDB: Memory barrier is not used
2019-05-24 20:01:00 7286 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-24 20:01:00 7286 [Note] InnoDB: Using Linux native AIO
2019-05-24 20:01:00 7286 [Note] InnoDB: Using CPU crc32 instructions
2019-05-24 20:01:01 7286 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 20:01:01 7286 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 20:01:01 7286 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2019-05-24 20:01:01 7286 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2019-05-24 20:01:01 7286 [Note] InnoDB: Database physically writes the file full: wait...
2019-05-24 20:01:01 7286 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2019-05-24 20:01:02 7286 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2019-05-24 20:01:05 7286 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-05-24 20:01:05 7286 [Warning] InnoDB: New log files created, LSN=45781
2019-05-24 20:01:05 7286 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-05-24 20:01:05 7286 [Note] InnoDB: Doublewrite buffer created
2019-05-24 20:01:05 7286 [Note] InnoDB: 128 rollback segment(s) are active.
2019-05-24 20:01:05 7286 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-05-24 20:01:06 7286 [Note] InnoDB: Foreign key constraint system tables created
2019-05-24 20:01:06 7286 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-05-24 20:01:06 7286 [Note] InnoDB: Tablespace and datafile system tables created.
2019-05-24 20:01:06 7286 [Note] InnoDB: Waiting for purge to start
2019-05-24 20:01:06 7286 [Note] InnoDB: 5.6.43 started; log sequence number 0
2019-05-24 20:01:06 7286 [Note] Binlog end
2019-05-24 20:01:06 7286 [Note] InnoDB: FTS optimize thread exiting.
2019-05-24 20:01:06 7286 [Note] InnoDB: Starting shutdown...
2019-05-24 20:01:08 7286 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK

Filling help tables...2019-05-24 20:01:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-24 20:01:08 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2019-05-24 20:01:08 0 [Note] /usr/mysql-5.6.43//bin/mysqld (mysqld 5.6.43) starting as process 7327 ...
2019-05-24 20:01:08 7327 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-05-24 20:01:08 7327 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 20:01:08 7327 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 20:01:08 7327 [Note] InnoDB: Memory barrier is not used
2019-05-24 20:01:08 7327 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-24 20:01:08 7327 [Note] InnoDB: Using Linux native AIO
2019-05-24 20:01:08 7327 [Note] InnoDB: Using CPU crc32 instructions
2019-05-24 20:01:08 7327 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 20:01:08 7327 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 20:01:08 7327 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-24 20:01:08 7327 [Note] InnoDB: 128 rollback segment(s) are active.
2019-05-24 20:01:08 7327 [Note] InnoDB: Waiting for purge to start
2019-05-24 20:01:08 7327 [Note] InnoDB: 5.6.43 started; log sequence number 1625977
2019-05-24 20:01:08 7327 [Note] Binlog end
2019-05-24 20:01:08 7327 [Note] InnoDB: FTS optimize thread exiting.
2019-05-24 20:01:08 7327 [Note] InnoDB: Starting shutdown...
2019-05-24 20:01:10 7327 [Note] InnoDB: Shutdown completed; log sequence number 1625987
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

  /usr/mysql-5.6.43//bin/mysqladmin -u root password 'new-password'
  /usr/mysql-5.6.43//bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:

  /usr/mysql-5.6.43//bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

  cd . ; /usr/mysql-5.6.43//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/mysql-5.6.43//my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

拷贝 my-default.cnf到/etc/my.cnf

# cd ../support-files/

# cp my-default.cnf /etc/my.cnf

[root@localhost scripts]# cd ../support-files/
[root@localhost support-files]#
[root@localhost support-files]# ls
binary-configure  magic  my-default.cnf  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@localhost support-files]#
[root@localhost support-files]# cp my-default.cnf /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? yes
[root@localhost support-files]#

向/etc/init.d中添加mysql的启动服务

init.d目录包含许多系统各种服务的启动和停止脚本。

[root@localhost support-files]# pwd
/usr/mysql-5.6.43/support-files
[root@localhost support-files]# ls
binary-configure  magic  my-default.cnf  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@localhost support-files]# cp mysql.server /etc/init.d/mysqld
[root@localhost support-files]#

修改/etc/init.d/mysqld权限

# cd /etc/init.d/

# chmod 755 mysqld

[root@localhost support-files]# cd /etc/init.d/
[root@localhost init.d]#
[root@localhost init.d]# ls
functions  mysqld  netconsole  network  README
[root@localhost init.d]#
[root@localhost init.d]# chmod -R 755 mysqld
[root@localhost init.d]#
[root@localhost init.d]# ll
total 44
-rw-r--r--. 1 root root 13948 Sep 16  2015 functions
-rwxr-xr-x. 1 root root 10565 May 24 20:14 mysqld
-rwxr-xr-x. 1 root root  2989 Sep 16  2015 netconsole
-rwxr-xr-x. 1 root root  6630 Sep 16  2015 network
-rw-r--r--. 1 root root  1160 Nov 20  2015 README

修改/etc/init.d/mysqld

# vi /etc/init.d/mysqld

配置环境变量

将MySQL配置到环境变量中，这样就可以在任何地方用mysql命令了

# vi /etc/profile

在最后添加

#mysql
export MYSQL_HOME=/usr/mysql-5.6.43
#PATH
export PATH=$MYSQL_HOME/bin:$PATH

执行如下指令，使上述配置立即生效

# source /etc/profile

启动MySQL

# /etc/init.d/mysqld start

[root@localhost ~]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/usr/mysql-5.6.43/data/localhost.localdomain.err'.
................... SUCCESS!

查看err的信息

# cd /usr/mysql-5.6.43/data/

# cat localhost.localdomain.err

[root@localhost data]# cd /usr/mysql-5.6.43/data/
[root@localhost data]#
[root@localhost data]#
[root@localhost data]# ls
auto.cnf  ibdata1  ib_logfile0  ib_logfile1  localhost.localdomain.err  localhost.localdomain.pid  mysql  performance_schema  test
[root@localhost data]#
[root@localhost data]# cat localhost.localdomain.err
2019-05-24 20:37:02 7566 [Note] Plugin 'FEDERATED' is disabled.
2019-05-24 20:37:02 7566 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-05-24 20:37:02 7566 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 20:37:02 7566 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 20:37:02 7566 [Note] InnoDB: Memory barrier is not used
2019-05-24 20:37:02 7566 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-24 20:37:02 7566 [Note] InnoDB: Using Linux native AIO
2019-05-24 20:37:02 7566 [Note] InnoDB: Using CPU crc32 instructions
2019-05-24 20:37:02 7566 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 20:37:02 7566 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 20:37:03 7566 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-24 20:37:04 7566 [Note] InnoDB: 128 rollback segment(s) are active.
2019-05-24 20:37:04 7566 [Note] InnoDB: Waiting for purge to start
2019-05-24 20:37:04 7566 [Note] InnoDB: 5.6.43 started; log sequence number 1625987
2019-05-24 20:37:04 7566 [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: a27e1f65-7e20-11e9-9950-000c294cff47.
2019-05-24 20:37:04 7566 [Note] Server hostname (bind-address): '*'; port: 3306
2019-05-24 20:37:04 7566 [Note] IPv6 is available.
2019-05-24 20:37:04 7566 [Note]   - '::' resolves to '::';
2019-05-24 20:37:04 7566 [Note] Server socket created on IP: '::'.
2019-05-24 20:37:04 7566 [Note] Event Scheduler: Loaded 0 events
2019-05-24 20:37:04 7566 [Note] /usr/mysql-5.6.43/bin/mysqld: ready for connections.
Version: '5.6.43'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)

修改/etc/my.cnf

# vi /etc/my.cnf

添加federated

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
federated
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

再次重新启动

[root@localhost ~]# /etc/init.d/mysqld stop
Shutting down MySQL.. SUCCESS!
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# /etc/init.d/mysqld start
Starting MySQL... SUCCESS!
[root@localhost ~]#
[root@localhost ~]# ps -aux | grep mysqld
root       7664  0.0  0.0 113248  1612 pts/0    S    20:46   0:00 /bin/sh /usr/mysql-5.6.43/bin/mysqld_safe --datadir=/usr/mysql-5.6.43/data --pid-file=/usr/mysql-5.6.43/data/localhost.localdomain.pid
mysql      7785  9.6 24.2 1302684 453160 pts/0  Sl   20:46   0:02 /usr/mysql-5.6.43/bin/mysqld --basedir=/usr/mysql-5.6.43 --datadir=/usr/mysql-5.6.43/data --plugin-dir=/usr/mysql-5.6.43/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/usr/mysql-5.6.43/data/localhost.localdomain.pid
root       7813  0.0  0.0 112644   952 pts/0    S+   20:46   0:00 grep --color=auto mysqld

登陆MySQL数据库

# mysql -uroot -p

[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.43 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> select user,host,password from mysql.user;
+------+-----------------------+----------+
| user | host                  | password |
+------+-----------------------+----------+
| root | localhost             |          |
| root | localhost.localdomain |          |
| root | 127.0.0.1             |          |
| root | ::1                   |          |
|      | localhost             |          |
|      | localhost.localdomain |          |
+------+-----------------------+----------+
6 rows in set (0.00 sec)

授权并设置root密码

mysql> update mysql.user set password=password('000000') where user='root' and host='localhost';

mysql> grant all privileges on *.* to root@'%' identified by '000000';

mysql> update mysql.user set password=password('000000') where user='root' and host='localhost';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host                  | password                                  |
+------+-----------------------+-------------------------------------------+
| root | localhost             | *032197AE5731D4664921A6CCAC7CFCE6A0698693 |
| root | localhost.localdomain |                                           |
| root | 127.0.0.1             |                                           |
| root | ::1                   |                                           |
|      | localhost             |                                           |
|      | localhost.localdomain |                                           |
+------+-----------------------+-------------------------------------------+
6 rows in set (0.00 sec)

mysql> grant all privileges on *.* to root@'%' identified by '000000';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host                  | password                                  |
+------+-----------------------+-------------------------------------------+
| root | localhost             | *032197AE5731D4664921A6CCAC7CFCE6A0698693 |
| root | localhost.localdomain |                                           |
| root | 127.0.0.1             |                                           |
| root | ::1                   |                                           |
|      | localhost             |                                           |
|      | localhost.localdomain |                                           |
| root | %                     | *032197AE5731D4664921A6CCAC7CFCE6A0698693 |
+------+-----------------------+-------------------------------------------+
7 rows in set (0.00 sec)

关闭防火墙客户端连接

参考博客

https://www.cnblogs.com/dengshihuang/p/8029092.html

https://blog.csdn.net/qiushisoftware/article/details/86617699

Linux--Linux服务器数据库MySQL5.6.43版本安装过程说明（阿里云服务器）

https://blog.csdn.net/fumushan/article/details/87073240

阿里云CentOS安装mysql-5.6.43

https://blog.csdn.net/qiushisoftware/article/details/86617699

转载于:https://www.cnblogs.com/djlsunshine/p/10907559.html

9栋108
关注
centos7安装mysql8.0-二进制安装
The world's your oyster
07-10 1264
官方参考手册：https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html 1.下载通用二进制安装包 下载地址：https://dev.mysql.com/downloads/mysql/ 此处版本为：mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz 下载直链：https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x
mysql5.6的二进制包安装
weixin_34326429的博客
06-08 263
author： headsen chen data ：2018-06-08 16:21:43 1、 创建存放软件文件夹 # cd / #mkdir a 2、下载MySQL5.6二进制包 cd a wget http://cdn.mysql.com//archives/mysql-5.6/mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz ...
MySQL 5.6 二进制安装方式
will001449的博客
01-03 1479
MySQL 5.6 二进制安装方式 MySQL 5.6 下载 ​ ​ ​ 进入MySQL官网 ​ 选择DOWNLOAD ​ 将页面拉到最后选择**MySQL Community Edition（GPL）**中的 —> Community（GPL）Downloads ​ 选择MySQL Community Server（GPL） ​ 选择Looking f...
centos7.5下yum安装mysql-5.6.43
weixin_30344795的博客
03-20 146
cd ~/ && cat /etc/redhat-release yum list installed |grep mysql #<===查看是否安装mysql，如果已经安装，使用rpm -e --nodeps卸载 wget -c http://repo.mysql.com/mysql-community-release-el6-5.noarch...
CentOS7 安装MySQL 5.6.43
stklway的专栏
06-24 721
1. 下载MySQL 5.6.43 安装包 链接：https://pan.baidu.com/s/1MYoOeLkelOoIbjTOppSFZA 提取码：d87m 将下载文件放在/software 目录下备用 2. 检查本机是否安装mysql [root@localhost ~]# find / -name mysql 如果查到有文件就删除 [root@localhost ~...
Centos7安装Mysql5.6
11-24
CentOS7下安装Mysql5.6，具体教程（含截图，亲测可用/我自己一步步来总结下来的）CentOS7下安装Mysql5.6，具体教程（含截图，亲测可用/我自己一步步来总结下来的）CentOS7下安装Mysql5.6，具体教程（含截图，亲测可用/我自己一步步来总结下来的）
CentOS util-linux 二进制包
04-21
基于源码v2.38 版本编译。...注意：仅支持X86_64架构、CentOS and RedHat 7.x （8.x系列未实验）。 MD5: 4E1AD83580CAFED285B418F3097EB7D0 SHA1: 196DE23F1C614FD5CBAF514E111F885AA0F2265D CRC32: 368AACEB
Centos 7 安装mysql5.7.24二进制 版本的方法及解决办法
09-09
在CentOS 7系统中安装MySQL 5.7.24二进制版本涉及一系列步骤，包括下载、解压、配置、初始化、设置权限、安装启动脚本、配置环境变量、修改配置文件以及设定自动启动等。以下是详细的安装流程： 1. **下载MySQL**：...
Centos7.5安装mysql5.7.24二进制包方式部署
12-16
通过二进制包安装MySQL的好处在于灵活性，可以根据特定需求定制配置，同时能确保安装的是特定版本的MySQL。然而，这种方法需要手动管理依赖和更新，与使用包管理器安装相比，维护工作可能更复杂。
centos7安装mysql5.6.40
qq_39719302的博客
07-14 2000
首先检查是否安装过mysql 如果有卸载 [root@localhost ~]# rpm -qa |grep mysql   然后再检查是否有 mariadb 版数据库 [root@localhost ~]# rpm -qa|grep mariadb 这里可以采用两种方式卸载  1、 [root@localhost ~]#  rpm -e  mysql-community-releas...
（centos7）linux系统安装mysql-5.6.42教程,亲测，保证靠谱！
pengdenghong的博客
01-11 3790
前言  从网上找教程，我是一步一步照做的，网上那些人不知道咋想的，啥也往上贴，随便一篇，除了自己能看懂没几个人能看懂的文章就贴到网上了。        结果就是，在原先错误的基础上又一大堆错。 为了解决大多数网友同样的烦恼，本楼主良心发现自己分享成功安装经历，助大家脱坑！  安装 1、首先第一步，看一下有没有安装mysql （ V是大写的 ） [root@localhost /]# m...
CentOS7编译安装mysql-5.6.43
weixin_30553777的博客
08-03 226
Step 1:安装编译需要的软件和工具 [root@node-1 ~]# yum install gcc gcc-c++ cmake ncurses-devel bison Step 2:创建mysql用户和组，并且创建安装目录和数据库存储目录 [root@node-1 ~]# mkdir /data //数据库存储目录 [root@...
linux下安装mysql5.643_centos 7 配置mysql5.6.43主从同步
weixin_35767799的博客
01-20 83
实验环境centos7安装mysql5.6.43为例两台虚拟机配置一样主：192.168.238.140从：192.168.238.141因为centos7版本没有my.cnf文件，这里我们安装的mysql5.6.43默认文件在/usr/share/mysql/下的my-default.cnf所以我们将my-default.cnf cp到/etc/下并修改成my.cnf一、配置master主库1....
【centos mysql安装】CentOS7安装mysql5.6
赖德发的博客
03-21 1338
下面详细介绍mysql安装在linux安装步骤 一、安装mysql 1、下载安装包使用wget命令安装 wget -c -t0 https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz 2、卸载自带的 Mariadb [root@localhost ~]# rpm -qa...
centOS7 安装mysql5.6
finnson的博客
03-15 458
1.Centos7将默认数据库mysql替换成了Mariadb，需要先卸载 rpm -qa|grep mariadb // 查询出来已安装的mariadb rpm -e --nodeps 文件名 // 卸载mariadb，文件名为上述命令查询出来的文件 2.下载linux通用版安装包 地址 ： https://dev.mysql.com/downloads/mysql 解压并重命名, 此次安装...
CentOS7在线安装Mysql5.6、5.7
liangsw
06-24 1594
1、新创建的服务器，需要检测系统是否自带安装mysql # yum list installed | grep mysql 2、如果发现有系统自带mysql，请卸载 # yum -y remove mysql-libs.x86_64 3、下载mysqlyum源 # wget http://repo.mysql.com/mysql-community-release-el6-5.n...
Centos7 64位安装MySQL 5.6
Y_JY
10-08 4171
1.下载MySQL-5.6.41-1.el7.x86_64.rpm-bundle.tar 2.使用Xshell 将下载的MySQL压缩文件上传到/usr/local/src/mysql文件夹下，其中myslq是自己创建的文件夹 3.进入到创建好的mysql文件夹下使用命令：tar -xvf  MySQL-5.6.41-1.el7.x86_64.rpm-bundle.tar 解压压缩文件（以下操...
论文引用收录证明有什么用？
最新发布
2401_86157939的博客
10-25 218
论文收录引用证明通常用于申请学位、职称评定、科研项目申请等需要证明研究成果的场合，当科研工作者需要查询其学术论文在指定数据库中的被收录和被引用情况时，可以委托一级科技查新咨询单位进行检索，并出具加盖公章的检索证明，以此来证明作者在科研领域中的实力和成就。对于正在申请博硕士学位的学生来说，论文收录引用证明是评估其研究能力和学术水平的重要依据。同时，对于科研人员、教师和专业人士来说，论文收录引用证明可以帮助他们更好地了解和展示自己的学术成果，也是职称评定科研奖励申报、人才引进和聘任资格评定的重要材料。
CentOS7安装MySQL5.7.20二进制教程
在完成以上步骤后，接下来的部署过程通常包括解压MySQL二进制包，配置MySQL的系统配置文件，初始化数据库，设置root用户密码，启动MySQL服务，以及设置开机启动等。这些步骤虽然没有在提供的内容中详细列出，但它们...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值