|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
[root@server ~]
# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/
Installing MySQL system tables...2013-05-19 10:42:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation
for
more
details).
2013-05-19 10:42:24 2007 [Note] InnoDB: The InnoDB memory heap is disabled
2013-05-19 10:42:24 2007 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-05-19 10:42:24 2007 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-05-19 10:42:24 2007 [Note] InnoDB: Not using CPU crc32 instructions
2013-05-19 10:42:24 2007 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-05-19 10:42:24 2007 [Note] InnoDB: Completed initialization of buffer pool
2013-05-19 10:42:24 2007 [Note] InnoDB: Highest supported
file
format
is Barracuda.
2013-05-19 10:42:24 2007 [Note] InnoDB: 128 rollback segment(s) are active.
2013-05-19 10:42:24 2007 [Note] InnoDB: Waiting
for
purge to start
2013-05-19 10:42:24 2007 [Note] InnoDB: 5.6.11 started; log sequence number 1600607
ERROR: 1005 Can
't create table '
db' (errno: 13)
2013-05-19 10:42:24 2007 [ERROR] Aborting
2013-05-19 10:42:24 2007 [Note] Binlog end
2013-05-19 10:42:24 2007 [Note] InnoDB: FTS optimize thread exiting.
2013-05-19 10:42:24 2007 [Note] InnoDB: Starting
shutdown
...
2013-05-19 10:42:25 2007 [Note] InnoDB: Shutdown completed; log sequence number 1600617
2013-05-19 10:42:25 2007 [Note]
/usr/local/mysql//bin/mysqld
: Shutdown complete
|
解决方法：
将系统/etc/下默认的my.cnf 替换成mysql数据包中的配置文件
|
1
|
[root@server ~]
# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
|
再次执行：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
[root@server ~]
# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/ --user=mysql
Installing MySQL system tables...2013-05-19 10:52:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation
for
more
details).
2013-05-19 10:52:57 2180 [Note] InnoDB: The InnoDB memory heap is disabled
2013-05-19 10:52:57 2180 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-05-19 10:52:57 2180 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-05-19 10:52:57 2180 [Note] InnoDB: Not using CPU crc32 instructions
2013-05-19 10:52:57 2180 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-05-19 10:52:57 2180 [Note] InnoDB: Completed initialization of buffer pool
2013-05-19 10:52:57 2180 [Note] InnoDB: The first specified data
file
.
/ibdata1
did not exist: a new database to be created!
2013-05-19 10:52:57 2180 [Note] InnoDB: Setting
file
.
/ibdata1
size to 12 MB
2013-05-19 10:52:57 2180 [Note] InnoDB: Database physically writes the
file
full: wait...
2013-05-19 10:52:58 2180 [Note] InnoDB: Setting log
file
.
/ib_logfile101
size to 48 MB
2013-05-19 10:52:59 2180 [Note] InnoDB: Setting log
file
.
/ib_logfile1
size to 48 MB
2013-05-19 10:53:00 2180 [Note] InnoDB: Renaming log
file
.
/ib_logfile101
to .
/ib_logfile0
2013-05-19 10:53:00 2180 [Warning] InnoDB: New log files created, LSN=45781
2013-05-19 10:53:00 2180 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-05-19 10:53:00 2180 [Note] InnoDB: Doublewrite buffer created
2013-05-19 10:53:00 2180 [Note] InnoDB: 128 rollback segment(s) are active.
2013-05-19 10:53:00 2180 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-05-19 10:53:00 2180 [Note] InnoDB: Foreign key constraint system tables created
2013-05-19 10:53:00 2180 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-05-19 10:53:00 2180 [Note] InnoDB: Tablespace and datafile system tables created.
2013-05-19 10:53:00 2180 [Note] InnoDB: Waiting
for
purge to start
2013-05-19 10:53:00 2180 [Note] InnoDB: 5.6.11 started; log sequence number 0
2013-05-19 10:53:05 2180 [Note] Binlog end
2013-05-19 10:53:05 2180 [Note] InnoDB: FTS optimize thread exiting.
2013-05-19 10:53:05 2180 [Note] InnoDB: Starting
shutdown
...
2013-05-19 10:53:07 2180 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK
Filling help tables...2013-05-19 10:53:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation
for
more
details).
2013-05-19 10:53:07 2203 [Note] InnoDB: The InnoDB memory heap is disabled
2013-05-19 10:53:07 2203 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-05-19 10:53:07 2203 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-05-19 10:53:07 2203 [Note] InnoDB: Not using CPU crc32 instructions
2013-05-19 10:53:07 2203 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-05-19 10:53:07 2203 [Note] InnoDB: Completed initialization of buffer pool
2013-05-19 10:53:07 2203 [Note] InnoDB: Highest supported
file
format
is Barracuda.
2013-05-19 10:53:07 2203 [Note] InnoDB: 128 rollback segment(s) are active.
2013-05-19 10:53:07 2203 [Note] InnoDB: Waiting
for
purge to start
2013-05-19 10:53:07 2203 [Note] InnoDB: 5.6.11 started; log sequence number 1625977
2013-05-19 10:53:07 2203 [Note] Binlog end
2013-05-19 10:53:07 2203 [Note] InnoDB: FTS optimize thread exiting.
2013-05-19 10:53:07 2203 [Note] InnoDB: Starting
shutdown
...
2013-05-19 10:53:09 2203 [Note] InnoDB: Shutdown completed; log sequence number 1625987
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 server.clovem.com password
'new-password'
Alternatively you can run:
/usr/local/mysql//bin/mysql_secure_installation
which
will also give you the option of removing the
test
databases and anonymous user created by default. This is
strongly recommended
for
production servers.
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
WARNING: Found existing config
file
/usr/local/mysql//my
.cnf on the system.
Because this
file
might be
in
use, it was not replaced,
but was used
in
bootstrap (unless you used --defaults-
file
)
and when you later start the server.
The new default config
file
was created as
/usr/local/mysql//my-new
.cnf,
please compare it with your
file
and take the changes you need.
WARNING: Default config
file
/etc/my
.cnf exists on the system
This
file
will be
read
by default by the MySQL server
If you
do
not want to use this, either remove it, or use the
--defaults-
file
argument to mysqld_safe when starting the server
|
查看数据目录中的文件：
|
1
2
3
4
5
6
7
8
|
[root@server ~]
# ls /data/ -l
total 110604
-rw-rw----. 1 mysql mysql 12582912 May 19 10:53 ibdata1
-rw-rw----. 1 mysql mysql 50331648 May 19 10:53 ib_logfile0
-rw-rw----. 1 mysql mysql 50331648 May 19 10:52 ib_logfile1
drwx------. 2 mysql mysql 4096 May 19 10:53 mysql
drwx------. 2 mysql mysql 4096 May 19 10:53 performance_schema
drwx------. 2 mysql mysql 4096 May 19 10:52
test
|
本文转自 暗黑魔君 51CTO博客，原文链接：http://blog.51cto.com/clovemfong/1203910，如需转载请自行联系原作者
![2024Mysql And Redis基础与进阶操作系列（9）作者——LJS[含MySQL存储过程之局部、系统变量、参数传递、流程控制-判断/case具体详步骤；注意点及常见报错问题所对应的解决方法]](https://ucc.alicdn.com/pic/developer-ecology/56pfyutwi4tv4_c53df19098d2427391fe36eeb35f84c8.png?x-oss-process=image/resize,h_160,m_lfit)