Dear Smith, Dave, Clark and Victoria: Thanks for all of your reply as quick !
Because I am a neewbie on MYSQL, would you mind to teach me how to create a user and data directory on mysql server ? Below are the mysql directorys on my server, and I can't find the data directory. (Does it must be automatically create a data directory when I installing the mysql program ???) # pwd /usr/local/mysql # ls bin include lib man share var doc info libexec mysql-test sql-bench # Please try to teach me to solve this problem ! Thanks again, Kevin <Victoria Reznichenko Wrote:> > On Thursday 06 March 2003 10:36, Kevin Chan wrote: > > > I was downloaded the " mysql-3.23.53-sol8-sparc-local.gz " from > > www.sunfreeware.com . But I don't know why I got the following error when > > I start the mysql service : > > > > 030306 16:10:14 mysqld started > > 030306 16:10:16 /usr/local/mysql/libexec/mysqld: Can't find file: > > './mysql/host > > .frm' (errno: 13) > > 030306 16:10:16 /usr/local/mysql/libexec/mysqld: Normal shutdown > > > > Please teach me to solve this problem ! > > $ perror 13 > Error code 13: Permission denied > > MySQL should be owner of the datadir. Change owner of the datadir by > > chown -R mysql:mysql /path/to/the/mysql/data/dir > --------------------------------------------------------------------- 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