linux 下布置数据库？

你先确认 Ecstore Ecos 用的是什么数据库呢？

如果也是 mysql 服务，那你就不用单独部署 mysql 服务了，只需要在 Ecstore Ecos 的 mysql 服务中创建一个 tp 项目的库，tp 项目可以直接复用这个 mysql 服务。

如果之前不是用的 mysql 服务，那就需要单独部署 mysql 服务了。以下有一个 mysql 5.7 的安装示例

1、在 mysql 官方下在 mysql 二进制安装包，并解压到以下目录

/usr/local/mysql

2、创建用户和组

groupadd mysql

useradd -r -g mysql mysql

3、设置目录权限

chown -R mysql:mysql /usr/local/mysql

4、初始化

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ （5.7）

5、创建目录data、tmp

mkdir /usr/local/mysql/data/

mkdir /usr/local/mysql/data/tmp/

chown -R mysql:mysql /usr/local/mysql/data/tmp/

6、创建配置文件

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

配置文件内容：

cat>/etc/my.cnf<<EOF

[client]

port=3306

socket = /usr/local/mysql/data/tmp/mysql.sock

[mysqld]

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

port = 3306

socket = /usr/local/mysql/data/tmp/mysql.sock

character_set_server=utf8

character_set_filesystem=utf8

EOF

7、运行mysql

启动日志中有 root 账户密码，注意保存下来

/usr/local/mysql/bin/mysqld_safe&

8、设置开机启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql

chkconfig --add mysql

echo "export PATH=${PATH}:/usr/local/mysql/bin" >>/etc/profile

source /etc/profile

9、登录

密码在第七步的启动日志中可以看到

/usr/local/mysql/bin/mysql -uroot -p

10、更改密码

alter user 'root'@'localhost' identified by 'P@ssw0rd'//5.7版本更新密码方法；

11、运行远程连接

GRANT ALL PRIVILEGES ON *.* TO'%'@'%' IDENTIFIED BY 'mysql.candao' WITH GRANT OPTION //所有用户都可以登录

GRANT ALL PRIVILEGES ON *.* TO'root'@'192.168.1.108' IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION

//root用户可以登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'cattle' WITH GRANT OPTION

//允许root用户在任何地方进行远程登录

FLUSH PRIVILEGES

您好，

SELECT art_id, art_pdate

FROM ecos_article

WHERE art_id>75 limit 0,1

UNION

SELECT art_id, art_pdate

FROM ecos_article

WHERE art_id<=75 ORDER BY art_id DESC limit 0,3

效果如下：

mysql>SELECT art_id, art_pdate FROM ecos_article limit 0,5

+--------+------------+

| art_id | art_pdate |

+--------+------------+

| 73 | 2005-12-01 |

| 74 | 2005-12-01 |

| 75 | 2005-12-01 |

| 76 | 2005-12-01 |

| 77 | 2005-12-01 |

+--------+------------+

mysql>SELECT art_id, art_pdate

->FROM ecos_article

->WHERE art_id>75 limit 0,1

->UNION

->SELECT art_id, art_pdate

->FROM ecos_article

->WHERE art_id<=75 ORDER BY art_id DESC limit 0,3

+--------+------------+

| art_id | art_pdate |

+--------+------------+

| 76 | 2005-12-01 |

| 75 | 2005-12-01 |

| 74 | 2005-12-01 |

+--------+------------+

---