日期:2014-05-16  浏览次数:20883 次

ubuntu下安装mysql(二进制)到自定义目录
一,安装
1, 下载 mysql二进制文件: http://dev.mysql.com/downloads/mysql/ 页面,选择linux generic ,然后选择最后一个 “Linux - Generic (glibc 2.5) (x86, 32-bit), Compressed TAR Archive” 进行下载 (32或者64根据是实际情况)
2, 切换到root 用户
3, 先创建一个group和一个属于这个组的user
shell> groupadd group1
shell> useradd -r -g group1 user1
3,  解压下载的二进制包, 到自己要放的位置, 如home/user/mysql
4, cd home/user/mysql
5, 赋予操作权限:
   chown -R user1 . 
   chgrp -R group1 .
6, scripts/mysql_install_db --user=user1  为user1安装数据库 (需要libaio包,使用新德里帮忙下一下)
7, 赋权限:
   chown -R root . 
   chgrp -R group1 . 
   chown -R root . 
   chown -R user1 data
8,启动mysql后台服务:
  bin/mysqld_safe --user=user1 &
如果没有报错,那么就是服务器的启动成功。
测试一下:
新开一个terminal,
cd home/user/mysql/bin
./mysqladmin version
正确的话 就会显示版本信息之类的 并且没有其他错误报出。

二,增加安全性
cd home/user/mysql
bin/mysql_secure_installation
然后具体步骤的一些 信息如下:
Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
... Success!


Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
... Success!

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
... Success!


三,便利设置
1,将mysql的路径加到环境变量中去:
sudo gedit /etc/profile
然后加入:
1, export MYSQL_HOME=home/user/mysql;
2,在PATH=XX后面加入 :$MYSQL_HOME/bin