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

Ubuntu

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! 

171cms应用市场系统 v5.1.0源码

171cms应用市场系统是国内首款针对APP应用市场而生开源的CMS，pc站+wap站+APP原生客户端三站合一，提供完整的APP应用市场搭建、运营、推广一站式解决方案。 软件介绍： 1、免费开源，自动采集功能 2、精美模板多样化，自定义模板，自定义标签 3、原生APP客户端，PC+wap多终端进行推广 安装步骤： 1、第一步，安装包解压，通过FTP上传到配置好的网站根目录下，在浏

305

查看详情

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