CentOS6.8安装编译mysql5.6

1. 安装gcc

yum install gcc gcc-c++ ncurses-devel perl  

2. 下载源码包(一定要是source类型的,要不然从cmake就会出错)


3. 解压后进入mysql目录

4.cmake编译配置(会出错误)

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DCOMPILATION_COMMENT='JSS for mysqltest' \
-DWITH_READLINE=ON \
-DSYSCONFDIR=/data/mysqldata/3306 \
-DMYSQL_UNIX_ADDR=/data/mysqldata/3306/mysql.sock

5.出错

-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH) 
CMake Error at cmake/readline.cmake:85 (MESSAGE):
  Curses library not found.  Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on RedHat and derivates it is ncurses-devel.
Call Stack (most recent call first):
  cmake/readline.cmake:128 (FIND_CURSES)
  cmake/readline.cmake:202 (MYSQL_USE_BUNDLED_EDITLINE)
  CMakeLists.txt:421 (MYSQL_CHECK_EDITLINE)

-- Configuring incomplete, errors occurred!
See also "/soft/mysql-5.6.30/CMakeFiles/CMakeOutput.log".
See also "/soft/mysql-5.6.30/CMakeFiles/CMakeError.log".

6.解决错误需要安装缺失包

yum install ncurses-devel

7.重新删除配置文件:
rm -rf CMakeCache.txt

8. 重新执行第4步

9. make && make install(如果出错,可能是因为没有权限,要分开用sudo执行)

*****************************************

启动mysql

  1. cp support-files/mysql.server /etc/init.d/mysqld   
  2.   
  3. vim /etc/profile   
  4.   
  5.       PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH  
  6.   
  7.       export PATH  
  8.   
  9. source /etc/profile  
还要对log,pid,data等目录做chown设置
(上面的配置可以让mysql通过service mysqld start启动)

首次登录,修改root密码
mysqld --skip-grant-tables,这个命令会出现警告之类的,不用管,在新窗口中登录mysql
执行命令:update mysql.user set password=PASSWORD('root') where User='root';
刷新执行: mysql> flush privileges;

1. 使用具有所有权限的用户登录
2. 创建用户:mysql> insert into mysql.user(Host,User,Password) values("localhost","demo",password("demo"));
flush privileges;
3. 退出,用demo用户登录mysql
4. 成功登录后退出
5. 为用户授权:grant 权限 on 数据库.* to 用户名@登录主机 identified by "密码";
  (grant all privileges on *.* to demo@localhost identified by 'demo'; )
6. 刷新系统权限表:mysql>flush privileges;

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值