Description:
running mysql_install_db does not correctly fill grant tables
How-To-Repeat:
run mysql_install_db; attempt to connect, fail.
Fix:
Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL**
Submitter-Id: [EMAIL PROTECTED]
Originator:Adam Thompson
Organization
by the port. I copy
/usr/local/share/my-medium.cnf to /etc/my.cnf. I run: cd
/usr/local/mysql; chown -R mysql .; chgrp -R mysql .
I then execute mysql_install_db --user=mysql; this prints Install
MySQL system tables... but nothing more.
When I run ps aux | grep mysql to see what has happened, I see
if that created the mysql database or not (don't
think so).
Anyway if someone could let me know what this script creates, that would
help me a lot.
Thanks!!
Mark
--
View this message in context:
http://www.nabble.com/mysql_install_db-tp16945907p16945907.html
Sent from the MySQL - General
Hi,
mysql_install_db is a script to create the mysql database which is the database
we need all the time to run mysql server.
Information_schema is not a physical database. It will not come under the data
folder. That database is to keep the details of the current status of existing
databases
Hello,
I'm trying to install mysql 4.1
After the installation, I launch the script for the post-installation,
in scripts/mysql_install_db
I get this error :
Could not find help file 'fill_help_tables.sql' in ./support-files or
inside ..
When I try to go on phpmyadmin, it doesn't work
Description:
I downloaded mysql-standard-5.0.27-solaris8-sparc-64bit.pkg from the
MySQL
site, and installed it by a default pkgadd - it installed itself under
/opt/mysql/mysql.
I then ran mysql_install_db as root with single option --user=mysql, and
then tried mysqld_safe but it failed.
So I
://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Transcript:
# su mysql
bash-3.00$ cd /var/lib
bash-3.00$ mysql_install_db
Installing all prepared tables
Fill help tables
ERROR: 1064 You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version
to follow directions in
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Transcript:
# su mysql
bash-3.00$ cd /var/lib
bash-3.00$ mysql_install_db
Installing all prepared tables
Fill help tables
ERROR: 1064 You have an error in your SQL syntax; check the manual that
corresponds
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: root
To: mysql@lists.mysql.com
Subject: [Error while runnign ./scripts/mysql_install_db --user=mysql]
Description
Hello.
What am I missing? I installed MySQL using the installer package.
Usually installer has run mysql_install_db, but if you still want to
rerun it, invoke mysql_install_db with --user=mysql option under the
root account, and fix possible issues with the rights using 'chmod' later
Hello all,
I just installed MySQL 5 on Mac OS 10.3.9. Now when I try to create a
user using any method it does not work. I read I may have to run the
mysql_install_db script so I did, but I get these results:
mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
mkdir
Please see the attached output of the
bug report and an output file of the messages that came out in the screen
on Sun Solaris 8 while running the mysql_install_db for MySQL version 4,1.14,
64 bit. I got the same message for 32 bit version also. I tried MySQL version
4,1.12, 64 bit and 32 bit
Helal Khan [EMAIL PROTECTED] wrote on 08/30/2005 04:35:48 PM:
Please see the attached output of the bug report and an output file
of the messages that came out in the screen on Sun Solaris 8 while
running the mysql_install_db for MySQL version 4,1.14, 64 bit. I got
the same message for 32
Hi,
Your error message
khanstation# scripts/mysql_install_db --user=mysql
Installing all prepared tables
ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or
directory --
means you don't have zlib installed or you don't
Sargent.
Hi All,
does nobody understand why this is so.? I keep having to move the script
to /usr/local/mysql to get it to run. That is just, well, weird. Anyone
else out there using the tar.gz install and if so, could you confirm
that your scripts/mysql_install_db code has the same thing
Hi All,
if this script is in scripts by default, why does it have the following
code,
test -z $ldata ldata=./data
if test -z $basedir
then
basedir=.
bindir=./bin
execdir=./bin
pkgdatadir=./support-files
else
bindir=$basedir/bin
if test -x $basedir/libexec/mysqld
then
Description:
Running mysql_install_db generates an error. As follows:
bash-3.00# scripts/mysql_install_db --user=mysql
Installing all prepared tables
Illegal Instruction - core dumped
Installation of system tables failed!
Examine the logs in ./data for more
Hi,
I installed mysql-standard-4.0.24-sun-solaris2.8-sparc on a Solaris 5.8 macine.
However while i'm running the mysql_install_db script i'm getting the error
ld.so.1: ./bin/mysqld: fatal: libCstd.so.1: open failed: No such file
or directory
Killed
Installation of grant tables failed!
I've my
@lists.mysql.com
Subject: libCstd.so.1 not found while running mysql_install_db
Hi,
I installed mysql-standard-4.0.24-sun-solaris2.8-sparc on a Solaris 5.8
macine. However while i'm running the mysql_install_db script i'm
getting the error
ld.so.1: ./bin/mysqld: fatal: libCstd.so.1: open failed
: libCstd.so.1 not found while running mysql_install_db
Do you have /cnem/server/bin/mysqld file ? Is it exec (6xx)?
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Anirban Karmakar [mailto:[EMAIL
Hello.
Do you have previous installations of MySQL server?
[1]+ Done ./mysqld_safe
What is in the error log? See:
http://dev.mysql.com/doc/mysql/en/starting-server.html
mandrake 10.1
mysql 4.1.10a
[EMAIL PROTECTED] bin]# ./mysql_install_db
Installing all prepared tables
mandrake 10.1
mysql 4.1.10a
[EMAIL PROTECTED] bin]# ./mysql_install_db
Installing all prepared tables
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-' for key 1
Fill help tables
angin continue next steup also error
[EMAIL PROTECTED] bin
Hello.
[EMAIL PROTECTED] scripts]# mysql_install_db --user=mysql
-bash: mysql_install_db: command not found
[EMAIL PROTECTED] scripts]# ./mysql_install_db --user=mysql
./mysql_install_db: line 86: my_print_defaults: command not found
Could not find help file 'fill_help_tables.sql
I´ve problems with mysql_install_db
I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10
release. I prove with other version of solaris like 9 or 8 and always is the
same result. The system
return a core file but give me none log error. One strange thing is that was
able
jose wrote:
I´ve problems with mysql_install_db
I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10
release. I prove with other version of solaris like 9 or 8 and always is the
same result. The system
return a core file but give me none log error. One strange thing
Hi All,
after experiencing trouble with the rpm install on Fedora3, I went with
the tar install. All went well, until I got to this part of the install
manual,
After you complete the procedure and have the server running, you should
assign passwords to the accounts created by *mysql_install_db
Hi all,
I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425
based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql
...It runs into several errors with the following log
[EMAIL PROTECTED]: /usr/local# ./bin/mysql_install_db --user=mysql
, December 16, 2004 8:28 PM
To: manasvini nandakumar
Cc: [EMAIL PROTECTED]
Subject: Re: mysql_install_db problem!!
manasvini nandakumar wrote:
Hi all,
I have cross compiled mysql-4.1.7 (from the source distribution)for an
IXP425 based board with Montavista Linux-3.0.When I run
mysql_install_db --user
Hi all,
Initially, I had also suspected an NFS problem,I tried the same process on a
local flash file system on the target board.It still yielded the same problems.
the mysql user has complete privileges on the directory (MYSQL's data
directory /usr/local/mysql/var/).I had also tested a sample
manasvini nandakumar wrote:
Hi all,
I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425
based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql
...It runs into several errors with the following log
[EMAIL PROTECTED]: /usr/local# ./bin
I'm on Linux and had to install the myself server since that didn't work
from the Linux install cd. When I run mysql_install_db I get host name
lookup failure . Please configure the hostname.
However in my Linux hosts table I DO have the localhost address. and if
I do resolveip localhost from
The easy way around this is to change your hostname to 'localhost,' install
the scripts, and then change your hostname back. There are other ways to
fixing this, but that's the fastest, I've found.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi Mickey and others,
Here is the location of the lxrun information.
ftp://ftp2.sco.com/pub/skunkware/emulators/lxrun-FAQ.html
This is for lxrun. MySQL does run in a native form on mysql and it uses
gcc. To build or run MySQL on OpenServer you need to install the
libraries and linker from
. Using --log
gives you a log in ./data 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
On Fri, 9 Apr 2004, Mickey wrote:
I am trying to install Mysql
(mysql-standard-4.0.18-pc-linux-i686.tar.gz) on my 'SCO_SV 3.2 5.0.5
i386' unix machine.
This is for linux. Do you have the lxrun installed? If you have lxrun
installed and updated to the lastest libraries then it will work. If
when running mysql_install_db
following the same instructions mentioned at the link above.
It does create the 'mysql' and 'test' directories in the data directory but
no files in either. (Although isn't 'test' empty at the start anyway?)
I feel like if I could get the mysq/ db tables set up I'd
The mysql_install_db script shipped with 4.1.1-alpha seems to leave
the mysql/* (user,host,etc.) tables owned root.root on my Debian
system; this makes mysqld fail to start after the grant tables are
installed.
It looks like this is because mysql_install_db calls mysqld with
--bootstrap
This is a new 4.0.17 source install on Panther, and this is as far as I
got.
sudo /usr/local/mysql/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
Got
hi,
i have built and installed mysql-4.0.14 to /usr/local/mysql and want to set
up initial grant tables now but mysql_install_db fails and I am lost.
What shall I do now?
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing
Hi,
When compiling MySQL with statically linking options (with glibc 2.3.1),
There weren't any errors during configure and compilation stages but
mysql_install_db was giving out a segmentation fault.
The list archives had suggested to give up statically linking libraries,
which worked fine
install'... But then I
go to run mysql_install_db (as root) and it segfaults. Output here:
shiro mysql-4.1.0-alpha # scripts/mysql_install_db
Installing privilege tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries
Dear Sir/Madam
i am trying to run mysql_install_db but my windows xp command prompt give me the
following error:
'mysql_install_db' is not recognized as an internal or external command, operable
program or batch file.
How can i run this line?
please help
thank you very much
Sandeep Sodhi
Sandeep Sodhi [EMAIL PROTECTED] wrote:
i am trying to run mysql_install_db but my windows xp command prompt give me the
following error:
'mysql_install_db' is not recognized as an internal or external command, operable
program or batch file.
How can i run this line?
You should
be safe.
I compiled GCC 2.95.3 on my system, compiled MySQL with using it but the
same problem resides with mysql_install_db.
I then noticed that this mailing list is also available through Google
Groups. The search I made was more efficient than the one I made on the
lists.mysql.com site. I found two
--with-client-ldflags=-all-static --without-innodb
The configure and the compilation reports no errors. When I run
mysql_install_db, it gives out a segmentation fault.
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Date: Tue, 22 Jul 2003 22:30:03 +0300
From: Doruk Fisek [EMAIL PROTECTED]
I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux 2.4.21
on a
-3.23.57-hp-hpux10.20-hppa mysql
shell cd mysql
shell scripts/mysql_install_db
# output from mysql_install_db --
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
, there is only one database in, which is 'test'. There suppose to have
mysql
in. I checked the manual, and find I should run scripts/mysql_install_db , I runed
but
then it show me
*
[Snow:/usr/local/mysql] richardb% chown: /usr/local/mysql/data/Snow.local..err
'. There suppose to
have mysql in. I checked the manual, and find I should run
scripts/mysql_install_db , I runed but then it show me
*
[Snow:/usr/local/mysql] richardb% chown: /usr/local/mysql/data/Snow.local..err:
Operation not permitted
Starting mysqld
in, which is 'test'. There suppose to
have mysql in. I checked the manual, and find I should run
scripts/mysql_install_db , I runed but then it show me
*
[Snow:/usr/local/mysql] richardb% chown:
/usr/local/mysql/data/Snow.local..err: Operation
# [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900:
Hi Roman,
just saw this by chance.
sockstat -4l | grep 3306.
I never heard of such a tool , also I did not find any info on the
internet. I assume you dont mean sock, of course.
Could you let me know where I can find the tool ?
Hi Roman,
I see, thank you. I guess that translates for me on a Linux system than to
netstat.
Best regards
Nils Valentin
Tokyo/Japan
2003 6 17 14:21Roman Neuhauser :
# [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900:
Hi Roman,
just saw this by chance.
sockstat -4l | grep 3306.
Description:
I've tried several times to get mysql to install on my linux box, to
no avail. Everytime, the mysql_install_db script hangs when it tries
to run mysqld. Running mysqld by hand hangs the same way as well. I've
seen over a dozen reports of this on the mysql mailing list in the last
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release: mysql-3.23.39
Description:
When I tried to start MySQL server with
shell/usr/bin/safe_mysqld
it gave me the error:
-
Starting mysqld daemon with databases from /var/lib/mysql
030128 08:56:42 mysqld ended
have look at http://www.mysql.com/doc/en/mysql_install_db.html
[EMAIL PROTECTED] wrote:
Description:
When I tried to start MySQL server with
shell/usr/bin/safe_mysqld
it gave me the error:
-
Starting
Hi!
Installing the latest MySQL 4 build on Mac OS X, I got a couple of
errors when running the mysql_install_db script (sudo
./scripts/mysql_install_db) from the mysql directory:
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
Description:
When i run scripts/mysql_install_db:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible
Hello,
I am having problems with mysql_install_db. I am running a bleeding-edge
Gentoo system (gcc 3.2.1 and glibc 2.3.1, both with some compatibility
patches. also running unpatched kernel 2.5.52).
MySQL compiles with no errors or problems, but mysql_install_db will not run
correctly
-static --without-bench --with-char-set=sjis
'CFLAGS=-O3 ' 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti'
'LDFLAGS= -s'
mysql_install_db show this message.
Some pointers may be invalid and cause the dump to abort...
thd-query at 0x82a7c50 = CREATE TABLE db ( Host char(60) binary
Description:
Bad system call received during mysql_install_db
How-To-Repeat:
I have tried installing the binary mysql-max-3.23.53a-dec-osf5.1-alphaev6 as
well
as compiling from the source code mysql-3.23.53-dec-osf5.1-alphaev6.
Perhaps I used the wrong code
Use the same query except replace
nvl((c.sr_num),0))
with
count(*)
John
Lance Prais wrote:
I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
Description:
Running the mysql_install_db or configure scripts fail to install
database tables. mysqld cannot find libgthreads.so even though it is
in /usr/local/lib. Script also complains that libc are not 100 %
compatible; I think I have the latest
I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
s_srv_req c
WHERE
a.sra_sr_id = c.row_id and
a.priv_flg = 'N' and
a.x_cp_created between
/usr/bin/mysql_install_db -IN-RPM
5741 pts/2S 0:00 /usr/sbin/mysqld --bootstrap
--skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --skip-innodb
--skip-gemini --skip-bdb
#netstat -lnp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN -
#
I have tried to install mysql from
-Original Message-
From: George Chelidze [mailto:wrath;geo.net.ge]
Sent: Tuesday, November 12, 2002 1:39 AM
To: [EMAIL PROTECTED]
Subject: mysql_install_db hangs
Hello,
One of my custommers use mysql database and a few days ago he asked me
to solve the strange problem with it. I don't know
Any suggestions?? I just installed and compiled mysql 3.23.53 and I get
this error:
[root@Alpha mysql-3.23.53]# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all
Any suggestions?? I just installed and compiled mysql 3.23.53 and I get
this error:
[root@Alpha mysql-3.23.53]# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all
-hpux10.20-hppa1.1.tar
4) cd mysql-3.23.53-hp-hpux10.20-hppa1.1
5) ./scripts/mysql_install_db
... and this is the output:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
: Saturday, October 19, 2002 6:34 AM
Subject: re: mysql_install_db script: can't find it
Randy,
Saturday, October 19, 2002, 4:23:31 AM, you wrote:
RG I've installed and re-installed MySQL on Windows (binary) multiple
times,
RG using multiple versions (3.x and 4.x). The reference manual
Randy,
Saturday, October 19, 2002, 4:23:31 AM, you wrote:
RG I've installed and re-installed MySQL on Windows (binary) multiple times,
RG using multiple versions (3.x and 4.x). The reference manual discusses a
RG script called mysql_install_db, in the /scripts folder. I can't for the
RG life
RG I've installed and re-installed MySQL on Windows (binary) multiple times,
RG using multiple versions (3.x and 4.x). The reference manual discusses a
RG script called mysql_install_db, in the /scripts folder. I can't for the
RG life of me find such a script anywhere on my machine.
RG Do I
Hello!
I've installed and re-installed MySQL on Windows (binary) multiple times,
using multiple versions (3.x and 4.x). The reference manual discusses a
script called mysql_install_db, in the /scripts folder. I can't for the
life of me find such a script anywhere on my machine.
Do I need to do
Description:
I have downloaded the binary mysql-3.23.52-hp-hpux10.20-hppa1.1.tar.gz grom mysql.com.
After unzipping it and create the symbolic link in /usr/local/, I executed the script
mysql_install_db. I receive the following message :
Preparing db table
Preparing host table
Preparing user
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I downloaded mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did gunzip to unzip the file and then did
gtar.
When i try to run mysql_install_db, i get the
following error
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I downloaded
mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did gunzip to unzip the file and then did
gtar.
When i try to run mysql_install_db, i get the
following error
downloaded
mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did gunzip to unzip the file and then did
gtar.
When i try to run mysql_install_db, i get the
following error :
***
***
***
ld.so
Description:
I am a new user to MySQL. When i try to create the MySQL grant tables, it does
not allow me to do that.
How-To-Repeat:
This is the error message that i get when i run mysql_install_db
*
ld.so.1
I'm trying to install MySQL on my Playstation 2 (mipsel-pc-linux-gnu,
apparently). For entertainment purposes, you understand. :)
It configures, compiles, and installs fine, but when I get to running
mysql_install_db, it gets a bit upset. Lots of error 1033.
Am I going to be able to get
From: Peter Lloyd [EMAIL PROTECTED]
To: script
Subject: No response from mysql; mysql_install_db freezes
Description:
I am following the installation instructions in the documentation, and after invoking
the script
'mysql_install_db', I see a few announcements, then nothing happens. I waited
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SUPPORT PLEASE - Error while running mysql_install_db
Description:
After installing successfully mysql in my sun solaris - sparc machine,
while i am trying to run the script mysql_install_db
system has given the following error
RRamasamymani,
Tuesday, May 07, 2002, 10:11:08 AM, you wrote:
R From: [EMAIL PROTECTED]
R To: [EMAIL PROTECTED]
R Subject: SUPPORT PLEASE - Error while running mysql_install_db
R Description:
R After installing successfully mysql in my sun solaris - sparc machine,
R while i am trying
directory `/src/mysql/mysql-3.23.49/bdb'
make: *** [info-recursive] Error 1
- mysql.build install = ok
- mysql.build initdb = ok, but
./scripts/mysql_install_db says :
Preparing db table
Preparing host table
Preparing user table
Preparing func table
'
make: *** [info-recursive] Error 1
- mysql.build install = ok
- mysql.build initdb = ok, but
./scripts/mysql_install_db says :
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing
[EMAIL PROTECTED]
To: Olivier Delrieu [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 1:27 PM
Subject: Re: mySQL under cygwin : mysql_install_db does not create host.frm
hi,
where are you running the server from?
you might wanna try running from the base dir
./bin
sorry, no effect, the deamon could not be started anyway as there is no mysql database
...
moreover, mysql_install_db lauch :
/usr/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/usr
--datadir=/var/mysql/data --skip-innodb --skip-gemini
--skip-bdb sql...
and the sql statement
- Original Message -
From: Chris Lamrock [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:21 AM
Subject: Re: mysql_install_db still locking :-(
Egor,
I'm running :
Red Hat Linux release 7.0 (Guinness)
on a Pentium III 450 with 128 meg of Ram
]
Sent: Tuesday, April 09, 2002 10:00 AM
Subject: Re: mysql_install_db still locking :-(
Chris,
Tuesday, April 09, 2002, 3:22:00 PM, you wrote:
CL Still having this trouble with mysql.. Running the mysql_install_db
renders
CL this...
CL Preparing db table
CL Preparing host table
CL
and this
is the most common situation, but I haven't heard of problems like this.
Can you reinstall Red Hat from scratch and try again?..
Thanks for the reply!
Chris
Chris,
Tuesday, April 09, 2002, 3:22:00 PM, you wrote:
CL Still having this trouble with mysql.. Running the mysql_install_db
Chris,
Tuesday, April 09, 2002, 3:22:00 PM, you wrote:
CL Still having this trouble with mysql.. Running the mysql_install_db renders
CL this...
CL Preparing db table
CL Preparing host table
CL Preparing user table
CL Preparing func table
CL Preparing tables_priv table
CL Preparing
Hi,
I'm having some trouble with mysql.. Running the mysql_install_db renders
this...
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
At this point the script locks
Chris,
Monday, April 08, 2002, 4:52:26 PM, you wrote:
CL I'm having some trouble with mysql.. Running the mysql_install_db renders
CL this...
CL Installing all prepared tables
CL At this point the script locks at this point won't go any further.
CL I am using
CL MySQL-3.23.49a-1.i386.rpm
Description:
mysql_install_db fails if ansi specified in my.cnf
Appears to be related to columns called User in mysql database.
How-To-Repeat:
install database; set ansi mode in my.cnf; run mysql_install_db
to rebuild security database
Fix
Found the fix!
What happened to me is I had used Winzip to unzip and untar the
files on a Win2000 machine, then copied those files to the
server. However, I found GNU tar, installed it, deleted my old
mysql directory, and used GNU tar to untar the file in
/usr/local. After that mysql_install_db
Unable to invoke mysql prompt after the trial download on sun solaris 2.8
Unix.
attaching the error which i got after running the
./scripts/mysql_install_db
--
./scripts/mysql_install_db
ld.so.1: ./bin/my_print_defaults: fatal: libz.so: open failed: No such file
or directory
WARNING
Description:
shr.o not found in libz.a when running mysql-install_db
How-To-Repeat:
Output from mysql_install_db:
root@cedar:/work/work/mysql/mysql-max-3.23.46-ibm-aix4.3.3.0-rs6000
scripts/mysql_install_db
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because
[EMAIL PROTECTED] writes:
Description:
shr.o not found in libz.a when running mysql-install_db
How-To-Repeat:
Output from mysql_install_db:
root@cedar:/work/work/mysql/mysql-max-3.23.46-ibm-aix4.3.3.0-rs6000
scripts/mysql_install_db
exec(): 0509-036 Cannot load program ./bin
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Mysql/Solaris: can't run configure or mysql_install_db
Chuck,
Friday, March 08, 2002, 5:56:59 PM, you wrote:
CR Hi. We have Solaris 2.8
: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Mysql/Solaris: can't run configure or mysql_install_db
Chuck,
Friday, March 08, 2002, 5:56:59 PM, you wrote:
CR Hi. We have Solaris 2.8 and just got Mysql 3.23.
We installed the
CR
Hi..
I had faced a similar problem with mysql_install_db..but i had downloaded the
source and done a make ..
I had to change the path of sh in the first line of the script
mysql_install_db..the default path of sh is /bin/sh. I had to change it to
/usr/bin/sh and did a make intall again and lo
1 - 100 of 173 matches
Mail list logo