mysql 5.1 ubuntu_Ubuntu10下Mysql-5.1.56安装

Ubuntu10下Mysql-5.1.56安装

创建mysql用户和组

sudo groupadd mysql

sudo useradd -r -g mysql mysql

Note:

-r option to create a user that does not have login permissions to your server host. Omit this option to permit logins for the user。

-g：指定用户所属的群组。

解压和移动到应用目录

tar –zxvf mysql-5.1.56-linux-i686-glibc23.tar.gz

sudo mv mysql-5.1.56-linux-i686-glibc23 /usr/local/mysql51

建立软连接

为mysql51目录建立软连接mysql，以便快速访问mysql51目录。

#相当于cd /usr/local/mysql51和cd /usr/local/mysql等效

sudo ln -s/usr/local/mysql51 mysql

cd /usr/local/mysql

访问权限配置

cd /usr/local/mysql

//注意后面有小数点

sudo chown -R mysql .

//将组属性改为mysql组。

sudo chgrp -R mysql .

There are four symbolic link files whose ownership is not changed(/usr/mysql/lib).

lrwxrwxrwx 1 7155 staff 24 Mar 9 06:28 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0

lrwxrwxrwx 1 7155 staff 24 Mar 9 06:28 libmysqlclient.so -> libmysqlclient.so.16.0.0

lrwxrwxrwx 1 7155 staff 26 Mar 9 06:28 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0

lrwxrwxrwx 1 7155 staff 26 Mar 9 06:28 libmysqlclient_r.so -> libmysqlclient_r.so.16.0.0

//为了更改以上几个文件的权限，需要执行下面的命令。guangbo@guangbo-laptop:/usr/local/mysql/lib$ sudo chown -h mysql:mysql libmysqlclient.