Latest 5.1 does not start: [ERROR] Fatal error: Can't open and
Vasil Dimov
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
This is with the latest BK sources:
I did make install as usual, this procedure worked a few days ago.
Configured with
=2E/configure --prefix=3D/tmp/mysql-5.1-install --with-plugins=3Dinnobase
hag:/tmp/mysql-5.1-install$ ./bin/mysql_install_db=20
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:
/tmp/mysql-5.1-install/bin/mysqladmin -u root password 'new-password'
/tmp/mysql-5.1-install/bin/mysqladmin -u root -h hag.hw.v5d.org password 'n=
ew-password'
Alternatively you can run:
/tmp/mysql-5.1-install/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 /tmp/mysql-5.1-install ; /tmp/mysql-5.1-install/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /tmp/mysql-5.1-install/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /tmp/mysql-5.1-install/bin/mysqlbug scr=
ipt!
The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/
hag:/tmp/mysql-5.1-install$ ./libexec/mysqld=20
=2E/libexec/mysqld: Table 'mysql.plugin' doesn't exist
071214 15:58:27 [ERROR] Can't open the mysql.plugin table. Please run mysql=
_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
071214 15:58:27 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071214 15:58:27 InnoDB: Log file ./ib_logfile0 did not exist: new to be cr=
eated
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
071214 15:58:27 InnoDB: Log file ./ib_logfile1 did not exist: new to be cr=
eated
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071214 15:58:28 InnoDB: Started; log sequence number 0 0
071214 15:58:28 [ERROR] Fatal error: Can't open and lock privilege tables: =
Table 'mysql.host' doesn't exist
hag:/tmp/mysql-5.1-install$=20
Am I the only one seeing this?
--=20
Vasil Dimov
moc.e...@vomid.lisav Software Developer @ Oracle/Innobase Oy
gro.DSBeerF@dv Committer @ FreeBSD.org
gro.d5v@dv Home @ Sofia, Bulgaria
--+HP7ph2BbKc20aGI
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
iD8DBQFHYoN3Fw6SP/bBpCARAg91AJ9o+qbiE4+58o8fyfwtY/kM1BKedQCgqMIa
RFUM0GpZB6Ei1eed2PE2psE=
=MjTl
-----END PGP SIGNATURE-----
--+HP7ph2BbKc20aGI--
Mark Leith
Vasil Dimov wrote:
> This is with the latest BK sources:
>
> I did make install as usual, this procedure worked a few days ago.
>
> Configured with
> ./configure --prefix=/tmp/mysql-5.1-install --with-plugins=innobase
>
> hag:/tmp/mysql-5.1-install$ ./bin/mysql_install_db
> Installing MySQL system tables...
> OK
> Filling help tables...
> OK
> --snip--
> 071214 15:58:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
> hag:/tmp/mysql-5.1-install$
>
> Am I the only one seeing this?
>
Nope!
http://bugs.mysql.com/bug.php?id=33192
Best regards
Mark
--
Mark Leith, Manager of Support, Americas
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?unsub=mysql-i...@freebsd.csie.nctu.edu.tw
Vasil Dimov
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Fri, Dec 14, 2007 at 15:21:59 +0200, Vasil Dimov wrote:
[...]
> 071214 15:58:28 [ERROR] Fatal error: Can't open and lock privilege tables=
: Table 'mysql.host' doesn't exist
> hag:/tmp/mysql-5.1-install$=20
>=20
> Am I the only one seeing this?
Mark, Hartmut, I see this is already reported and a patch is queued,
thanks!
--=20
Vasil Dimov
moc.e...@vomid.lisav Software Developer @ Oracle/Innobase Oy
gro.DSBeerF@dv Committer @ FreeBSD.org
gro.d5v@dv Home @ Sofia, Bulgaria
--gBBFr7Ir9EOA20Yy
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
iD8DBQFHYqqfFw6SP/bBpCARAuq8AJ48Ywll+Z3G5iMn/E7SAmqXzXODiACfS1dU
WiFb8vvnYGr+0GG1mlAAB8w=
=6xOT
-----END PGP SIGNATURE-----
--gBBFr7Ir9EOA20Yy--