ubuntu 8.04下mysql安装问题

[f250303748]

因为mysql有点问题就想卸了重装一下，
sudo apt-get install mysql-server-5.0
报错信息：
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server-5.0 is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 42 not upgraded.
1 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.4) ...
* Stopping MySQL database server mysqld [ OK ]
Reloading AppArmor profiles : done.
* Starting MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)

[f250303748]

syslog日志
mysqld[6437]: 090610 11:19:07 [Warning] Can't create test file /home/database/mysqldb/mysql/0.lower-test
Jun 10 11:19:07 0 mysqld[6437]: 090610 11:19:07 [Warning] Can't create test file /home/database/mysqldb/mysql/0.lower-test
Jun 10 11:19:07 0 kernel: [ 1261.057989] audit(1244647147.799:29): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/home$
Jun 10 11:19:07 0 kernel: [ 1261.058119] audit(1244647147.799:30): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/home$
Jun 10 11:19:07 0 mysqld[6437]: 090610 11:19:07 InnoDB: Operating system error number 13 in a file operation.
Jun 10 11:19:07 0 mysqld[6437]: InnoDB: The error means mysqld does not have the access rights to
Jun 10 11:19:07 0 mysqld[6437]: InnoDB: the directory.
Jun 10 11:19:07 0 mysqld[6437]: InnoDB: File name ./ibdata1
Jun 10 11:19:07 0 mysqld[6437]: InnoDB: File operation call: 'open'.
Jun 10 11:19:07 0 mysqld[6437]: InnoDB: Cannot continue operation.
Jun 10 11:19:07 0 kernel: [ 1261.073643] audit(1244647147.819:31): type=1503 operation="inode_permission" requested_mask="rw::" denied_mask="rw::" name=$
Jun 10 11:19:07 0 mysqld_safe[6444]: ended
Jun 10 11:19:21 0 /etc/init.d/mysql[6594]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 10 11:19:21 0 /etc/init.d/mysql[6594]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jun 10 11:19:21 0 /etc/init.d/mysql[6594]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jun 10 11:19:21 0 /etc/init.d/mysql[6594]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

文件
mad@0:~$ ls /home/database/mysqldb/mysql -l
total 20488
-rw-r--r-- 1 mysql mysql 0 2009-06-04 13:30 debian-5.0.flag
-rw-rw---- 1 mysql mysql 10485760 2009-06-09 09:02 ibdata1
-rw-rw---- 1 mysql mysql 5242880 2009-06-09 09:02 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2009-06-04 13:37 ib_logfile1
drwxr-xr-x 2 mysql mysql 4096 2009-06-04 13:37 mysql
-rw------- 1 mysql mysql 7 2009-06-04 13:37 mysql_upgrade_info

[ACMAIN_CHM]

[Warning] Can't create test file /home/database/mysqldb/mysql/0.lower-test

先试改一下权限。

chmod 777 /home/database/mysqldb/mysql

[f250303748]

试过了，还是这个错。

[f250303748]

重新安装
mad@0:~$ sudo apt-get install mysql-server-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server-5.0 is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 42 not upgraded.
1 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.4) ...
* Stopping MySQL database server mysqld [ OK ]
090610 11:41:25 [Warning] Can't create test file /home/database/mysqldb/mysql/sfdb0.lower-test
090610 11:41:25 [Warning] Can't create test file /home/database/mysqldb/mysql/sfdb0.lower-test
090610 11:41:25 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
090610 11:41:25 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
090610 11:41:25 [ERROR] Aborting

090610 11:41:25 [Note] /usr/sbin/mysqld: Shutdown complete

Reloading AppArmor profiles : done.
* Starting MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)

[ACMAIN_CHM]

你的 my.cnf 中的datadir 参数指向哪里？

[macower]

直接在添加和删除程序那个地方去找 mysql 然后 让他自动下载
直接安装配置就ok