Re: Mysql on panther

[Paul DuBois]

At 8:04 -0800 11/6/03, Nestor Florez wrote:
Egor,

Where is the datadir locate?

:-)
The message below says:

 > Starting mysqld daemon with databases from /var/mysql
Which indicates that /var/mysql is the datadir.  Change location
into the directory and have a look around.  Try "ls -la ." to see
what the ownerships are.  You should also find a subdirectory named
"mysql", which is where the grant tables are.
Nestor A. Florez


 Egor Egorov <[EMAIL PROTECTED]> 11/6/2003 7:40:28 AM >>>
"Nestor Florez" <[EMAIL PROTECTED]> wrote:
 I tried running mysql_install_db and I get:
 *-----------------------
 # /usr/bin/mysql_install_db --force
 Preparing db table
 Preparing host table
 Preparing user table
 Preparing func table
 Preparing tables_priv table
 Preparing columns_priv table
 Installing all prepared tables
 031106  7:19:56  /usr/libexec/mysqld: Shutdown Complete
 *-----------------------
 Then I tried running=20
 *-------------------------
 #  /usr/bin/mysqld_safe
 > Starting mysqld daemon with databases from /var/mysql
 > 031106 07:23:11  mysqld ended
 *-------------------------
 I still get the error on the /var/mysql/'hostname.err' file
 *----------------------
 031106 07:23:08  mysqld started
 031106  7:23:09  InnoDB: Started
 031106  7:23:09  Fatal error: Can't open privilege tables: Can't find
=
 file: './mysql/host.frm' (errno: 13)
 031106  7:23:09  Aborting
 031106  7:23:09  InnoDB: Starting shutdown...
 031106  7:23:11  InnoDB: Shutdown completed
 031106  7:23:11  /usr/libexec/mysqld: Shutdown Complete
 031106 07:23:11  mysqld ended
 *----------------------
 Any other ideas?

perror 13
Error code  13:  Permission denied
MySQL should be owner of the data dir.


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

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