1.安装mysql(以root用户操作)
root@vinco:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16 libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common mysql-server-5.1
mysql-server-core-5.1
Suggested packages:
dbishell libipc-sharedcache-perl tinyca mailx
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-server mysql-server-5.1 mysql-server-core-5.1
The following packages will be upgraded:
libmysqlclient16 mysql-common
2 upgraded, 9 newly installed, 0 to remove and 343 not upgraded.
Need to get 22.4MB of archives.
After this operation, 48.8MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://cn.archive.ubuntu.com karmic-updates/main mysql-common 5.1.37-1ubuntu5.5 [71.2kB]
Get:2 http://cn.archive.ubuntu.com karmic/main libnet-daemon-perl 0.43-1 [46.9kB]
Get:3 http://cn.archive.ubuntu.com karmic/main libplrpc-perl 0.2020-2 [36.0kB]
Get:4 http://cn.archive.ubuntu.com karmic/main libdbi-perl 1.609-1 [800kB]
Get:5 http://cn.archive.ubuntu.com karmic-updates/main libmysqlclient16 5.1.37-1ubuntu5.5 [1,904kB]
Get:6 http://cn.archive.ubuntu.com karmic/main libdbd-mysql-perl 4.011-1ubuntu1 [136kB]
Get:7 http://cn.archive.ubuntu.com karmic-updates/main mysql-client-5.1 5.1.37-1ubuntu5.5 [8,210kB]
Get:8 http://cn.archive.ubuntu.com karmic-updates/main mysql-server-core-5.1 5.1.37-1ubuntu5.5 [3,841kB]
Get:9 http://cn.archive.ubuntu.com karmic-updates/main mysql-server-5.1 5.1.37-1ubuntu5.5 [7,187kB]
Get:10 http://cn.archive.ubuntu.com karmic/main libhtml-template-perl 2.9-1 [65.8kB]
Get:11 http://cn.archive.ubuntu.com karmic-updates/main mysql-server 5.1.37-1ubuntu5.5 [65.5kB]
Fetched 22.4MB in 25min 21s (14.7kB/s)
Preconfiguring packages ...
(Reading database ... 122259 files and directories currently installed.)
Preparing to replace mysql-common 5.1.37-1ubuntu5 (using .../mysql-common_5.1.37-1ubuntu5.5_all.deb) ...
Unpacking replacement mysql-common ...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.609-1_i386.deb) ...
Preparing to replace libmysqlclient16 5.1.37-1ubuntu5 (using .../libmysqlclient16_5.1.37-1ubuntu5.5_i386.deb) ...
Unpacking replacement libmysqlclient16 ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.011-1ubuntu1_i386.deb) ...
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.37-1ubuntu5.5_i386.deb) ...
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.37-1ubuntu5.5_i386.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.37-1ubuntu5.5) ...
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 122591 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.37-1ubuntu5.5_i386.deb) ...
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.37-1ubuntu5.5_all.deb) ...
Processing triggers for sreadahead ...
Processing triggers for man-db ...
Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.609-1) ...
Setting up libmysqlclient16 (5.1.37-1ubuntu5.5) ...
Setting up libdbd-mysql-perl (4.011-1ubuntu1) ...
Setting up mysql-client-5.1 (5.1.37-1ubuntu5.5) ...
Setting up mysql-server-core-5.1 (5.1.37-1ubuntu5.5) ...
Setting up mysql-server-5.1 (5.1.37-1ubuntu5.5) ...
* Stopping MySQL database server mysqld [ OK ]
110721 20:41:44 [Note] Plugin 'FEDERATED' is disabled.
110721 20:41:45 InnoDB: Started; log sequence number 0 44233
110721 20:41:45 InnoDB: Starting shutdown...
110721 20:41:46 InnoDB: Shutdown completed; log sequence number 0 44233
110721 20:41:46 [Warning] Forcing shutdown of 1 plugins
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
Setting up libhtml-template-perl (2.9-1) ...
Setting up mysql-server (5.1.37-1ubuntu5.5) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
root@vinco:/etc/apache2/sites-available# apt-get install libapache2-mode-auth-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Couldn't find package libapache2-mode-auth-mysql
root@vinco:/etc/apache2/sites-available# apt-get install libapache2-mod-auth-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
libapache2-mod-auth-mysql
0 upgraded, 1 newly installed, 0 to remove and 343 not upgraded.
Need to get 25.3kB of archives.
After this operation, 111kB of additional disk space will be used.
Err http://cn.archive.ubuntu.com karmic/main libapache2-mod-auth-mysql 4.3.9-11ubuntu1
Could not resolve 'cn.archive.ubuntu.com'
Failed to fetch http://cn.archive.ubuntu.com/ubuntu/pool/main/m/mod-auth-mysql/libapache2-mod-auth-mysql_4.3.9-11ubuntu1_i386.deb Could not resolve 'cn.archive.ubuntu.com'
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
root@vinco:/etc/apache2/sites-available# apt-get install libapache2-mod-auth-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
libapache2-mod-auth-mysql
0 upgraded, 1 newly installed, 0 to remove and 343 not upgraded.
Need to get 25.3kB of archives.
After this operation, 111kB of additional disk space will be used.
Get:1 http://cn.archive.ubuntu.com karmic/main libapache2-mod-auth-mysql 4.3.9-11ubuntu1 [25.3kB]
Fetched 25.3kB in 15s (1,652B/s)
Selecting previously deselected package libapache2-mod-auth-mysql.
(Reading database ... 122687 files and directories currently installed.)
Unpacking libapache2-mod-auth-mysql (from .../libapache2-mod-auth-mysql_4.3.9-11ubuntu1_i386.deb) ...
Setting up libapache2-mod-auth-mysql (4.3.9-11ubuntu1) ...
root@vinco:~#
2.配置mysql
root@vinco:~# vim /etc/mysql/my.cnf
bind-address 127.0.0.1 默认是只允许本地访问数据库,如果有需要其他机器访问 把这句话用#注释掉
#bind-address 127.0.0.1
3.重启Mysql
root@vinco:~# /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
root@vinco:~#