安装完后,启动MYSQL。
# ./bin/mysql -h 127.0.0.1 -u root
mysql>show databases;
Empty set (0.00 sec)
mysql> create database intemanager;
ERROR 1006: Can't create database 'intemanager'. (errno: 2)请高手赐教,其他信息见下面;安装环境和过程如下:
os:redhat7.3
jdk:Java(TM) 2 SDK 1_4_1_02
tomcat:jakarta-tomcat-4.0.6
mysql:mysql-standard-4.0.14-pc-linux-i686 采用如下过程安装:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql & 其中一些反馈信息:
安装授权库,信息如下
[root@localhost mysql]# ./scripts/mysql_install_db
Installing all prepared tables
030812 16:09:43 ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &You can test the MySQL daemon with the benchs in the 'sql-bench' directory:
cd sql-bench ; perl run-all-testsPlease 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 https://order.mysql.com启动数据库,信息如下:
[root@localhost mysql]# bin/mysqld_safe --user=mysql &
[1] 24768
[root@localhost mysql]# Starting mysqld daemon with databases rom /usr/local/mysql/data
030812 10:38:59 mysqld ended 停止数据库,显示如下:
[root@localhost bin]# ./mysqld
030812 16:11:46 Can't start server: Bind on TCP/IP port: Address already in use
030812 16:11:46 Do you already have another mysqld server running on port: 3306
?
030812 16:11:46 Aborting030812 16:11:46 ./mysqld: Shutdown Complete
mysqlbug显示如下:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: tom
To: [email protected]
Subject: [50 character or so descriptive subject here (for reference)]>Description:
<precise description of the problem (multiple lines)>
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
>Fix:
<how to correct or work around the problem, if known (multiple lines)>>Submitter-Id: <submitter ID>
>Originator: tom
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-4.0.14-standard (Official MySQL-standard binary)>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux localhost.localdomain 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i6\
86 unknown
Architecture: i686Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/c\
c
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS=\
'-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 7月 24 00:09 /lib/libc.so.6 -> libc\
-2.2.5.so
-rwxr-xr-x 1 root root 1260480 4月 15 2002 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2310808 4月 15 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 4月 15 2002 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/us\
r/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Officia\
l MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=\
-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-asse\
mbler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ld\
flags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 \
-mcpu=pentiumpro -felide-constructors' 'CXX=gcc'
# ./bin/mysql -h 127.0.0.1 -u root
mysql>show databases;
Empty set (0.00 sec)
mysql> create database intemanager;
ERROR 1006: Can't create database 'intemanager'. (errno: 2)请高手赐教,其他信息见下面;安装环境和过程如下:
os:redhat7.3
jdk:Java(TM) 2 SDK 1_4_1_02
tomcat:jakarta-tomcat-4.0.6
mysql:mysql-standard-4.0.14-pc-linux-i686 采用如下过程安装:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql & 其中一些反馈信息:
安装授权库,信息如下
[root@localhost mysql]# ./scripts/mysql_install_db
Installing all prepared tables
030812 16:09:43 ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &You can test the MySQL daemon with the benchs in the 'sql-bench' directory:
cd sql-bench ; perl run-all-testsPlease 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 https://order.mysql.com启动数据库,信息如下:
[root@localhost mysql]# bin/mysqld_safe --user=mysql &
[1] 24768
[root@localhost mysql]# Starting mysqld daemon with databases rom /usr/local/mysql/data
030812 10:38:59 mysqld ended 停止数据库,显示如下:
[root@localhost bin]# ./mysqld
030812 16:11:46 Can't start server: Bind on TCP/IP port: Address already in use
030812 16:11:46 Do you already have another mysqld server running on port: 3306
?
030812 16:11:46 Aborting030812 16:11:46 ./mysqld: Shutdown Complete
mysqlbug显示如下:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: tom
To: [email protected]
Subject: [50 character or so descriptive subject here (for reference)]>Description:
<precise description of the problem (multiple lines)>
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
>Fix:
<how to correct or work around the problem, if known (multiple lines)>>Submitter-Id: <submitter ID>
>Originator: tom
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-4.0.14-standard (Official MySQL-standard binary)>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux localhost.localdomain 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i6\
86 unknown
Architecture: i686Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/c\
c
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS=\
'-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 7月 24 00:09 /lib/libc.so.6 -> libc\
-2.2.5.so
-rwxr-xr-x 1 root root 1260480 4月 15 2002 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2310808 4月 15 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 4月 15 2002 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/us\
r/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Officia\
l MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=\
-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-asse\
mbler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ld\
flags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 \
-mcpu=pentiumpro -felide-constructors' 'CXX=gcc'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货