linux下安装mysql

最新推荐文章于 2024-08-13 17:09:48 发布
最新推荐文章于 2024-08-13 17:09:48 发布
阅读量95 收藏
点赞数
分类专栏： 安装 文章标签： mysql linux

mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz下载地址：

点击打开链接

系统版本：

  1. [mysql@localhost scripts]$ uname -a
  2. Linux localhost.localdomain 2.6 .32 -358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
解压： 

[root@localhost mysql]# tar -zxf mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
创建mysql用户： 

[root@localhost mysql]# useradd mysql


设置mysql用户密码： 
[root@localhost mysql]# echo '123456'|passwd --stdin mysql
设置权限： 
[root@localhost mysql]# cd /usr/local
[root@localhost local]# chown -R mysql:mysql mysql/
切换到mysql用户 

[root@localhost local]# su - mysql
[mysql@localhost ~]$ cd /usr/local/mysql/scripts/
安装： 

[mysql@localhost scripts]$ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

输出信息：

  1. [mysql@localhost scripts]$ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
  2. Installing MySQL system tables.. .2016 -04 -17 07: 41: 40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  3. 2016 -04 -17 07: 41: 40 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6 .30) starting as process 3394 ...
  4. 2016 -04 -17 07: 41: 40 3394 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
  6. 2016 -04 -17 07: 41: 40 3394 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
  8. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Using atomics to ref count buffer pool pages
  9. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: The InnoDB memory heap is disabled
  10. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  11. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Memory barrier is not used
  12. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Compressed tables use zlib 1.2 .3
  13. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Using Linux native AIO
  14. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Using CPU crc32 instructions
  15. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  16. 2016 -04 -17 07: 41: 40 3394 [Note] InnoDB: Completed initialization of buffer pool
  17. 2016 -04 -17 07: 41: 41 3394 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
  18. 2016 -04 -17 07: 41: 41 3394 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
  19. 2016 -04 -17 07: 41: 41 3394 [Note] InnoDB: Database physically writes the file full: wait...
  20. 2016 -04 -17 07: 41: 41 3394 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
  21. 2016 -04 -17 07: 41: 42 3394 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
  22. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
  23. 2016 -04 -17 07: 41: 44 3394 [Warning] InnoDB: New log files created, LSN= 45781
  24. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Doublewrite buffer not found: creating new
  25. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Doublewrite buffer created
  26. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: 128 rollback segment(s) are active.
  27. 2016 -04 -17 07: 41: 44 3394 [Warning] InnoDB: Creating foreign key constraint system tables.
  28. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Foreign key constraint system tables created
  29. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Creating tablespace and datafile system tables.
  30. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Tablespace and datafile system tables created.
  31. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: Waiting for purge to start
  32. 2016 -04 -17 07: 41: 44 3394 [Note] InnoDB: 5.6 .30 started; log sequence number 0
  33. 2016 -04 -17 07: 41: 45 3394 [Note] Binlog end
  34. 2016 -04 -17 07: 41: 45 3394 [Note] InnoDB: FTS optimize thread exiting.
  35. 2016 -04 -17 07: 41: 45 3394 [Note] InnoDB: Starting shutdown...
  36. 2016 -04 -17 07: 41: 46 3394 [Note] InnoDB: Shutdown completed; log sequence number 1625977
  37. OK
  39. Filling help tables.. .2016 -04 -17 07: 41: 46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  40. 2016 -04 -17 07: 41: 46 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6 .30) starting as process 3417 ...
  41. 2016 -04 -17 07: 41: 46 3417 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
  43. 2016 -04 -17 07: 41: 46 3417 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
  45. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Using atomics to ref count buffer pool pages
  46. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: The InnoDB memory heap is disabled
  47. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  48. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Memory barrier is not used
  49. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Compressed tables use zlib 1.2 .3
  50. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Using Linux native AIO
  51. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Using CPU crc32 instructions
  52. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  53. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Completed initialization of buffer pool
  54. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Highest supported file format is Barracuda.
  55. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: 128 rollback segment(s) are active.
  56. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Waiting for purge to start
  57. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: 5.6 .30 started; log sequence number 1625977
  58. 2016 -04 -17 07: 41: 46 3417 [Note] Binlog end
  59. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: FTS optimize thread exiting.
  60. 2016 -04 -17 07: 41: 46 3417 [Note] InnoDB: Starting shutdown...
  61. 2016 -04 -17 07: 41: 48 3417 [Note] InnoDB: Shutdown completed; log sequence number 1625987
  62. OK
  64. To start mysqld at boot time you have to copy
  65. support-files/mysql.server to the right place for your system
  67. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  68. To do so, start the server, then issue the following commands:
  70. /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
  71. /usr/local/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
  73. Alternatively you can run:
  75. /usr/local/mysql/bin/mysql_secure_installation
  77. which will also give you the option of removing the test
  78. databases and anonymous user created by default. This is
  79. strongly recommended for production servers.
  81. See the manual for more instructions.
  83. You can start the MySQL daemon with:
  85. cd . ; /usr/local/mysql/bin/mysqld_safe &
  87. You can test the MySQL daemon with mysql-test-run.pl
  89. cd mysql-test ; perl mysql-test-run.pl
  91. Please report any problems at http://bugs.mysql.com/
  93. The latest information about MySQL is available on the web at
  95. http://www.mysql.com
  97. Support MySQL by buying support/licenses at http://shop.mysql.com
  99. New default config file was created as /usr/local/mysql/my.cnf and
  100. will be used by default by the server when you start it.
  101. You may edit this file to change server settings
  103. WARNING: Default config file /etc/my.cnf exists on the system
  104. This file will be read by default by the MySQL server
  105. If you do not want to use this, either remove it, or use the
  106. --defaults-file argument to mysqld_safe when starting the server

这里可能会报错：scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory。
需要安装perl以及perl-devel.执行命令：yum –y install perl perl-devel

配置文件
cd /software/mysql-5.6.21/support-files
cp my-default.cnf /etc/my.cnf
cp mysql.server /etc/init.d/mysql
vim /etc/init.d/mysql           # 若mysql的安装目录是/usr/local/mysql,则可省略此步
修改文件中的两个变更值
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

配置环境变量
vi /etc/profile
export MYSQL_HOME=/usr/local/mysql
export PATH=$MYSQL_HOME/bin:$PATH
保存退出
source /etc/profile

启动
  1. [root@localhost mysql] # chkconfig --add mysql
  2. [root@localhost mysql] # chkconfig mysql on
  3. [root@localhost mysql] # service mysql start
  4. Starting MySQL.. SUCCESS!
设置root登录密码： 
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
登录：
  1. [mysql@localhost ~]$ mysql -uroot -p
  2. Enter password:
  3. Welcome to the MySQL monitor. Commands end with ; or \g.
  4. Your MySQL connection id is 6
  5. Server version: 5.6 .30 MySQL Community Server (GPL)
  7. Copyright (c) 2000, 2016, Oracle and/ or its affiliates. All rights reserved.
  9. Oracle is a registered trademark of Oracle Corporation and/ or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  15. mysql>
设置登录权限：
  1. mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
  2. Query OK, 0 rows affected ( 0.06 sec)
  4. mysql> FLUSH PRIVILEGES;
  5. Query OK, 0 rows affected ( 0.04 sec)
  7. mysql>
qq_41603764
关注
专栏目录
linux下在线安装mysql(完整版)
qq_34994627的博客
07-06 618
linux在线安装mysql(终结版)
linux下安装mysql服务器
09-20
Linux 下安装 MySQL 服务器 Linux 下安装 MySQL 服务器是指在 Linux 操作系统中安装和配置 MySQL 数据库服务器的过程。MySQL 是一种关系型数据库管理系统，广泛应用于 Web 应用程序中。 知识点： 1. 安装 MySQL ...
Linux中在线安装MySQL数据库
王如霜
08-23 7195
大体思路如下： 1.wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm 解释：wget是一个下载文件的工具，是World,Wide.Web和get的合称，它用在命令行下。对于Linux用户是必不可少的工具，尤其对于网络管理员，经常要下载一些软件或从远程服务器恢复备份到本地服务器。如果我们使用虚拟主机，
Linux下安装Mysql数据库
最新发布
Bingo_155的博客
08-13 1776
Linux版本Centos7Mysql版本8.4.0安装方式手动rpm包安装官方安装指导文档，其它系统和版本可参考文档下载Mysql rpm包同时支持Linux8/9 选择相应版本下载解压压缩包所有rmp包内容如下Rpm包名。
linux在线安装 mysql_linux下在线安装mysql(完整版)-Go语言中文社区
weixin_34463209的博客
01-25 154
linux下完整版安装mysql数据库卸载mariadb，否则安装mysql会出现冲突执行命令rpm -qa | grep mariadb列出所有被安装的mariadb rpm 包；执行命令rpm -e --nodepsmariadb-libs-5.5.56-2.el7.x86_64添加官方的yum源创建并编辑mysql-community.repo文件a)vi /etc/yum.repos...
Linux中在线安装Mysql
山四的博客
02-11 165
Linux中在线安装Mysql 首先我们检查是否已经安装Mysql yum list installed | grep mysql 如果已经安装Mysql则删除 yum -y remove mysql-libs.x86_64 接下来我们开始安装，此次安装的Mysql的rpm包是5.7的 wget https://repo.mysql.com//mysql57-community-release...
Linux在线安装MySQL数据库
weixin_43085589的博客
12-05 209
大体思路： 详情：https://blog.csdn.net/wrs120/article/details/77509070
linux下安装mysql简单的方法
12-16
在Linux环境下安装MySQL数据库是一项常见的任务，特别是对于系统管理员和开发者来说。本文将详细介绍一种简单易行的方法，适用于想要快速在Linux系统上部署MySQL服务的用户。以下就是这个简化的安装流程。 首先，你...
Linux下安装mysql Mysql
10-23
在Linux环境下安装MySQL是一个常见的任务，尤其对于那些需要在服务器端部署数据库的开发者或系统管理员而言。本教程将详述如何在CentOS 7.3 64位系统上安装MySQL 5.7版本，包括下载、环境配置、安装以及基本的设置...
Linux下安装mysql的教程详解
12-15
2. 检查是否有rpm包，如果没有用rpm安装过mysql，不应该有残留，如果有，需要删掉 检查语法: rpm -qa|grep -i mysql 删除语法: rpm -e <包的名字> 如果遇到依赖，无法删除，使用 rpm -e –nodeps <包的名字> ...
在Linux下安装Mysql(非root)
08-19
在Linux下安装Mysql(非root) 不用make等复杂的操作 自己安装过程的总结 绝对有效
Linux 在线安装MYSQL
g100568999的博客
12-15 1359
Linux 在线安装MYSQL
Linux在线安装mysql
cts618
11-28 118
1）检查 MySQL 是否已安装 yum list installed | grep mysql 如果有，就先全部卸载，命令如下： yum -y remove mysql-libs.x86_64 2）安装依赖 yum search libaio # 检索相关信息 yum install libaio # 安装依赖包 3)下载 MySQL Yum Repository(yum仓库) 下载地址为...
Linux在线安装MySQL
weixin_44222852的博客
07-06 153
下载MySQL安装包 1、在usr目录下，下载MySQL安装包 wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm #-i 表示下载外部链接 #-c 表示继续下载未完成的部分 2、安装MySQL文件包 yum -y installmysql57-community-release-el7-10.noarch.rpm 安装MySQL服务器 1...
Linux上在线安装mysql
qz1060306014034的博客
10-20 1149
mysql8在Linux 下的在线安装部署
在LInux下在线安装MYSQL数据库
qq_30053489的博客
07-02 179
一.下载 1.下载一个类似于种子的 wget 'https://repo.mysql.com//mysql57-community-release-el7-10.noarch.rpm' 2.下载一个类似于种子的 yum -y install mysql57-community-release-el7-10.noarch.rpm 3. 下载mysql服务器客户端 yum -y install mysql-community-server 4.开启mysql服务 ，没报错就是安装成功和...
Linux下安装mysql
09-20
在Linux下安装MySQL的步骤如下： 1. 将MySQL的安装文件解压并移动到指定目录。可以使用命令`tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz`解压文件，并将解压后的文件夹移动到`/usr/local/mysql`目录下，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值