检查一下/data/mysql/bin/mysqld 文件夹的权限
解决方案 »
- mysql导出数据库中包含二进制数据问题
- java存取mysql,中文显示问题
- 如何查询在一个数据库中某个字段存在于哪些表
- 这样的SQL语句如何写(MYSQL)
- 大家好,如何快速查找某文本字段重复记录并且更新表字段!! 谢谢!!分不够还可以加!!
- powerdesigner是否支持mysql5.0!
- 请问 MySQL 是否可以象Access一样,不需要装服务器端就可以单机运行。只需要加一些数据访问链接库。
- MySQL Cluster初步学习资料整理--安装部署新特性性能测试等
- innodb处理事务慢如何优化?
- 如何设计数据库可以达到从后往前取到每个用户的最后一条信息?
- 有用DbVisualizer的吗?
- 目录树与关联表去除父ID的SQL,比较有难度
[dbaroot@twpdb06 mysql]$ ls -la bin/mysqld
-rwxr-xr-x. 1 mysql mysql 75509871 Apr 5 21:40 bin/mysqld
[dbaroot@twpdb06 mysql]$
全的error log130630 21:47:55 mysqld_safe mysqld from pid file /data/mysql/data/twpdb06.pid ended
130630 22:05:54 mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
2013-06-30 22:05:54 44629 [Note] Plugin 'FEDERATED' is disabled.
2013-06-30 22:05:54 44629 [Note] InnoDB: The InnoDB memory heap is disabled
2013-06-30 22:05:54 44629 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-06-30 22:05:54 44629 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-06-30 22:05:54 44629 [Note] InnoDB: Using Linux native AIO
2013-06-30 22:05:54 44629 [Note] InnoDB: Using CPU crc32 instructions
2013-06-30 22:05:54 44629 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-06-30 22:05:54 44629 [Note] InnoDB: Completed initialization of buffer pool
2013-06-30 22:05:54 44629 [Note] InnoDB: Highest supported file format is Barracuda.
2013-06-30 22:05:54 44629 [Note] InnoDB: 128 rollback segment(s) are active.
2013-06-30 22:05:54 44629 [Note] InnoDB: Waiting for purge to start
2013-06-30 22:05:54 44629 [Note] InnoDB: 5.6.11 started; log sequence number 1626057
2013-06-30 22:05:54 44629 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2e01771e-e18e-11e2-bc55-d89d67176ba4.
/data/mysql/bin/mysqld: File './auto.cnf' not found (Errcode: 13 - Permission denied)
2013-06-30 22:05:54 44629 [ERROR] Failed to create file(file: './auto.cnf', errno 13)
2013-06-30 22:05:54 44629 [ERROR] Initialzation of the server's UUID failed because it could not be read from the auto.cnf file. If this is a new server, the initialization failed because it was not possible to generate a new UUID.
2013-06-30 22:05:54 44629 [ERROR] Aborting2013-06-30 22:05:54 44629 [Note] Binlog end
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'partition'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'BLACKHOLE'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'ARCHIVE'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_METRICS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_CMP'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'INNODB_TRX'
2013-06-30 22:05:54 44629 [Note] Shutting down plugin 'InnoDB'
2013-06-30 22:05:54 44629 [Note] InnoDB: FTS optimize thread exiting.
2013-06-30 22:05:54 44629 [Note] InnoDB: Starting shutdown...
2013-06-30 22:05:56 44629 [Note] InnoDB: Shutdown completed; log sequence number 1626067
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'MRG_MYISAM'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'MyISAM'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'CSV'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'MEMORY'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'sha256_password'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'mysql_old_password'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'mysql_native_password'
2013-06-30 22:05:56 44629 [Note] Shutting down plugin 'binlog'
2013-06-30 22:05:56 44629 [Note] /data/mysql/bin/mysqld: Shutdown complete130630 22:05:56 mysqld_safe mysqld from pid file /data/mysql/data/twpdb06.pid ended
[dbaroot@twpdb06 data]$ cd ..
[dbaroot@twpdb06 mysql]$ ls -la bin/mysqld
-rwxr-xr-x. 1 mysql mysql 75509871 Apr 5 21:40 bin/mysqld
[dbaroot@twpdb06 mysql]$
[sudo] password for dbaroot:
Matching Defaults entries for dbaroot on this host:
requiretty, !visiblepw, always_set_home, env_reset, env_keep="COLORS DISPLAY HOSTNAME HISTSIZE INPUTRC KDEDIR LS_COLORS", env_keep+="MAIL PS1 PS2 QTDIR USERNAME LANG
LC_ADDRESS LC_CTYPE", env_keep+="LC_COLLATE LC_IDENTIFICATION LC_MEASUREMENT LC_MESSAGES", env_keep+="LC_MONETARY LC_NAME LC_NUMERIC LC_PAPER LC_TELEPHONE",
env_keep+="LC_TIME LC_ALL LANGUAGE LINGUAS _XKB_CHARSET XAUTHORITY", secure_path=/sbin\:/bin\:/usr/sbin\:/usr/binUser dbaroot may run the following commands on this host:
(ALL) ALL
[dbaroot@twpdb06 data]$
total 88
drwxr-xr-x. 13 root mysql 4096 Jun 28 03:23 .
drwxr-xr-x. 5 root root 4096 Jun 28 03:20 ..
drwxr-xr-x. 2 mysql mysql 4096 Jun 28 03:19 bin
-rw-r--r--. 1 root mysql 17987 Apr 5 20:27 COPYING
drwxr-xr-x. 5 root mysql 4096 Jun 30 22:05 data
drwxr-xr-x. 2 root mysql 4096 Jun 28 03:19 docs
drwxr-xr-x. 3 root mysql 4096 Jun 28 03:19 include
-rw-r--r--. 1 root mysql 7468 Apr 5 20:27 INSTALL-BINARY
drwxr-xr-x. 3 root mysql 4096 Jun 28 03:19 lib
drwxr-xr-x. 4 root mysql 4096 Jun 28 03:19 man
-rw-r--r--. 1 root root 943 Jun 28 03:23 my.cnf
drwxr-xr-x. 10 root mysql 4096 Jun 28 03:19 mysql-test
-rw-r--r--. 1 root mysql 2552 Apr 5 20:27 README
drwxr-xr-x. 2 root mysql 4096 Jun 28 03:19 scripts
drwxr-xr-x. 28 root mysql 4096 Jun 28 03:19 share
drwxr-xr-x. 4 root mysql 4096 Jun 28 03:19 sql-bench
drwxr-xr-x. 3 root mysql 4096 Jun 28 03:19 support-files
[dbaroot@twpdb06 mysql]$
/etc/my.cnf
/usr/my.cnf
/data/mysql/my.cnf
/data/mysql/mysql-test/suite/ndb_binlog/my.cnf
/data/mysql/mysql-test/suite/ndb_rpl/my.cnf
/data/mysql/mysql-test/suite/ndb/my.cnf
/data/mysql/mysql-test/suite/ndb_team/my.cnf
/data/mysql/mysql-test/suite/ndb_big/my.cnf
/data/mysql/mysql-test/suite/rpl/my.cnf
/data/mysql/mysql-test/suite/rpl/extension/bhs/my.cnf
/data/mysql/mysql-test/suite/rpl_ndb/my.cnf
/data/mysql/mysql-test/suite/federated/my.cnf
[dbaroot@twpdb06 mysql]$