安装的mysql版本是:mysql-5.1.48以前在debian5上面编译很顺利,这次换debian6,就不行了贴下编译参数:
./configure --prefix=/usr/local/mysql --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-charset=utf8 --enable-thread-safe-client --with-extra-charsets=all --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile
make && make install执行下面这步时出错:
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql出错提示:root@206412:~# /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql
Installing MySQL system tables...
ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' (Errcode: 13)
110409 14:46:58 [ERROR] Aborting110409 14:46:58 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/usr/local/mysql/var for more information.You can try to start the mysqld daemon with: shell> /usr/local/mysql/libexec/mysqld --skip-grant &and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tablesTry 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/mysql/scripts/mysqlbug script!
请问这个该怎么解决?问题出在哪里呢?
./configure --prefix=/usr/local/mysql --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-charset=utf8 --enable-thread-safe-client --with-extra-charsets=all --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile
make && make install执行下面这步时出错:
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql出错提示:root@206412:~# /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql
Installing MySQL system tables...
ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' (Errcode: 13)
110409 14:46:58 [ERROR] Aborting110409 14:46:58 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/usr/local/mysql/var for more information.You can try to start the mysqld daemon with: shell> /usr/local/mysql/libexec/mysqld --skip-grant &and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tablesTry 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/mysql/scripts/mysqlbug script!
请问这个该怎么解决?问题出在哪里呢?
/usr/local/mysql/var for more information.
这个目录下有这几个文件:
mysql mysql-bin.000001 mysql-bin.000002 mysql-bin.000003 mysql-bin.000004 mysql-bin.000005 mysql-bin.index test像mysql-bin.000005文件打开是一行乱码,看不到内容
http://dev.mysql.com/doc/refman/5.1/zh/installing.html#quick-install
创建了,我贴下全部步骤吧./configure --prefix=/usr/local/mysql --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-charset=utf8 --enable-thread-safe-client --with-extra-charsets=all --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile
make && make installgroupadd mysql
useradd -g mysql mysql
cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
sed -i 's/skip-locking/skip-external-locking/g' /etc/my.cnf
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql