ubuntu下安装mysql（二进制）到自定义目录_MySQL

Ubuntu

bitsCN.com

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 

 

bitsCN.com