利用 mysql-5.5.27.tar.gz 来从源码安装 mysql-5.5.27
来源:互联网 发布:python range 编辑:程序博客网 时间:2024/06/06 05:41
注意:颜色标注的地方
#! /bin/sh
mkdir -p /var/lib/mysql
mkdir -p /var/lib/data/mysql # 这里创建了mysql的数据目录
# rm CMakeCache.txt
cmake . -DCMAKE_INSTALL_PREFIX=/var/lib/mysql -DMYSQL_DATADIR=/var/lib/data/mysql -DINSTALL_SBINDIR=sbin -DSYSCONFDIR=/etc -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_MANDIR=share/man -DINSTALL_SHAREDIR=share -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/var/lib/data/mysql/mysql.sock -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0
make && make install
cd - && cd mysql
cp support-files/my-medium.cnf /etc
cd /etc && mv my-medium.cnf my.cnf && cd /var/lib/mysql-5.5.27
# mysql_install_db 文件无可执行权限
chmod a+rwx ./scripts/mysql_install_db
./scripts/mysql_install_db --user=mysql --basedir=/var/lib/mysql--datadir=/var/lib/data/mysql --defaults-file=/etc/my.cnf # 通过参数 --datadir=/var/lib/data/mysql 来初始化数据库是不能够成功启动数据库的
# 错误:/var/lib/mysql/sbin/mysqld: File './mysql-bin.index' not found 目录权限不够chown -R mysql:mysql /var/lib/mysql
/var/lib/mysql/bin/mysqld_safe & # 不能成功启动mysql服务
# 错误日志:
121212 19:20:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data
/var/lib/mysql/sbin/mysqld: Table 'mysql.plugin' doesn't exist
121212 19:20:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121212 19:20:26 InnoDB: The InnoDB memory heap is disabled
121212 19:20:26 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
121212 19:20:26 InnoDB: Compressed tables use zlib 1.2.3
121212 19:20:26 InnoDB: Initializing buffer pool, size = 128.0M
121212 19:20:26 InnoDB: Completed initialization of buffer pool
121212 19:20:26 InnoDB: highest supported file format is Barracuda.
121212 19:20:26 InnoDB: Waiting for the background threads to start
121212 19:20:27 InnoDB: 1.1.8 started; log sequence number 1595675
121212 19:20:27 [Note] Recovering after a crash using mysql-bin
121212 19:20:27 [Note] Starting crash recovery...
121212 19:20:27 [Note] Crash recovery finished.
121212 19:20:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121212 19:20:27 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121212 19:20:27 [Note] Server socket created on IP: '0.0.0.0'.
121212 19:20:27 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
121212 19:20:27 mysqld_safe mysqld from pid file /var/lib/mysql/data/localhost.localdomain.pid ended
寻找原因是因为数据目录引起的,通过下面命令重新来初始化数据库:
./scripts/mysql_install_db --user=mysql --basedir=/var/lib/mysql--datadir=/var/lib/mysql/data --defaults-file=/etc/my.cnf
/var/lib/mysql/bin/mysqld_safe &# 可成功启动
[root@localhost ~]# ps -A | grep mysql
3402 pts/1 00:00:00 mysqld_safe
3797 pts/1 00:00:00 mysqld
[root@localhost ~]# /var/lib/mysql/bin/mysql -u root -p
Enter password:
注意:在/var/lib/mysql下面本身就存在文件夹data:/var/lib/mysql/data ,这里就有点搞不懂了。但是数据库可以重新启动。请教大侠有什么见解。
- 利用 mysql-5.5.27.tar.gz 来从源码安装 mysql-5.5.27
- mysql源码编译安装 mysql-5.5.30.tar.gz
- 安装mysql-5.5.8.tar.gz
- mysql-5.6.30.tar.gz源码安装
- 安装mysql tar.gz
- 从 mysql-cluster-gpl-7.2.8.tar.gz 来安装 mysql5.5.27 (正在更新)
- Ubuntu14.04.*源码安装MySQL数据库mysql-5.6.*.tar.gz
- mysql-5.5.36.tar.gz 在centOS7 安装过程
- mac 安装 mysql.tar.gz
- linux mysql安装(tar.gz)
- Linux下MySQL源码编译安装(eg:mysql-5.6.27.tar.gz )
- Linux下MySQL源码编译安装(eg:mysql-5.6.27.tar.gz )
- mysql-5.0.22.tar.gz 源码包的安装方法
- mysql-5.0.22.tar.gz 源码包的安装方法
- linux CenterOS 下 mysql-5.6.26.tar.gz源码安装
- Centos 6.4源码安装mysql-5.6.28.tar.gz
- linux下mysql-5.5.27.tar.gz源程序包安装实例
- 在Ubuntu上以tarball方式安装MySQL(mysql-5.5.14-linux2.6-x86_64.tar.gz)
- android 图片资源文件对应的屏幕分辨率
- CentOS 系统日志
- 应届生笔试-冒泡排序
- 什么是Wireless Tether(无线局域网共享)
- android sqlite 的使用
- 利用 mysql-5.5.27.tar.gz 来从源码安装 mysql-5.5.27
- 队列随笔
- TCPDUMP用法
- Oracle创建表空间、创建用户以及授权、查看权限
- linux命令行中横线(-)前缀的特殊文件
- cygwin中启动timetunnel的broker的时候一直报内存不足
- 网关、IP及子网掩码的概念
- 【UI】TextView中多行字的行间距
- linux查看所有用户与用户组