linux php 连接sql server2000

本文涉及的产品
云数据库 RDS MySQL,集群系列 2核4GB
推荐场景:
搭建个人博客
RDS SQL Server Serverless,2-4RCU 50GB 3个月
推荐场景:
RDS MySQL Serverless 基础系列,0.5-2RCU 50GB
简介:

说明:

Linux服务器系统:CentOS 5.5

Web环境:LAMP或者LNMP

Windows服务器系统:Windows Server 2003

Windows服务器IP地址:192.168.21.134

数据库环境:SQL Server 2000数据库

数据库账号:sa

数据库密码:123456

实现目的:Linux服务器中的php程序能够连接到Windows服务器中的SQL Server 2000数据库

具体步骤:

一、在Linux服务器中安装freetds

1、安装编译工具及驱动程序

yum install make apr* autoconf automake gcc gcc-c++ wget

2、安装unixODBC驱动程序

yum -y install unixODBC unixODBC-devel

3、安装freetds

cd /usr/local/src

wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz #下载

gunzip freetds-stable.tgz #解压

tar -xvf freetds-stable.tar

cd freetds-0.91

./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --with-unixodbc=/usr --enable-msdblib #配置

make #编译

make install #安装

4、配置freetds

cp /usr/local/freetds/etc/freetds.conf /usr/local/freetds/etc/freetds.confbak #备份原有文件

vi /usr/local/freetds/etc/freetds.conf #在最后位置修改编辑以下内容

系统运维 www.osyunwei.com 温馨提醒:qihang01原创内容版权所有,转载请注明出处及原文链

[192.168.21.134]
host = 192.168.21.134 #SQL Server 2000服务器地址
port = 1433 #SQL Server 2000数据库端口
tds version = 8.0 #8.0代表数据库版本为SQL Server 2000
client charset = UTF-8 #设置字符集

5、测试freetds

/usr/local/freetds/bin/tsql -S 192.168.21.134 -U sa #测试,提示输入数据库密码,出现下面界面,配置成功

cd /usr/local/freetds/bin

./tsql -S 192.168.21.134 -p 1433 -U sa -P 123456 -D master #测试,出现下面界面,配置成功

二、配置Linux php连接SQL Server 2000数据库

1、php是用yum命令在线安装

yum install php-mssql #安装php-mssql扩展,如果提示没有此安装包,请先配置第三方yum源

wget http://www.atomicorp.com/installers/atomic #下载

sh ./atomic #安装

[root@huangwei bin]# sh ./atomic
ln: "/etc/system-release" 与"/etc/fedora-release" 为同一文件

Atomic Free Unsupported Archive installer, version 2.0.12

BY INSTALLING THIS SOFTWARE AND BY USING ANY AND ALL SOFTWARE
PROVIDED BY ATOMICORP LIMITED YOU ACKNOWLEDGE AND AGREE:

THIS SOFTWARE AND ALL SOFTWARE PROVIDED IN THIS REPOSITORY IS 
PROVIDED BY ATOMICORP LIMITED AS IS, IS UNSUPPORTED AND ANY
EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL ATOMICORP LIMITED, THE
COPYRIGHT OWNER OR ANY CONTRIBUTOR TO ANY AND ALL SOFTWARE PROVIDED
BY OR PUBLISHED IN THIS REPOSITORY BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
OF THE POSSIBILITY OF SUCH DAMAGE.

====================================================================
THIS SOFTWARE IS UNSUPPORTED.  IF YOU REQUIRE SUPPORTED SOFWARE
PLEASE SEE THE URL BELOW TO PURCHASE A NUCLEUS LICENSE AND DO NOT 
PROCEED WITH INSTALLING THIS PACKAGE.
====================================================================

For supported software packages please purchase a Nucleus license: 
https://www.atomicorp.com/products/nucleus.html
All atomic repository rpms are UNSUPPORTED.
Do you agree to these terms? (yes/no) [Default: yes] yes

Configuring the [atomic] yum archive for this system 

Installing the Atomic GPG key: OK
Downloading atomic-release-1.0-19.fc20.art.noarch.rpm: 
OK



The Atomic Rocket Turtle archive has now been installed and configured for your system
The following channels are available:
  atomic          - [ACTIVATED] - contains the stable tree of ART packages
  atomic-testing  - [DISABLED]  - contains the testing tree of ART packages
  atomic-bleeding - [DISABLED]  - contains the development tree of ART packages

 

yum install php-mssql #再次执行

[root@iZ25vqhgbx2Z freetds-0.91]# yum install php-mssql
Loaded plugins: security
atomic                                                   | 3.4 kB     00:00     
atomic/primary_db                                        | 844 kB     00:10     
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-mssql.x86_64 0:5.3.3-3.el6 will be updated
---> Package php-mssql.x86_64 0:5.4.31-37.el6.art will be an update
--> Processing Dependency: php-pdo(x86-64) = 5.4.31-37.el6.art for package: php-mssql-5.4.31-37.el6.art.x86_64
--> Running transaction check
---> Package php-pdo.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-pdo.x86_64 0:5.4.31-37.el6.art will be an update
--> Processing Dependency: php-common(x86-64) = 5.4.31-37.el6.art for package: php-pdo-5.4.31-37.el6.art.x86_64
--> Running transaction check
---> Package php-common.x86_64 0:5.3.3-27.el6_5.1 will be updated
--> Processing Dependency: php(api) = 20090626 for package: php-mcrypt-5.3.3-3.el6.x86_64
--> Processing Dependency: php(zend-abi) = 20090626 for package: php-mcrypt-5.3.3-3.el6.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-gd-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-cli-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-MySQL-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-bcmath-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-xml-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-ldap-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-odbc-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-xmlrpc-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-imap-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-5.3.3-27.el6_5.1.x86_64
--> Processing Dependency: php-common(x86-64) = 5.3.3-27.el6_5.1 for package: php-mbstring-5.3.3-27.el6_5.1.x86_64
---> Package php-common.x86_64 0:5.4.31-37.el6.art will be an update
--> Running transaction check
---> Package php.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-bcmath.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-bcmath.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-cli.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-cli.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-gd.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-gd.x86_64 0:5.4.31-37.el6.art will be an update
--> Processing Dependency: libt1.so.5()(64bit) for package: php-gd-5.4.31-37.el6.art.x86_64
---> Package php-imap.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-imap.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-ldap.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-ldap.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-mbstring.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-mbstring.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-mcrypt.x86_64 0:5.3.3-3.el6 will be updated
---> Package php-mcrypt.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-mysql.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-mysql.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-odbc.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-odbc.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-xml.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-xml.x86_64 0:5.4.31-37.el6.art will be an update
---> Package php-xmlrpc.x86_64 0:5.3.3-27.el6_5.1 will be updated
---> Package php-xmlrpc.x86_64 0:5.4.31-37.el6.art will be an update
--> Running transaction check
---> Package t1lib.x86_64 0:5.1.2-6.el6_2.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch          Version                  Repository     Size
================================================================================
Updating:
 php-mssql           x86_64        5.4.31-37.el6.art        atomic         66 k
Installing for dependencies:
 t1lib               x86_64        5.1.2-6.el6_2.1          base          160 k
Updating for dependencies:
 php                 x86_64        5.4.31-37.el6.art        atomic        2.7 M
 php-bcmath          x86_64        5.4.31-37.el6.art        atomic         60 k
 php-cli             x86_64        5.4.31-37.el6.art        atomic        2.6 M
 php-common          x86_64        5.4.31-37.el6.art        atomic        932 k
 php-gd              x86_64        5.4.31-37.el6.art        atomic        143 k
 php-imap            x86_64        5.4.31-37.el6.art        atomic         79 k
 php-ldap            x86_64        5.4.31-37.el6.art        atomic         62 k
 php-mbstring        x86_64        5.4.31-37.el6.art        atomic        944 k
 php-mcrypt          x86_64        5.4.31-37.el6.art        atomic         51 k
 php-mysql           x86_64        5.4.31-37.el6.art        atomic        136 k
 php-odbc            x86_64        5.4.31-37.el6.art        atomic         78 k
 php-pdo             x86_64        5.4.31-37.el6.art        atomic        120 k
 php-xml             x86_64        5.4.31-37.el6.art        atomic        171 k
 php-xmlrpc          x86_64        5.4.31-37.el6.art        atomic         70 k

Transaction Summary
================================================================================
Install       1 Package(s)
Upgrade      15 Package(s)

Total download size: 8.3 M
Is this ok [y/N]: y
Downloading Packages:
(1/16): php-5.4.31-37.el6.art.x86_64.rpm                 | 2.7 MB     00:09     
(2/16): php-bcmath-5.4.31-37.el6.art.x86_64.rpm          |  60 kB     00:00     
(3/16): php-cli-5.4.31-37.el6.art.x86_64.rpm             | 2.6 MB     00:22     
(4/16): php-common-5.4.31-37.el6.art.x86_64.rpm          | 932 kB     00:02     
(5/16): php-gd-5.4.31-37.el6.art.x86_64.rpm              | 143 kB     00:00     
(6/16): php-imap-5.4.31-37.el6.art.x86_64.rpm            |  79 kB     00:00     
(7/16): php-ldap-5.4.31-37.el6.art.x86_64.rpm            |  62 kB     00:00     
(8/16): php-mbstring-5.4.31-37.el6.art.x86_64.rpm        | 944 kB     00:02     
(9/16): php-mcrypt-5.4.31-37.el6.art.x86_64.rpm          |  51 kB     00:00     
(10/16): php-mssql-5.4.31-37.el6.art.x86_64.rpm          |  66 kB     00:00     
(11/16): php-mysql-5.4.31-37.el6.art.x86_64.rpm          | 136 kB     00:00     
(12/16): php-odbc-5.4.31-37.el6.art.x86_64.rpm           |  78 kB     00:00     
(13/16): php-pdo-5.4.31-37.el6.art.x86_64.rpm            | 120 kB     00:00     
(14/16): php-xml-5.4.31-37.el6.art.x86_64.rpm            | 171 kB     00:01     
(15/16): php-xmlrpc-5.4.31-37.el6.art.x86_64.rpm         |  70 kB     00:00     
(16/16): t1lib-5.1.2-6.el6_2.1.x86_64.rpm                | 160 kB     00:00     
--------------------------------------------------------------------------------
Total                                           166 kB/s | 8.3 MB     00:51     
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA1 Signature, key ID 4520afa9: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
Importing GPG key 0x5EBD2744:
 Userid : Atomic Rocket Turtle <admin@atomicrocketturtle.com>
 Package: atomic-release-1.0-19.el6.art.noarch (installed)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
Is this ok [y/N]: y
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY.atomicorp.txt
Importing GPG key 0x4520AFA9:
 Userid : Atomicorp (Atomicorp Official Signing Key) <support@atomicorp.com>
 Package: atomic-release-1.0-19.el6.art.noarch (installed)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY.atomicorp.txt
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Updating   : php-common-5.4.31-37.el6.art.x86_64                         1/31 
warning: /etc/php.ini created as /etc/php.ini.rpmnew
  Updating   : php-pdo-5.4.31-37.el6.art.x86_64                            2/31 
  Updating   : php-cli-5.4.31-37.el6.art.x86_64                            3/31 
  Installing : t1lib-5.1.2-6.el6_2.1.x86_64                                4/31 
  Updating   : php-gd-5.4.31-37.el6.art.x86_64                             5/31 
  Updating   : php-5.4.31-37.el6.art.x86_64                                6/31 
  Updating   : php-mssql-5.4.31-37.el6.art.x86_64                          7/31 
  Updating   : php-odbc-5.4.31-37.el6.art.x86_64                           8/31 
  Updating   : php-mysql-5.4.31-37.el6.art.x86_64                          9/31 
  Updating   : php-bcmath-5.4.31-37.el6.art.x86_64                        10/31 
  Updating   : php-xml-5.4.31-37.el6.art.x86_64                           11/31 
  Updating   : php-imap-5.4.31-37.el6.art.x86_64                          12/31 
  Updating   : php-mcrypt-5.4.31-37.el6.art.x86_64                        13/31 
  Updating   : php-mbstring-5.4.31-37.el6.art.x86_64                      14/31 
  Updating   : php-ldap-5.4.31-37.el6.art.x86_64                          15/31 
  Updating   : php-xmlrpc-5.4.31-37.el6.art.x86_64                        16/31 
  Cleanup    : php-5.3.3-27.el6_5.1.x86_64                                17/31 
  Cleanup    : php-mysql-5.3.3-27.el6_5.1.x86_64                          18/31 
  Cleanup    : php-odbc-5.3.3-27.el6_5.1.x86_64                           19/31 
  Cleanup    : php-mssql-5.3.3-3.el6.x86_64                               20/31 
  Cleanup    : php-pdo-5.3.3-27.el6_5.1.x86_64                            21/31 
  Cleanup    : php-cli-5.3.3-27.el6_5.1.x86_64                            22/31 
  Cleanup    : php-xmlrpc-5.3.3-27.el6_5.1.x86_64                         23/31 
  Cleanup    : php-ldap-5.3.3-27.el6_5.1.x86_64                           24/31 
  Cleanup    : php-gd-5.3.3-27.el6_5.1.x86_64                             25/31 
  Cleanup    : php-mbstring-5.3.3-27.el6_5.1.x86_64                       26/31 
  Cleanup    : php-mcrypt-5.3.3-3.el6.x86_64                              27/31 
  Cleanup    : php-imap-5.3.3-27.el6_5.1.x86_64                           28/31 
  Cleanup    : php-xml-5.3.3-27.el6_5.1.x86_64                            29/31 
  Cleanup    : php-bcmath-5.3.3-27.el6_5.1.x86_64                         30/31 
  Cleanup    : php-common-5.3.3-27.el6_5.1.x86_64                         31/31 
  Verifying  : php-bcmath-5.4.31-37.el6.art.x86_64                         1/31 
  Verifying  : php-mssql-5.4.31-37.el6.art.x86_64                          2/31 
  Verifying  : php-xml-5.4.31-37.el6.art.x86_64                            3/31 
  Verifying  : php-imap-5.4.31-37.el6.art.x86_64                           4/31 
  Verifying  : php-cli-5.4.31-37.el6.art.x86_64                            5/31 
  Verifying  : php-mcrypt-5.4.31-37.el6.art.x86_64                         6/31 
  Verifying  : php-odbc-5.4.31-37.el6.art.x86_64                           7/31 
  Verifying  : php-mbstring-5.4.31-37.el6.art.x86_64                       8/31 
  Verifying  : php-pdo-5.4.31-37.el6.art.x86_64                            9/31 
  Verifying  : php-mysql-5.4.31-37.el6.art.x86_64                         10/31 
  Verifying  : php-gd-5.4.31-37.el6.art.x86_64                            11/31 
  Verifying  : php-ldap-5.4.31-37.el6.art.x86_64                          12/31 
  Verifying  : t1lib-5.1.2-6.el6_2.1.x86_64                               13/31 
  Verifying  : php-common-5.4.31-37.el6.art.x86_64                        14/31 
  Verifying  : php-xmlrpc-5.4.31-37.el6.art.x86_64                        15/31 
  Verifying  : php-5.4.31-37.el6.art.x86_64                               16/31 
  Verifying  : php-pdo-5.3.3-27.el6_5.1.x86_64                            17/31 
  Verifying  : php-5.3.3-27.el6_5.1.x86_64                                18/31 
  Verifying  : php-mbstring-5.3.3-27.el6_5.1.x86_64                       19/31 
  Verifying  : php-odbc-5.3.3-27.el6_5.1.x86_64                           20/31 
  Verifying  : php-bcmath-5.3.3-27.el6_5.1.x86_64                         21/31 
  Verifying  : php-imap-5.3.3-27.el6_5.1.x86_64                           22/31 
  Verifying  : php-mssql-5.3.3-3.el6.x86_64                               23/31 
  Verifying  : php-xmlrpc-5.3.3-27.el6_5.1.x86_64                         24/31 
  Verifying  : php-common-5.3.3-27.el6_5.1.x86_64                         25/31 
  Verifying  : php-cli-5.3.3-27.el6_5.1.x86_64                            26/31 
  Verifying  : php-gd-5.3.3-27.el6_5.1.x86_64                             27/31 
  Verifying  : php-mysql-5.3.3-27.el6_5.1.x86_64                          28/31 
  Verifying  : php-mcrypt-5.3.3-3.el6.x86_64                              29/31 
  Verifying  : php-xml-5.3.3-27.el6_5.1.x86_64                            30/31 
  Verifying  : php-ldap-5.3.3-27.el6_5.1.x86_64                           31/31 

Dependency Installed:
  t1lib.x86_64 0:5.1.2-6.el6_2.1                                                

Updated:
  php-mssql.x86_64 0:5.4.31-37.el6.art                                          

Dependency Updated:
  php.x86_64 0:5.4.31-37.el6.art        php-bcmath.x86_64 0:5.4.31-37.el6.art  
  php-cli.x86_64 0:5.4.31-37.el6.art    php-common.x86_64 0:5.4.31-37.el6.art  
  php-gd.x86_64 0:5.4.31-37.el6.art     php-imap.x86_64 0:5.4.31-37.el6.art    
  php-ldap.x86_64 0:5.4.31-37.el6.art   php-mbstring.x86_64 0:5.4.31-37.el6.art
  php-mcrypt.x86_64 0:5.4.31-37.el6.art php-mysql.x86_64 0:5.4.31-37.el6.art   
  php-odbc.x86_64 0:5.4.31-37.el6.art   php-pdo.x86_64 0:5.4.31-37.el6.art     
  php-xml.x86_64 0:5.4.31-37.el6.art    php-xmlrpc.x86_64 0:5.4.31-37.el6.art  

Complete!
[root@iZ25vqhgbx2Z freetds-0.91]# 

2、php是用源码编译安装

cd /usr/local/src/php-5.3.15/ext/mssql #进入php源码包的ext下mssql目录

/usr/local/php5/bin/phpize

./configure --with-php-config=/usr/local/php5/bin/php-config --with-mssql=/usr/local/freetds #配置

注意:--with-mssql=/usr/local/freetds #是指freetds的安装路径

make #编译

make install #安装

vi /usr/local/php5/etc/php.ini #编辑,在最后位置添加下面一行

extension = "mssql.so"

:wq! #保存退出

3、重启LAMP或者LNMP

service httpd restart #重启apache

service php-fpm restart #重启php-fpm

三、测试php连接SQL Server 2000数据库

进入php程序目录,新建一个测试文件

cd /usr/local/nginx/html #请改为自己的网站目录

vi sql.php #添加以下内容

<?php

$mssql=mssql_connect("192.168.21.134","sa","123456");

if ($mssql) {

echo "Connent Mssql Succeed";

}

else {

echo "connent Mssql Error!";

}

?>

:wq! #保存退出

注意:这里的192.168.21.134必须要和/usr/local/freetds/etc/freetds.conf中的[192.168.21.134]完全一样

在浏览器中打开,出现下面的界面,连接成功

可以在新建一个文件

vi index.php

<?php

phpinfo();

?>

在浏览器中打开,能找到mssql,说明配置成功,如下图所示

至此,Linux下php连接SQL Server 2000数据库配置完成

相关实践学习
使用SQL语句管理索引
本次实验主要介绍如何在RDS-SQLServer数据库中,使用SQL语句管理索引。
SQL Server on Linux入门教程
SQL Server数据库一直只提供Windows下的版本。2016年微软宣布推出可运行在Linux系统下的SQL Server数据库,该版本目前还是早期预览版本。本课程主要介绍SQLServer On Linux的基本知识。 相关的阿里云产品:云数据库RDS&nbsp;SQL Server版 RDS SQL Server不仅拥有高可用架构和任意时间点的数据恢复功能,强力支撑各种企业应用,同时也包含了微软的License费用,减少额外支出。 了解产品详情:&nbsp;https://www.aliyun.com/product/rds/sqlserver
目录
打赏
0
0
0
0
1132
分享
相关文章
OmniSQL:开源文本到SQL神器!自然语言秒转查询到复杂多表连接等SQL需求
OmniSQL是开源的文本到SQL转换模型,通过创新的数据合成框架生成250万条高质量样本,支持7B/14B/32B三种模型版本,能处理从简单查询到复杂多表连接等各种SQL需求。
165 16
OmniSQL:开源文本到SQL神器!自然语言秒转查询到复杂多表连接等SQL需求
查看Linux、Apache、MySQL、PHP版本的技巧
以上就是查看Linux、Apache、MySQL、PHP版本信息的方法。希望这些信息能帮助你更好地理解和使用你的LAMP技术栈。
61 17
Android调试终极指南:ADB安装+多设备连接+ANR日志抓取全流程解析,覆盖环境变量配置/多设备调试/ANR日志分析全流程,附Win/Mac/Linux三平台解决方案
ADB(Android Debug Bridge)是安卓开发中的重要工具,用于连接电脑与安卓设备,实现文件传输、应用管理、日志抓取等功能。本文介绍了 ADB 的基本概念、安装配置及常用命令。包括:1) 基本命令如 `adb version` 和 `adb devices`;2) 权限操作如 `adb root` 和 `adb shell`;3) APK 操作如安装、卸载应用;4) 文件传输如 `adb push` 和 `adb pull`;5) 日志记录如 `adb logcat`;6) 系统信息获取如屏幕截图和录屏。通过这些功能,用户可高效调试和管理安卓设备。
如何排查和解决PHP连接数据库MYSQL失败写锁的问题
通过本文的介绍,您可以系统地了解如何排查和解决PHP连接MySQL数据库失败及写锁问题。通过检查配置、确保服务启动、调整防火墙设置和用户权限,以及识别和解决长时间运行的事务和死锁问题,可以有效地保障应用的稳定运行。
193 25
|
3月前
|
SecureCRT连接Linux时乱码问题
本文详细介绍了在使用SecureCRT连接Linux服务器时出现乱码问题的解决方法,包括设置SecureCRT字符编码、检查和配置Linux服务器字符编码、调整终端设置等。通过这些方法,您可以有效解决SecureCRT连接Linux时的乱码问题,确保正常的终端显示和操作。希望本文能帮助您在实际操作中更好地解决类似问题,提高工作效率。
85 17
|
2月前
|
微服务2——MongoDB单机部署4——Linux系统中的安装启动和连接
本节主要介绍了在Linux系统中安装、启动和连接MongoDB的详细步骤。首先从官网下载MongoDB压缩包并解压至指定目录,接着创建数据和日志存储目录,并配置`mongod.conf`文件以设定日志路径、数据存储路径及绑定IP等参数。之后通过配置文件启动MongoDB服务,并使用`mongo`命令或Compass工具进行连接测试。此外,还提供了防火墙配置建议以及服务停止的两种方法:快速关闭(直接杀死进程)和标准关闭(通过客户端命令安全关闭)。最后补充了数据损坏时的修复操作,确保数据库的稳定运行。
90 0
南大通用GBase 8a MPP Cluster Linux端SQL进程监控工具
南大通用GBase 8a MPP Cluster Linux端SQL进程监控工具
Linux下ODBC与 南大通用GBase 8s数据库的无缝连接配置指南
本文详细介绍在Linux系统下配置GBase 8s数据库ODBC的过程,涵盖环境变量设置、ODBC配置文件编辑及连接测试等步骤。首先配置数据库环境变量如GBASEDBTDIR、PATH等,接着修改odbcinst.ini和odbc.ini文件,指定驱动路径、数据库名称等信息,最后通过catalog.c工具或isql命令验证ODBC连接是否成功。
SQL语句实现投影连接:方法与技巧详解
在SQL数据库查询中,投影和连接是两个核心概念
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等