安装MySQL错误归档处理

核心提示： 解决：今天发现MYSQL官方5.1.22 对这个BUG进行了修正，mysql_install_db could fail to find its message file. (Bug#30678)[root@localhost mysql]# ln -s /usr/local/mysql/

解决：

今天发现MYSQL官方5.1.22 对这个BUG进行了修正。

mysql_install_db could fail to find its message file. (Bug#30678)

[root@localhost mysql]# ln -s /usr/local/mysql/share/mysql/english/ /usr/local/mysql/share/english

[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

正常启动

[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe &
[1] 2680
[root@localhost mysql]# 071129 13:45:16 mysqld_safe Logging to '/usr/local/mysql/data//localhost.localdomain.err'.
/usr/local/mysql/bin/mysqld_safe: line 366: [: -eq: unary operator expected
071129 13:45:16 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/
ps aux | grep mysql
root　　　2680　0.0　0.1　 4684　1144 pts/0　　S　　13:45　 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
nobody　　2748　1.6　1.7 108948 16796 pts/0　　Sl　 13:45　 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=nobody --log-error=/usr/local/mysql/data//localhost.localdomain.err --pid-file=/usr/local/mysql/data//localhost.localdomain.pid --socket=/tmp/mysql.sock --port=3306
root　　　2762　0.0　0.0　 4120　 668 pts/0　　S+　 13:45　 0:00 grep mysql

2、用 mysqldumpshow时遇到的错误：

[root@localhost bin]# mysqldumpslow
Can't determine basedir from 'my_print_defaults mysqld' output: --max-allowed-packet=100M
export PATH=$PATH:/usr/local/mysql/bin

就可以解决。