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 create a user and data directory

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

, 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

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) ?

- 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 using root to run the MySQL program? Thanks ! Thanks again, Kevin Chan Steve

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 /usr/local/mysql/bin

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

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 Jaime Teng Wrote Hi, Wasnt MySQL supposed to run as SU or ROOT or Administrator and then create users within MySQL with restrictions? What you trying

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

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 Phillip B. Bruce Wrote 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 !

: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 Phillip B. Bruce Wrote Sent: Thursday, December 27, 2001 4:05 PM

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

what's wrong ? Thanks a lot, Kevin Chan Marek Zaradzki Wrote 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 - Original Message

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

Stop slave variables Prints variables available version Get version info from server Does it mean MySQL server is running fine ? Thanks again, Kevin Chan Marek Zaradzki Wrote Sent: Thursday, December 27, 2001 5:33 PM Subject: Re: Why I can't run Mysql program

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

and teach me to solve the problem... Thanks again. Thanks a lot ! Kevin Chan Durga Wrote 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 server and check for its existence

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 Michael Brunson Wrote Sent

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

-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/data shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin shell bin/safe_mysqld --user=mysql Thanks and regards, Kevin Chan Phillip

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 Marek

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

what I must be change to solve the problem ? Thanks for your help! Thanks again, Kevin Chan Marek Zaradzki Wrote 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 for MySQL (/etc/local)as below: lrwxrwxrwx