./scripts/mysql_install_db                   //建库

3 修改文件夹权限

##下面修改相关文件夹权限，否则MySQL服务不能启动，或者说你对数据库没有写权限

chown –R root /usr/local/mysql

chgrp –R mysql /usr/local/mysql

chown –R root /usr/local/mysql/bin

chgrp –R mysql /usr/local/mysql/bin

chown –R root /usr/local/mysql/var

chgrp –R mysql /usr/local/mysql/var

chmod 770 /usr/local/mysql/var

chown –R root /usr/local/mysql/var/mysql

chgrp –R mysql /usr/local/mysql/var/mysql

chmod 770 /usr/local/mysql/var/mysql

chown –R root /usr/local/mysql/var/mysql/*

chgrp –R mysql /usr/local/mysql/var/mysql/*

chmod 770 /usr/local/mysql/var/mysql/*

chmod 770 /usr/local/mysql/lib/mysql/libmysqlclient.a

4 重新加载动态库

##因为我们采用自定义编译安装的方式，所以跟系统原先定义的库位置不一样，现在我们重新指定它并重新加载

vi /etc/ld.so.conf

#添加下面一行

/usr/local/mysql/lib

shell>ldconfig                                   //重新加载动态库

5 测试MySQL

cd /usr/local/mysql

./bin/safe_mysqld –-user=mysql &                 //启动MySQL服务

mysqladmin –u root –p password ''''your_password''''   //更改用户密码

mysql –p                                      //开始使用

6 创建启动脚本

##创建MySQL服务，使之在系统启动时自动启动

cd /etc/rc.d/init.d

touch mysqld

vi mysqld

##文件内容如下：

#!/bin/bash

#Start MySQL service

cd /usr/local/mysql

./bin/safe_mysqld - -user=mysql&

##改变该脚本的权限，否则系统启动时会说由于没有执行权限而启动失败

上一页  [1] [2] [3] [4]  下一页