Re: Can't start the mysql service on Solaris 8 ?

Dear all, Please help ! Thanks a lot ! Kevin > Kevin Chan Write: > Sent: Friday, March 07, 2003 12:36 PM > 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 cre

Re: Can't start the mysql service on Solaris 8 ?

again, Kevin > 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 : > > >

Can't start the mysql service on Solaris 8 ?

Dear all, 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'

Can't start the mysql service on Solaris 8 ?

Dear all, 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'

Re: How can run Mysql program from different user (NOT only root) ? (Solved !)

Dear Luke and all, Thanks Luke... my problem was solved ! Also, I would like to say thanks for all of you who try to help me before ! THANKS A LOT ! Thanks again! Best regards, Kevin Chan < Luke Wrote> > Sounds like you don't have permission to execute the file mysql in > /us

Re: How can run Mysql program from different user (NOT only root) ?

ocal lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql -> mysql-3.23.46-sun-solaris2.8-sparc drwxr-xr-x 13 root mysql512 Dec 5 16:30 mysql-3.23.46-sun-solaris2.8-sparc Please teach me what is the problem cause the error message "Permission denied" when not u

Re: How can run Mysql program from different user (NOT only root) ?

( Now only Unix box admin can run the MySQL program ). Does anyone can teach me how to solve my problem ? Thanks ! Thanks a again, Kevin Chan > Hi, > > Wasnt MySQL supposed to run as SU or ROOT or Administrator and > then create users within MySQL with restrictions? > > What yo

How can run Mysql program from different user (NOT only root) ?

ase teach me, what I should change to make the program can run from different user (NOT only root)? Thanks a lot ! Thanks ang regards, Kevin Chan - Before posting, please check: http://www.mysql.com/manual.php (the man

Re: Why I can't run Mysql program ? Please Help !

erent user to run MySQL (only root can run this program now) ? bash-2.03$ ./mysql --host=192.10.0.113 bash: ./mysql: Permission denied Thanks a lot, Kevin Chan > >Kevin, >If you have forgotten the root user password for MySQL, you can restore it with >the following procedure: >

Re: Why I can't run Mysql program ? Please Help !

Start slave stop-slaveStop slave variables Prints variables available version Get version info from server Does it mean MySQL server is running fine ? Thanks again, Kevin Chan Sent: Thursday, December 27, 2001 5:33 PM Subject: Re: Why I can&

Re: Why I can't run Mysql program ? Please Help !

o you know what's wrong ? Thanks a lot, Kevin Chan Sent: Thursday, December 27, 2001 4:09 PM Subject: Re: Why I can't run Mysql program ? Please Help ! > try command > netstat -an > to check if file socket is created. > >try > mysql -h sune250 >

Re: Why I can't run Mysql program ? Please Help !

:00 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld --defaults-extra-fi le= root 759 686 0 16:57:48 pts/10:00 grep mysql Sorry, I forget the password... how I can create the new one ? Thanks a lot, Kevin Chan Sent: Thursday, December 27, 2001 4:05 PM Subject: Re: Why I

Re: Why I can't run Mysql program ? Please Help !

r connections Would you mind to tell me what I must be change to solve the problem ? Thanks for your help! Thanks again, Kevin Chan Sent: Thursday, December 27, 2001 3:05 PM Subject: Re: Why I can't run Mysql program ? Please Help ! > Dear Marek and all, > > The directory f

Re: Why I can't run Mysql program ? Please Help !

Dear Marek and all, The directory for MySQL (/etc/local)as below: lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql -> mysql-3.23.46-sun-solaris2.8-sparc drwxr-xr-x 13 root mysql512 Dec 5 16:30 mysql-3.23.46-sun-solaris2.8-sparc Thanks and regards, Kevin Chan S

Re: Why I can't run Mysql program ? Please Help !

user=mysql & Thanks and regards, Kevin Chan Sent: Thursday, December 27, 2001 2:35 PM Subject: Re: Why I can't run Mysql program ? Please Help ! > Kevin Chan wrote: > > > Dear Michael and all, > > > > Hi Michael, do you mind to tell me where is the location of

Re: Why I can't run Mysql program ? Please Help !

Dear Michael and all, Hi Michael, do you mind to tell me where is the location of the my.cnf file in my michane (Sun Solaris2.8) beacuse I can't find it ? And what I should change on that file to solve the problem? ... thanks ! Thanks and regards, Kevin Chan Sent: Thursday, Decemb

Re: Why I can't run Mysql program ? Please Help !

figuration.Please Help and teach me to solve the problem... Thanks again. Thanks a lot ! Kevin Chan > >When MySQL is installed, a file mysql.sock is created. >Check for its existence. It should be in /var/lib/mysql directory. >If this file does not exist, try to restart the se