[root@test35 ~]# /usr/bin/mysqld_safe &
[1] 7187
[root@test35 ~]# Starting mysqld daemon with databases from /var/lib/mysql
Number of processes running now: 0
090611 10:23:07 mysqld restarted
Number of processes running now: 0
090611 10:23:09 mysqld restarted
Number of processes running now: 0
090611 10:23:10 mysqld restarted
mysql总是在不停的重启。
下面是my.cnf的一些参数
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 30
default-table-type=innodb
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
max_connections = 400
transaction-isolation = READ-COMMITTED
那位大侠能帮我解决下！
blueskysee 于 2009-06-11 11:16:26发表:
[root@test35 config]# /usr/sbin/mysqld --skip-grant &
[1] 8981
[root@test35 config]# 090611 11:13:29 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
090611 11:13:29 [ERROR] Aborting
090611 11:13:29 [Note] /usr/sbin/mysqld: Shutdown complete
[1]+ Exit 1 /usr/sbin/mysqld --skip-grant
[root@test35 config]# /usr/sbin/mysqld --skip-grant &
[1] 8982
[root@test35 config]# 090611 11:15:41 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
090611 11:15:41 [ERROR] Aborting
090611 11:15:41 [Note] /usr/sbin/mysqld: Shutdown complete
[1]+ Exit 1 /usr/sbin/mysqld --skip-grant
[ERROR] Fatal error: Please read "Security"
blueskysee 于 2009-06-11 11:14:17发表:
[root@test35 config]# /usr/bin/mysql_install_db -user=mysql
Installing all prepared tables
/usr/sbin/mysqld: Too many arguments (first extra is '-user=mysql').
Use --help to get a list of available options
Installation of system tables failed!
Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
这就是他的账户活动，我看不出什么问题啊！说实话我也看的不是太懂！
lvcebo 于 2009-06-11 11:10:20发表:
参照用mysql帐号启动，bin/mysql_install_db -user=mysql，然后启动bin/mysqld_safe
blueskysee 于 2009-06-11 10:50:09发表:
mysql.log是空的。