mysql怎么开启归档模式？Linux下

1.管理员身份连接数据库 C:\Users\Administrator>sqlplus sys/sys@prjdb as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Datab...

运行下面的DOS命令，粘贴结果上来大家帮你看： NETSTAT -ANO 可以把结果输出到记事本文件，命令是： NETSTAT -ANO >C:\NET.TXT 粘贴C:\NET.TXT的记事本文件内容上来。 补充： 错误信息是你输入密码不正确，与什么防火墙都无关。

1、

[root@localhost mysql]# scripts/mysql_install_db

Neither host 'localhost.localdomain' nor 'localhost' could be looked up with

/resolveip

Please configure the 'hostname' command to return a correct

hostname.

If you want to solve this at a later stage, restart this script

with the --force option

这个主要是修改/etc/hosts文件

echo "127.0.0.1 localhost.localdomain localhost" >>/etc/hosts

然后再初始化数据，如果还是同样的错误，那就直接加--force开关。

我今天碰到的就是这个情况。

[root@localhost mysql]# scripts/mysql_install_db --force

Installing MySQL system tables...

OK

Filling help tables...

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/local/mysql//bin/mysqladmin -u root password 'new-password'

/usr/local/mysql//bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

See the manual for more instructions.

You can start the MySQL daemon with:

cd . /usr/local/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

这样就成功初始化数据了。

---