Re: Newbie Query: Error starting MySQL.

2005-11-19 Thread Gleb Paharenko
Hello.



Start points for you problem:

  http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

  http://dev.mysql.com/doc/refman/5.0/en/starting-server.html



 socket=/home.dbdata/mysql/mysql.sock



What is your client thinks about the location of mysqld socket?

Put the same line in [client] section of my.cnf.





Sanjay Arora wrote:

 Hi all

 

 First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2

 with MySQL 4.1.12, rpm install.

 

 Changed the data directory.

 

 My /etc/my.conf

 ---

 

 [mysqld]

 datadir=/home.dbdata/mysql

 socket=/home.dbdata/mysql/mysql.sock

 

 

 # Default to using old password format for compatibility with mysql 3.x

 # clients (those using the mysqlclient10 compatibility package).

 old_passwords=1

 

 [mysql.server]

 user=mysql

 basedir=/var/lib

 

 [mysqld_safe]

 err-log=/var/log/mysqld.log

 pid-file=/var/run/mysqld/mysqld.pid

 

 -

 -

 

 Ran these commands for permissions:

 chown -R mysql:mysql /home.dbdata/mysql

 chmod -R go-rwx  /home.dbdata/mysql

 

 Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT

 

 ps -aux shows that mysql is running though it reports failure instead of

 OK when I start it.

 

 Also when I stop myswl from commandline, it stops and shows OK, but

 cannot also connect to it.

 

 Checked the pid file mentioned in the my.cnf and it gets created and

 deleted when mysql starts  stops respectively.

 

 Please advise what is happening and what step I have taken wrong and

 what to do to correct it. Am a newbie but can follow instructions.

 Please help.

 

 With best regards.

 Sanjay.

 

 

 

 

 

 

 

 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Newbie Query: Error starting MySQL.

2005-11-17 Thread Sanjay Arora
Hi all

First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.

Changed the data directory.

My /etc/my.conf
---

[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock


# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

-
-

Ran these commands for permissions:
chown -R mysql:mysql /home.dbdata/mysql
chmod -R go-rwx  /home.dbdata/mysql

Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT

ps -aux shows that mysql is running though it reports failure instead of
OK when I start it.

Also when I stop myswl from commandline, it stops and shows OK, but
cannot also connect to it.

Checked the pid file mentioned in the my.cnf and it gets created and
deleted when mysql starts  stops respectively.

Please advise what is happening and what step I have taken wrong and
what to do to correct it. Am a newbie but can follow instructions.
Please help.

With best regards.
Sanjay.









-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Newbie Query: Error starting MySQL..changed Data Directory

2005-11-15 Thread Sanjay Arora
Hi all

First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.

Changed the data directory.

My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock


# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Ran these commands for permissions:
chown -R mysql:mysql /home.dbdata/mysql
chmod -R go-rwx  /home.dbdata/mysql

Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT

ps -aux shows that mysql is running

0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pidmysql
6184  0.2  3.4 125808 17636 pts/0  Sl   15:47   0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usrroot  6336  0.0  0.1  2920
744 pts/0R+   15:57   0:00 ps -aux

Log shows
051114 14:51:07  mysqld started
051114 14:51:08  InnoDB: Started; log sequence number 0 43634
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12'  socket: '/home.dbdata/mysql/mysql.sock'  port: 3306
Source distribution
051114 15:47:06 [Note] /usr/libexec/mysqld: Normal shutdown

051114 15:47:06  InnoDB: Starting shutdown...
051114 15:47:09  InnoDB: Shutdown completed; log sequence number 0 43634
051114 15:47:09 [Note] /usr/libexec/mysqld: Shutdown complete

051114 15:47:09  mysqld ended

051114 15:47:33  mysqld started
051114 15:47:33  InnoDB: Started; log sequence number 0 43634
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12'  socket: '/home.dbdata/mysql/mysql.sock'  port: 3306
Source distribution


Please advise what I have done wrong. I suspect permissions /or
incorrect data directory migration. Please help.

With regards.
Sanjay.






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Newbie Query: Error starting MySQL..changed Data Directory

2005-11-15 Thread Sujay Koduri

Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT
 
This doesn't nesessarily mean that mysql hasn't started. This script waits
only for certain time to check if mysql has started or not. If it is not
started in that time, it simply says 'mysql start failed'. But mysql may
take some more time to come up. So the best practice is to have a look at
the logs (as you rightly did) to find out what exactly is going on.
And your logs anyway are saying /usr/libexec/mysqld: ready for
connections.. This means that mysql has started without any problems and
waiting for connections. 

ps -aux shows that mysql is running

And for the same reason I mentioned above, you are seeing this.

Hope this helps.

sujay

-Original Message-
From: Sanjay Arora [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 14, 2005 4:46 PM
To: MySql Mailing List
Subject: Newbie Query: Error starting MySQL..changed Data Directory

Hi all

First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.

Changed the data directory.

My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock


# Default to using old password format for compatibility with mysql 3.x #
clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Ran these commands for permissions:
chown -R mysql:mysql /home.dbdata/mysql
chmod -R go-rwx  /home.dbdata/mysql

Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT

ps -aux shows that mysql is running

0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pidmysql
6184  0.2  3.4 125808 17636 pts/0  Sl   15:47   0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usrroot  6336  0.0  0.1  2920
744 pts/0R+   15:57   0:00 ps -aux

Log shows
051114 14:51:07  mysqld started
051114 14:51:08  InnoDB: Started; log sequence number 0 43634
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12'  socket: '/home.dbdata/mysql/mysql.sock'  port: 3306
Source distribution
051114 15:47:06 [Note] /usr/libexec/mysqld: Normal shutdown

051114 15:47:06  InnoDB: Starting shutdown...
051114 15:47:09  InnoDB: Shutdown completed; log sequence number 0 43634
051114 15:47:09 [Note] /usr/libexec/mysqld: Shutdown complete

051114 15:47:09  mysqld ended

051114 15:47:33  mysqld started
051114 15:47:33  InnoDB: Started; log sequence number 0 43634
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12'  socket: '/home.dbdata/mysql/mysql.sock'  port: 3306
Source distribution


Please advise what I have done wrong. I suspect permissions /or incorrect
data directory migration. Please help.

With regards.
Sanjay.






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: error starting mysql 4.1.7 cannot create/write to /root/tmp

2004-11-19 Thread Gleb Paharenko
Hello.



You may specify location of temp files with 'tmpdir' server system variable.

See:

  http://dev.mysql.com/doc/mysql/en/Temporary_files.html

  http://dev.mysql.com/doc/mysql/en/Server_system_variables.html





Gail Lange [EMAIL PROTECTED] wrote:

 Hello

I have just installed mysql 4.1.7 on Mandrake 10.0 (final).

 All went smoothly.

 However, when I issue the following command:

   /usr/local/mysql/bin/mysqld_safe --user=mysql 

 I get the error:

   Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)

 When I examine the error file in /usr/local/mysql/var it says it cannto 

 read /root and it

 cannot write to /root/tmp

 If I give others (beside root) r permission to /root and rw 

 permissions to /root/tmp,

 it start up fine.

I have looked as startup options for the mysqld_safe as well as 

 the /etc/my.cnf file but have not found anyway to alter where it wants 

 to write its temp files.

 

   Can anyone please help?

 Thanks,

Gail

 

 

 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



error starting mysql 4.1.7 cannot create/write to /root/tmp

2004-11-18 Thread Gail Lange
Hello
   I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
However, when I issue the following command:
  /usr/local/mysql/bin/mysqld_safe --user=mysql 
I get the error:
  Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
When I examine the error file in /usr/local/mysql/var it says it cannto 
read /root and it
cannot write to /root/tmp
If I give others (beside root) r permission to /root and rw 
permissions to /root/tmp,
it start up fine.
   I have looked as startup options for the mysqld_safe as well as 
the /etc/my.cnf file but have not found anyway to alter where it wants 
to write its temp files.

  Can anyone please help?
Thanks,
   Gail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


error starting mysql 4.1.7 cannot create/write to /root/tmp

2004-11-18 Thread Gail Lange
Hello
  I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
   However, when I issue the following command:
 /usr/local/mysql/bin/mysqld_safe --user=mysql 
I get the error:
 Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
When I examine the error file in /usr/local/mysql/var it says it cannto 
read /root and it
cannot write to /root/tmp
   If I give others (beside root) r permission to /root and rw 
permissions to /root/tmp,
it start up fine.
  I have looked as startup options for the mysqld_safe as well as 
the /etc/my.cnf file but have not found anyway to alter where it wants 
to write its temp files.

 Can anyone please help?
Thanks,
  Gail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


RE: error starting mysql 4.1.7 cannot create/write to /root/tmp

2004-11-18 Thread Dathan Vance Pattishall
perror 13
System error:  13 = Permission denied


The mysql user cannot read the /root filesystem.


DVP

Dathan Vance Pattishall http://www.friendster.com


 -Original Message-
 From: Gail Lange [mailto:[EMAIL PROTECTED]
 Sent: Thursday, November 18, 2004 10:23 AM
 To: [EMAIL PROTECTED]
 Subject: error starting mysql 4.1.7 cannot create/write to /root/tmp
 
 Hello
I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
 All went smoothly.
 However, when I issue the following command:
   /usr/local/mysql/bin/mysqld_safe --user=mysql 
 I get the error:
   Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
 When I examine the error file in /usr/local/mysql/var it says it cannto
 read /root and it
 cannot write to /root/tmp
 If I give others (beside root) r permission to /root and rw
 permissions to /root/tmp,
 it start up fine.
I have looked as startup options for the mysqld_safe as well as
 the /etc/my.cnf file but have not found anyway to alter where it wants
 to write its temp files.
 
   Can anyone please help?
 Thanks,
Gail
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Error Starting MySQL 4.0.21

2004-10-22 Thread Egor Egorov
Jason Williard [EMAIL PROTECTED] wrote:

 I have a new linux server that I just installed the
 mysql-max-4.0.21-pc-linux-i686 binary on.  The installation had no errors.
 However, it is not starting on startup because of the following error:
 
  Can't execute ./bin/mysqld_safe from dir /var/lib
 
 I can start MySQL manually running '/usr/local/mysql/bin/mysqld_safe '.
 
 Does anyone know why I am getting this error message?  

Because you have to start it using the full path: 
/usr/local/mysql/bin/mysqld_safe 

If you are running rpm-based linux, better take the RPM version.





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Error Starting MySQL 4.0.21

2004-10-20 Thread Jason Williard
I have a new linux server that I just installed the
mysql-max-4.0.21-pc-linux-i686 binary on.  The installation had no errors.
However, it is not starting on startup because of the following error:

  Can't execute ./bin/mysqld_safe from dir /var/lib

I can start MySQL manually running '/usr/local/mysql/bin/mysqld_safe '.

Does anyone know why I am getting this error message?  


Thank You,
Jason Williard
PCSafe, Inc.
 
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



error starting mysql

2002-03-07 Thread Norman Zhang

Hi,

I assigned rights to a user in mysql,

mysql grant all on books.* to bookorama@localhost identified by
'bookorama123';

Then I tried to access mysql in as a regular user,

[bookorama@a177 bookorama]$ mysql -u bookorama books -p;
Enter password: bookorama123

And I get the following error message,

ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password:
YES)

Would someone please help me how to troubleshoot this?

Thanks,
Norman



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: error starting mysql

2002-03-07 Thread Charles Quesenberry

My last email was technically correct, but not the root of your 
problem.  Please accept my humble apologies.

The answer to your problem is in the MySQL book by Paul DuBois, on page 
429.  If you do not have the book (and I highly recommend it), I will 
summarize.

This situation happens if your grant tables contain the default entries 
installed by the mysql_install_db initialization script.  It is caused by 
having anonymous users in your user table in the mysql database.  And, 
it only manifests itself when you are attempting to connect via the localhost.

To correct this problem, do this:

% mysql -u root mysql
mysql DELETE FROM user where User=;
mysql FLUSH PRIVILEGES;


If you have assigned a password to the root user (as I have done), you will 
have to do this:
% mysql -u root -p mysql
mysql DELETE FROM user where User=;
mysql FLUSH PRIVILEGES;


Again, sorry about my last email.


Sincerely,
Charles Quesenberry




At 02:13 PM 3/7/2002 -0800, you wrote:
Hi,

I assigned rights to a user in mysql,

mysql grant all on books.* to bookorama@localhost identified by
'bookorama123';

Then I tried to access mysql in as a regular user,

[bookorama@a177 bookorama]$ mysql -u bookorama books -p;
Enter password: bookorama123

And I get the following error message,

ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password:
YES)

Would someone please help me how to troubleshoot this?

Thanks,
Norman



-
Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: error starting mysql

2002-03-07 Thread Ken Anderson

If you are on RedHat, you might need to do mysql grant all on books.*
to [EMAIL PROTECTED] identified by 'bookorama123';

Ken


Norman Zhang wrote:
 
 Hi,
 
 I assigned rights to a user in mysql,
 
 mysql grant all on books.* to bookorama@localhost identified by
 'bookorama123';
 
 Then I tried to access mysql in as a regular user,
 
 [bookorama@a177 bookorama]$ mysql -u bookorama books -p;
 Enter password: bookorama123
 
 And I get the following error message,
 
 ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password:
 YES)
 
 Would someone please help me how to troubleshoot this?
 
 Thanks,
 Norman
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




error starting mysql

2001-11-01 Thread Jean Bernard

i have installed MySQL on W2000
my my.ini is :

[mysqld]
basedir=C:/MySQL
#bind-address=192.168.0.1
datadir=C:/MySQL/data
#language=C:/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
innodb_data_home_dir = c:/IbData
innodb_data_file_path = ibdata1:200M
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:/iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:/iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=30M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

when i run  mysqld-max-nt --console
i have the error message:
InnoDB: operating system error number 5 in a file operation.
InnoDB: operating system error number 5 in a file operation.
InnoDB: Error in creating or opening c:\IbData\ibdata1
InnoDB: Could not open data files
011101 11:21:53 Can't init databases

???



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: error starting mysql

2001-11-01 Thread Heikki Tuuri

Hi!

I looked from the MS Developer Studio manual:

Code  Description  Name

2 The system cannot find the file specified.  ERROR_FILE_NOT_FOUND
3 The system cannot find the path specified.  ERROR_PATH_NOT_FOUND
4 The system cannot open the file.  ERROR_TOO_MANY_OPEN_FILES
5 Access is denied.  ERROR_ACCESS_DENIED

Maybe you should log in to your Win2000
computer as the Administrator?

when i run  mysqld-max-nt --consolei have the error message:
InnoDB: operating system error number 5 in a file operation.
InnoDB: operating system error number 5 in a file operation.
InnoDB: Error in creating or opening c:\IbData\ibdata1
InnoDB: Could not open data files011101 11:21:53 Can't init databases

Regards,

Heikki
http://www.innodb.com/ibman.html




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: error starting mysql

2001-11-01 Thread Jean Bernard

i log administrator
i have created the directory c:\ibdata\ibdata1
same error..
Regards,
Jean
- Original Message - 
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001 10:59 AM
Subject: Re: error starting mysql


 Hi!
 
 I looked from the MS Developer Studio manual:
 
 Code  Description  Name
 
 2 The system cannot find the file specified.  ERROR_FILE_NOT_FOUND
 3 The system cannot find the path specified.  ERROR_PATH_NOT_FOUND
 4 The system cannot open the file.  ERROR_TOO_MANY_OPEN_FILES
 5 Access is denied.  ERROR_ACCESS_DENIED
 
 Maybe you should log in to your Win2000
 computer as the Administrator?
 
 when i run  mysqld-max-nt --consolei have the error message:
 InnoDB: operating system error number 5 in a file operation.
 InnoDB: operating system error number 5 in a file operation.
 InnoDB: Error in creating or opening c:\IbData\ibdata1
 InnoDB: Could not open data files011101 11:21:53 Can't init databases
 
 Regards,
 
 Heikki
 http://www.innodb.com/ibman.html
 
 
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: error starting mysql

2001-11-01 Thread Heikki Tuuri

Hi!

At 01:50 PM 11/1/01 -, you wrote:
i log administrator
i have created the directory c:\ibdata\ibdata1

Ok, that explains the error: ibdata1 should be
a file.

If you have a directory of the same name
'ibdata1', then Windows tries to open a DIRECTORY
for reading, which does not succeed, of course.

Make sure you have directories

C:\ibdata

and

C:\iblogs

but no subdirectories to these.

Regards,

Heikki

same error..
Regards,
Jean
- Original Message - 
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001 10:59 AM
Subject: Re: error starting mysql


 Hi!
 
 I looked from the MS Developer Studio manual:
 
 Code  Description  Name
 
 2 The system cannot find the file specified.  ERROR_FILE_NOT_FOUND
 3 The system cannot find the path specified.  ERROR_PATH_NOT_FOUND
 4 The system cannot open the file.  ERROR_TOO_MANY_OPEN_FILES
 5 Access is denied.  ERROR_ACCESS_DENIED
 
 Maybe you should log in to your Win2000
 computer as the Administrator?
 
 when i run  mysqld-max-nt --consolei have the error message:
 InnoDB: operating system error number 5 in a file operation.
 InnoDB: operating system error number 5 in a file operation.
 InnoDB: Error in creating or opening c:\IbData\ibdata1
 InnoDB: Could not open data files011101 11:21:53 Can't init databases
 
 Regards,
 
 Heikki
 http://www.innodb.com/ibman.html
 
 
 





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Error starting mysql server

2001-06-12 Thread Sinisa Milivojevic

Weining Zhao writes:
 Hello,
 
 I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 
workstation.  When I started mysql server with safe_mysqld, I got following error 
message:
 
 
 
 Start MySQL server deamon
 exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because 
of the following errors:
0509-150   Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded.
0509-152   Member shr.o is not found in archive 
 010608 10:54:45  mysqld ended
 
 
 
 The zlib installed on the workstation is version 1.1.3. 
 
 Can anyone tell me what wrong here? what is this shr.o? Did I miss something?
 
 Thanks.
 
 Weining
 


Hi!

Just go to ftp.gnu.org and download zlib source. Build it and install
it on AIX.

Also, can you tell me what for are you using MySQL at your
institution.


-- 

Regards,

For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Error starting mysql server

2001-06-11 Thread Weining Zhao

Hello,

I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 
workstation.  When I started mysql server with safe_mysqld, I got following error 
message:



Start MySQL server deamon
exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of 
the following errors:
   0509-150   Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded.
   0509-152   Member shr.o is not found in archive 
010608 10:54:45  mysqld ended



The zlib installed on the workstation is version 1.1.3. 

Can anyone tell me what wrong here? what is this shr.o? Did I miss something?

Thanks.

Weining



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php