Linux 安装Mysql
来源:互联网 发布:淘宝米兰密码是正品吗 编辑:程序博客网 时间:2024/06/18 08:26
【练习】RPM包安装mysql
环境描述:
操作系统:Red Hat Enterprise Linux Server release 6.5
Mysql安装包:MySQL-5.6.35-1.linux_glibc2.5.x86_64.rpm-bundle.tar
1.首先检查是否预安装了mysql:
[root@mysql ~]# rpm -qa | grep -i mysqlperl-DBD-MySQL-4.013-3.el6.x86_64mysql-connector-odbc-5.1.5r1144-7.el6.x86_64mysql-devel-5.1.71-1.el6.x86_64MySQL-python-1.2.3-0.3.c1.1.el6.x86_64mysql-5.1.71-1.el6.x86_64mysql-server-5.1.71-1.el6.x86_64mysql-libs-5.1.71-1.el6.x86_64
2.移除预安装的MYSQL:
rpm -e mysql-server-5.1.71-1.el6.x86_64 --nodepsrpm -e mysql-devel-5.1.71-1.el6.x86_64 --nodepsrpm -e mysql-5.1.71-1.el6.x86_64 --nodepsrpm -e mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 --nodepsrpm -e MySQL-python-1.2.3-0.3.c1.1.el6.x86_64 --nodepsrpm -e perl-DBD-MySQL-4.013-3.el6.x86_64 --nodepsrpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodepsrm -rf /var/lib/mysql*rm -rf /usr/share/mysql*userdel mysql
3.创建安装包上传目录,将安装包上传到该目录下(上传过程省略):
[root@mysql ~]# mkdir -p /usr/local/mysql
4.创建用户和组:
[root@mysql ~]# groupadd -g 1000 mysql[root@mysql ~]# useradd mysql -g mysql -p mysql
5.解压缩安装包:
[root@mysql ~]# tar -xvf MySQL-5.6.35-1.linux_glibc2.5.x86_64.rpm-bundle.tar MySQL-devel-5.6.35-1.linux_glibc2.5.x86_64.rpmMySQL-test-5.6.35-1.linux_glibc2.5.x86_64.rpmMySQL-shared-5.6.35-1.linux_glibc2.5.x86_64.rpmMySQL-shared-compat-5.6.35-1.linux_glibc2.5.x86_64.rpmMySQL-server-5.6.35-1.linux_glibc2.5.x86_64.rpmMySQL-embedded-5.6.35-1.linux_glibc2.5.x86_64.rpmMySQL-client-5.6.35-1.linux_glibc2.5.x86_64.rpm
6.安装mysql,只需要安装如下包:
##Server包:[root@mysql ~]# rpm -ivh MySQL-server-5.6.35-1.linux_glibc2.5.x86_64.rpm ##Client包:[root@mysql ~]# rpm -ivh MySQL-client-5.6.35-1.linux_glibc2.5.x86_64.rpm ##库函数包:[root@mysql ~]# rpm -ivh MySQL-devel-5.6.35-1.linux_glibc2.5.x86_64.rpm[root@mysql ~]# rpm -ivh MySQL-shared-5.6.35-1.linux_glibc2.5.x86_64.rpm
7.查看进程、端口是否启动:
[root@mysql ~]# ps -ef|grep mysqld ##查看mysqld进程是否启动[root@mysql ~]# netstat -an |grep :3306 ##查看端口是否正常,LISTEN 为正常状态 ##如果没有开启,运行:service mysql start
8.登录mysql,修改root密码:
[root@mysql ~]# mysqladmin -u root -p password
9.登录MySQL数据库:
[root@mysql ~]# mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 11Server version: 5.6.35 MySQL Community Server (GPL)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
0 0
- linux卸载mysql,安装mysql
- [MySQL]Linux 快速安装MYSQL
- 【Mysql】Linux环境安装Mysql
- Linux下安装Mysql
- Linux下安装MySQL
- 安装MySQL-LINUX
- Linux下安装MYSQL
- Linux下安装mysql
- linux mysql 安装
- LINUX下安装MySQL
- Linux下安装MySQL
- Linux下安装MySQL
- Linux 安装 Mysql
- linux安装mysql
- linux下安装mysql
- Linux下安装Mysql
- Linux下安装MySQL
- Mysql linux安装日志
- Vultr下搭建SS的教训
- 虚拟机脚本编辑
- R read.table读取数据中的困惑
- LintCode-把排序数组转换为高度最小的二叉搜索树
- java面试⑦高级部分
- Linux 安装Mysql
- url传中文乱码问题解决办法
- Android蓝牙使用(一)
- leetocode 541. Reverse String II
- Ubuntu16 Ibus pinyin
- 系统延迟及定时机制
- Jspxcms
- 一个ItemBag类继承自Vector
- linux远程日志rsyslog服务端和客户端安装