Hello.


> Operating system error number 13 in a file

>I check the permission on the files and directories.  The user 'mysql'

> and group 'mysql'  have access to the data directory and to the files.



Check that you really run the mysqld under the 'mysql' account. Have you

applied the patches as mentioned at:

  http://dev.mysql.com/doc/mysql/en/hp-ux-11-x.html

If you don't want to use InnoDB tables, launch the MySQL server with 

--skip-innodb command line option.





[snip]

I'm new to the mySql product.  I have installed the mySql binaries on my

HPUX machine and followed the instructions.



I tested that the command line 'mysql' is working and I can create

databases, users and import data. 





 

 

 I wrote a simple C program that does mysql_init(NULL) and then connects

 to the database.

 

 However, when the program executes the mysql_init function, I get the

 following error:

 

 >>> 

 

 InnoDB: Unable to lock

 /opt/mysql-standard-4.1.9-hp-hpux11.00-hppa2.0w/data/ibdata1, error: 13

 

 InnoDB: Check that you do not already have another mysqld process

 

 InnoDB: using the same InnoDB data or log files.

 

 InnoDB: Error in opening

 /opt/mysql-standard-4.1.9-hp-hpux11.00-hppa2.0w/data/ibdata1

 

 050207 17:22:12  InnoDB: Operating system error number 13 in a file

 operation.

 

 InnoDB: The error means mysqld does not have the access rights to

 

 InnoDB: the directory.

 

 InnoDB: Could not open or create data files.

 

 InnoDB: If you tried to add new data files, and it failed here,

 

 InnoDB: you should now edit innodb_data_file_path in my.cnf back

 

 InnoDB: to what it was, and remove the new ibdata files InnoDB created

 

 InnoDB: in this failed attempt. InnoDB only wrote those files full of

 

 InnoDB: zeros, but did not yet use them in any way. But be careful: do

 not

 

 InnoDB: remove old data files which contain your precious data!

 

 050207 17:22:12 [ERROR] Can't init databases

 

 <<<<< 

 

  

  

  I check the permission on the files and directories.  The user 'mysql'

  and group 'mysql'  have access to the data directory and to the files.

  

   

   

   Can someone direct my to a possible solution?

   

    

    

    [EMAIL PROTECTED] wrote:

 [snip]



-- 
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]

Reply via email to