烂泥:Server-U FTP与Mysql数据库集成
本文由男装世家提供友情赞助,首发于烂泥行天下。昨天介绍了Server-UFTP与Windows用户集成后的权限问题,今天我再来介绍下。有关Server-UFTP与Mysql数据库集成的
昨天介绍了Server-U FTP与Windows用户集成后的权限问题,今天我再来介绍下。有关Server-U FTP与Mysql数据库集成的操作。
说明:本次实验在Windows Server 2008 R2在进行,需要使用到mysql数据库、mysql数据库客户端、Server-U FTP软件。
Server-U FTP与Mysql集成需要分成如下几步:
1、Mysql数据库安装及配置
2、ODBC的安装与配置
3、Server—U FTP配置
第一、Mysql数据库安装及配置
Mysql数据库我们在此使用的是绿色免安装版,不需要安装。如果有需要的话,可以在文章末尾打开相关链接进行下载。当然你也可以使用安装版mysql数据库,这个你可以自由选择。我们在这为了实验的方便,就不用安装版。
启动mysql数据库,然后使用Mysql客户端连接Mysql数据库。成功连接数据库后,新建一个空的数据库ilanni,如下图示:
第二、ODBC的安装与配置
首先普及下ODBC方面的知识,百度百科给出的解释ODBC是开放数据库互连(Open Database Connectivity,ODBC)的简称。它是微软公司开放服务结构中有关数据库的一个组成部分,它建立了一组规范,并提供了一组对数据库访问的标准API(应用程序编程接口)。这些API利用SQL来完成其大部分任务。ODBC本身也提供了对SQL语言的支持,用户可以直接将SQL语句送给ODBC。
为什么要安装ODBC呢?这个是因为Server-U FTP支持基于ODBC数据库的用户和用户组设置,所以我们要安装ODBC。
根据自己的OS及mysql数据库版本,选择相应的版本下载然后安装。具体安装过程在此不做详细介绍,只需要按照提示一步一步安装即可。
ODBC安装完毕后,我们可以点击“开始”—“管理工具”—“数据源ODBC”,如下图示:
在弹出的界面可以看到“系统DSN”—“添加”,如下图:
选择“Mysql ODBC 5.2 Driver”,,如下图:
在弹出的窗口我们填写相关信息,如下图示:
其中“Data Source Name”填写完毕后一定要记住,因为这个我们在后边还要使用,在这我们填写的是ilanni。而“TCP/IP Server”填写的是Msql数据库所在的服务器,现在Server-U FTP与Msql数据库在同一台服务器上,所以我们填写的是127.0.0.1。“User”填写的数据库用户,在此我们填写的是root用户。当然你也可以填写Mysql数据库的其他用户。“Database”是选择相应的数据。
以上填写完毕后,我们点击完成即可。最后的界面如下图示:
ODBC配置完毕后,我们也可以通过odbc.ini这个文件来查看相关信息,如下图:
第三步、Server—U FTP配置
Mysql与ODBC配置完毕后,我们接下来开始配置Server-U FTP。打开Server-U FTP,找到“管理域”—“ 为域中的账户和群组配置数据库访问设置”,如下图:
在弹出的界面中填写相关信息,如下图:
其中“数据源名称”要与ODBC的配置信息要相同,都是ilanni。而“数据库登录ID”和“数据库密码”也要和ODBC的配置信息相同。
这些填写完毕后,相应的选项要选中。然后点击“保存”。设置完毕后,最好要重启Server-U服务。如下图:
重启完毕后,我们现在可以使用mysql客户端连接数据库看看,如下图:
根据上图,可以很明显的看出Server-U FTP已经在ilanni这个数据库中已经成功创建相关的表。
现在我们来添加新的用户,“用户”—“创建、修改和删除存储在数据库中的用户账户”,如下图示:
点击“添加”,如下图:
在这我们可以设置用户的相关信息,如下图示:
Server-U FTP与Mysql数据库集成,用户的权限全部在这边进行控制,如上图。
用户添加完毕后的界面如下,如下图:
现在我们使用该用户登录FTP,看看实际的效果,如下图:
通过上图我们可以很明显的看到,ilanni这个用户已经成功登录FTP。那也就说明Server-U FTP集成成功。
现在我们再来看看Mysql数据库的相关情况,执行如下SQL语句:
select LoginID,HomeDir from suusers;
其中表suusers是用来存储FTP账号的相关信息,字段LoginID用来存储用户FTP账号,而字段HomeDir用来存储用户的主目录。如下图示:
至此Server-U FTP与mysql数据库集成完成。当然我们也可以把Server-U FTP与MSSQL、Oracle进行集成。
如果时间允许的话,到时间我们也写写相关的文章吧。
Mysql数据库免安装版:
本文出自 “烂泥行天下” 博客,请务必保留此出处

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
