Use the MySQL database in Ubuntu to verify the creation of the SVN server accessed

1. Install the Apacheapt-getinstallapache22. Install the MySQLapt-getinstallmysql-server3. Install the subversionapt-getinstallsubversionlibapache2-svnlibapache2-mod-auth-mysql4. Create a subversion project to modify the user so that

1. install Apache

Apt-get install apache2

2. Install MySQL

Apt-get install mysql-server

3. Install subversion

Apt-get install subversion libapache2-svn libapache2-mod-auth-mysql

4. Create a subversion project and modify users so that they can be accessed through HTTP

Svnadmin create/var/www/svn

Chown-R www-data/home/www/svn

5. Import the project

Svn import/tmp/shou/project file: // var/www/svn-m "comment"

6. Create a user verification database

1. Creata table svn;
2. CREATETABLEuser (
3. Id INTEGERNOTNULLPRIMARYKEY AUTO_INCREMENT,
4. Username char (128) notnull comment 'username ',
5. Passwordchar (128) notnull comment 'Password'
6. ) ENGINE = InnoDB default charset = utf8;
7. INSERTINTOuser (username, password) VALUES ('admin', MD5 ('admin '));

7. Configure the Apache file, open the file/etc/apache2/sites-available/default, and add the following configuration information

2. DAV svn
3. SVNPath/var/www/svn
4. AuthType Basic
5. AuthName "Subversion Repository"
6. Auth_MySQL On
7. Auth_MySQL_Authoritative On
8. Auth_MySQL_Host localhost
9. Auth_MySQL_DB svn
10. Auth_MySQL_User root
11. Auth_MySQL_Password rootadmin
12. Auth_MySQL_Password_Table user
13. Auth_MySQL_Username_Field username
14. Auth_MySQL_Password_Field password
15. Auth_MySQL_Empty_Passwords Off
16. Auth_MySQL_Encrypted_Passwords On
17. Auth_MySQL_Encryption_Types PHP_MD5
19. AuthBasicAuthoritative Off
20. AuthUserFile/dev/null
22. Require valid-user

※The preceding configuration information is recommended to be defined in the/etc/apache2/mod-available/dav_svn.conf file.