debian7.7环境下安装percona server数据库
来源:互联网 发布:罗志祥的舞蹈水平知乎 编辑:程序博客网 时间:2024/06/05 17:32
1.先安装mysql 这里安装的是percona,mysql的分支
Percona Server 的编译、配置和使用与 MySQL 完全一致,你完全可以把它当成是 MySQL 来使用。
下载 Percona Server 源码包
# wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.32-78.0/source/tarball/percona-server-5.6.32-78.0.tar.gz
或 MySQL 源码包
# wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz
安装依赖¶
# apt-get install gcc
apt-get install g++ make cmake bison perl
apt-get install libncurses5-dev libaio-dev
创建 MySQL 用户
# groupadd mysql
查看当前用户组是否存在
# cat /etc/group |grep mysql
查看当前用户是否存在
# cat /etc/passwd |grep mysql
# useradd -g mysql -s /sbin/nologin -M mysql
创建日志目录和 SOCK 目录并更改权限
# mkdir /var/log/mysql
# chown -R mysql:mysql /var/log/mysql/
mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql
mkdir /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql
mkdir /var/run/mysql
chown -R mysql:mysql /var/run/mysql
编译安装
# tar zxf percona-server-5.6.17-66.0.tar.gz -C /usr/local/src/
# cd /usr/local/src/percona-server-5.6.17-66.0/
# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/usr/local/mysql/etc \
-DMYSQL_DATADIR=/var/lib/mysql \
-DMYSQL_UNIX_ADDR=/var/run/mysql/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EDITLINE=bundled \
-DCMAKE_BUILD_TYPE=RelWithDebInfo \
-DBUILD_CONFIG=mysql_release \
-DFEATURE_SET=community \
-DWITH_EMBEDDED_SERVER=OFF
##以下这两句不是编译的选项,移除##
-DMYSQL_USER=mysql \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
# make -j8
make过程中会报错,报错如下:
/usr/bin/ld: cannot find -lz
collect2: error: ld returned 1 exit status
make[2]: *** [storage/tokudb/PerconaFT/ft/libft.so] Error 1
make[1]: *** [storage/tokudb/PerconaFT/ft/CMakeFiles/ft.dir/all] Error 2
make: *** [all] Error 2
解决方法:
编译的时候出现"/usr/bin/ld: cannot find -lz"错误,需要安装zlib-dev这个包,在线安装命令为:apt-get install zlib1g-dev。
# make install
初始化数据库
切换到 MySQL 安装目录:
# cd /usr/local/mysql/
以 mysql 用户的身份创建 /var/lib/mysql,后续将作为数据库的datadir目录,并写入初始化数据库信息:
# ./scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql
拷贝服务文件到 /etc/init.d/mysql,mysql 这个文件名也是服务名,可以任意更改, 为了统一我们使用 mysql 作为文件名:
# cp support-files/mysql.server /etc/init.d/mysql
如果/usr/local/mysql/文件夹下没有etc目录,就创建一个
# mkdir etc
# vim /usr/local/mysql/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/run/mysql/mysqld.sock
skip-name-resolve
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysql/mysqld-err.log
#pid-file=/var/lib/mysql/aboutc.pid
启动 MySQL 服务
# service mysql start
Starting MySQL (Percona Server).. SUCCESS!
更改 root 用户密码
# ./bin/mysqladmin -u root password 'new-password'
删除登录用户密码为空的数据
# ./bin/mysql -uroot -p
Enter password:
mysql> delete from mysql.user where password = '';
Query OK, 5 rows affected (0.51 sec)
mysql> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *9F6F2XXXX40B6DF5D2A5F762E1CF33782CA1ABXX |
+------+-----------+-------------------------------------------+
1 row in set (0.01 sec)
至此percona server 5.6.32安装完毕
Percona Server 的编译、配置和使用与 MySQL 完全一致,你完全可以把它当成是 MySQL 来使用。
下载 Percona Server 源码包
# wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.32-78.0/source/tarball/percona-server-5.6.32-78.0.tar.gz
或 MySQL 源码包
# wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz
安装依赖¶
# apt-get install gcc
apt-get install g++ make cmake bison perl
apt-get install libncurses5-dev libaio-dev
创建 MySQL 用户
# groupadd mysql
查看当前用户组是否存在
# cat /etc/group |grep mysql
查看当前用户是否存在
# cat /etc/passwd |grep mysql
# useradd -g mysql -s /sbin/nologin -M mysql
创建日志目录和 SOCK 目录并更改权限
# mkdir /var/log/mysql
# chown -R mysql:mysql /var/log/mysql/
mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql
mkdir /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql
mkdir /var/run/mysql
chown -R mysql:mysql /var/run/mysql
编译安装
# tar zxf percona-server-5.6.17-66.0.tar.gz -C /usr/local/src/
# cd /usr/local/src/percona-server-5.6.17-66.0/
# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/usr/local/mysql/etc \
-DMYSQL_DATADIR=/var/lib/mysql \
-DMYSQL_UNIX_ADDR=/var/run/mysql/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EDITLINE=bundled \
-DCMAKE_BUILD_TYPE=RelWithDebInfo \
-DBUILD_CONFIG=mysql_release \
-DFEATURE_SET=community \
-DWITH_EMBEDDED_SERVER=OFF
##以下这两句不是编译的选项,移除##
-DMYSQL_USER=mysql \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
# make -j8
make过程中会报错,报错如下:
/usr/bin/ld: cannot find -lz
collect2: error: ld returned 1 exit status
make[2]: *** [storage/tokudb/PerconaFT/ft/libft.so] Error 1
make[1]: *** [storage/tokudb/PerconaFT/ft/CMakeFiles/ft.dir/all] Error 2
make: *** [all] Error 2
解决方法:
编译的时候出现"/usr/bin/ld: cannot find -lz"错误,需要安装zlib-dev这个包,在线安装命令为:apt-get install zlib1g-dev。
# make install
初始化数据库
切换到 MySQL 安装目录:
# cd /usr/local/mysql/
以 mysql 用户的身份创建 /var/lib/mysql,后续将作为数据库的datadir目录,并写入初始化数据库信息:
# ./scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql
拷贝服务文件到 /etc/init.d/mysql,mysql 这个文件名也是服务名,可以任意更改, 为了统一我们使用 mysql 作为文件名:
# cp support-files/mysql.server /etc/init.d/mysql
如果/usr/local/mysql/文件夹下没有etc目录,就创建一个
# mkdir etc
# vim /usr/local/mysql/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/run/mysql/mysqld.sock
skip-name-resolve
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysql/mysqld-err.log
#pid-file=/var/lib/mysql/aboutc.pid
启动 MySQL 服务
# service mysql start
Starting MySQL (Percona Server).. SUCCESS!
更改 root 用户密码
# ./bin/mysqladmin -u root password 'new-password'
删除登录用户密码为空的数据
# ./bin/mysql -uroot -p
Enter password:
mysql> delete from mysql.user where password = '';
Query OK, 5 rows affected (0.51 sec)
mysql> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *9F6F2XXXX40B6DF5D2A5F762E1CF33782CA1ABXX |
+------+-----------+-------------------------------------------+
1 row in set (0.01 sec)
至此percona server 5.6.32安装完毕
0 0
- debian7.7环境下安装percona server数据库
- Linux下安装Percona Server
- debian7.7环境下 源码安装redis以及phpredis扩展
- Percona-Server数据库的二进制安装
- Percona-Server数据库的安装方法
- CentOS 7 上安装 Percona Server
- CentOS 7 上安装 Percona Server
- Percona Server 安装
- percona server安装
- Debian7.3下创建Android开发环境
- Ubuntu下安装Percona xtrabackup
- Centos下安装Percona-toolkit
- Win7下硬盘安装Debian7.1
- Debian7 下nfs的安装和配置
- Win7下硬盘安装Debian7.5
- percona server的安装启动配置
- Linux安装mysql衍生版本Percona-Server
- CentOS5.6(64bit)下编译安装Nginx1.2.0、Percona-Server-5.1.61、PHP5.3.10
- 使用python pillow 图片转字符串
- java基础第12章上机--实现菜单的级联效果
- 操作系统:使用AT&T实现引导扇区
- L2-003. 月饼-PAT团体程序设计天梯赛GPLT
- React/React Native 的ES5 ES6写法对照表
- debian7.7环境下安装percona server数据库
- Spring MVC 支付模块回调接口
- IOS给UIImage添加边框
- poj 3013 Big Christmas Tree(Dijktra或者spfa)
- 十进制转为二进制以及二进制转为十进制算法
- Redis配置文件参数说明
- 初学者必读:如何学习VC++和C++及其推荐书目和网站
- vc一次创建多层文件夹
- 上机1 计算平均分和总成绩