Re: Basic RPM installation?
Ben Goswami wrote: > Since mySQL at this time does not support sub query, Do I've to break this > into 2 SQLs and process: > > select question_id from questions where abs_sort_order in (select > min(a.abs_sort_order) from questions a where a.abs_sort_order > 1) > > Ben > select question_id from questions where abs_sort_order>1 order by abs_sort_order limit 1 should do it (and run fast if there is an index on abs_sort_order). BTW, what does your question have to do with "Bsic RPM installation" ? Regards -- Joseph Bueno - 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
Re: Basic RPM installation?
Since mySQL at this time does not support sub query, Do I've to break this into 2 SQLs and process: select question_id from questions where abs_sort_order in (select min(a.abs_sort_order) from questions a where a.abs_sort_order > 1) Ben - Original Message - From: "DeNewbie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 28, 2002 8:03 AM Subject: Basic RPM installation? > > In my first posting I had the following problem; > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > > [1] 1759 > > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission denied > > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > > Please remove it manually and start /usr/bin/safe_mysqld again > > mysqld daemon not started > > > > > I removed the cords-orj86jfje.err file from /var/lib/mysql/cords-orj86jfje.err and I performed the mysql_install_db script all over again, now I have this problem in that I get the same response even after removing the cords-orj86jfje.err file. > > > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1059 > mike@cords-orj86jfje:/usr/bin> Starting mysqld daemon with databases from /var/lib/mysql > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied > 020928 10:47:57 mysqld ended > tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied > > > [1]+ Exit 1 safe_mysqld > mike@cords-orj86jfje:/usr/bin> cd /var/lib/mysql > mike@cords-orj86jfje:/var/lib/mysql> ls > mysql test > mike@cords-orj86jfje:/var/lib/mysql> ls -l > total 1 > drwx--x--x2 mysqlroot 506 Sep 2 14:20 mysql > drwxr-xr-x2 mysqlroot 35 Sep 2 14:20 test > > > > I have the safe_mysql in my /usr/bin but I get this; > > > > > mike@cords-orj86jfje:~> cd /usr/bin > mike@cords-orj86jfje:/usr/bin> safe_mysql & > [1] 1118 > bash: safe_mysql: command not found > [1]+ Exit 127safe_mysql > mike@cords-orj86jfje:/usr/bin> ls safe* > safe-rm safe_mysqld > mike@cords-orj86jfje:/usr/bin> su > Password: > cords-orj86jfje:/usr/bin # safe_mysql & > [1] 1126 > bash: safe_mysql: command not found > [1]+ Exit 127safe_mysql > cords-orj86jfje:/usr/bin # > > > > > What do I do from here ??? > > Thanks, DeNewbie > > - > 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 > > - 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
Re: Basic RPM installation?
Hi, You indeed have to su to root to get things working. safe_mysqld & as root didn't work because your PATH environment wasn't correctly set because you didn't use this: su - su - makes the new shell the user's login shell, resetting environment variables and reading configuration files to re-set them correctly. With su - it will work as expected. You would have got it working with this, though: /usr/bin/safe_mysqld & or ./safe_mysqld & when you were in /usr/bin. Best regards, Iikka On Sat, 28 Sep 2002, DeNewbie wrote: > > In my first posting I had the following problem; > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > > [1] 1759 > > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission >denied > > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > > Please remove it manually and start /usr/bin/safe_mysqld again > > mysqld daemon not started > > > > > I removed the cords-orj86jfje.err file from /var/lib/mysql/cords-orj86jfje.err and I >performed the mysql_install_db script all over again, now I have this problem in that >I get the same response even after removing the cords-orj86jfje.err file. > > > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1059 > mike@cords-orj86jfje:/usr/bin> Starting mysqld daemon with databases from >/var/lib/mysql > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied > 020928 10:47:57 mysqld ended > tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied > > > [1]+ Exit 1 safe_mysqld > mike@cords-orj86jfje:/usr/bin> cd /var/lib/mysql > mike@cords-orj86jfje:/var/lib/mysql> ls > mysql test > mike@cords-orj86jfje:/var/lib/mysql> ls -l > total 1 > drwx--x--x2 mysqlroot 506 Sep 2 14:20 mysql > drwxr-xr-x2 mysqlroot 35 Sep 2 14:20 test > > > > I have the safe_mysql in my /usr/bin but I get this; > > > > > mike@cords-orj86jfje:~> cd /usr/bin > mike@cords-orj86jfje:/usr/bin> safe_mysql & > [1] 1118 > bash: safe_mysql: command not found > [1]+ Exit 127safe_mysql > mike@cords-orj86jfje:/usr/bin> ls safe* > safe-rm safe_mysqld > mike@cords-orj86jfje:/usr/bin> su > Password: > cords-orj86jfje:/usr/bin # safe_mysql & > [1] 1126 > bash: safe_mysql: command not found > [1]+ Exit 127safe_mysql > cords-orj86jfje:/usr/bin # > > > > > What do I do from here ??? > > Thanks, DeNewbie > > - > 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 > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
Basic RPM installation?
In my first posting I had the following problem; > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1759 > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission >denied > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > Please remove it manually and start /usr/bin/safe_mysqld again > mysqld daemon not started I removed the cords-orj86jfje.err file from /var/lib/mysql/cords-orj86jfje.err and I performed the mysql_install_db script all over again, now I have this problem in that I get the same response even after removing the cords-orj86jfje.err file. mike@cords-orj86jfje:/usr/bin> safe_mysqld & [1] 1059 mike@cords-orj86jfje:/usr/bin> Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied 020928 10:47:57 mysqld ended tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied [1]+ Exit 1 safe_mysqld mike@cords-orj86jfje:/usr/bin> cd /var/lib/mysql mike@cords-orj86jfje:/var/lib/mysql> ls mysql test mike@cords-orj86jfje:/var/lib/mysql> ls -l total 1 drwx--x--x2 mysqlroot 506 Sep 2 14:20 mysql drwxr-xr-x2 mysqlroot 35 Sep 2 14:20 test I have the safe_mysql in my /usr/bin but I get this; mike@cords-orj86jfje:~> cd /usr/bin mike@cords-orj86jfje:/usr/bin> safe_mysql & [1] 1118 bash: safe_mysql: command not found [1]+ Exit 127safe_mysql mike@cords-orj86jfje:/usr/bin> ls safe* safe-rm safe_mysqld mike@cords-orj86jfje:/usr/bin> su Password: cords-orj86jfje:/usr/bin # safe_mysql & [1] 1126 bash: safe_mysql: command not found [1]+ Exit 127safe_mysql cords-orj86jfje:/usr/bin # What do I do from here ??? Thanks, DeNewbie - 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
Re: Basic RPM Installation
On Fri, 2002-09-27 at 19:27, DeNewbie wrote: > > I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to >use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to >install these RPM files. > > MySQL-3.23.52-1.i386.rpm > MySQL-client-3.23.52-1.i386.rpm > MySQL-devel-3.23.52-1.i386.rpm > > They all installed successfully; > > Then from /usr/local I ran mysql_install_db and I got this; > > > > cords-orj86jfje:/usr/local # mysql_install_db > Installing all prepared tables > 020927 18:06:15 /usr/sbin/mysqld: Shutdown Complete > > > To start mysqld at boot time you have to copy support-files/mysql.server > to the right place for your system > > PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > This is done with: > /usr/bin/mysqladmin -u root password 'new-password' > /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' > See the manual for more instructions. > > NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run > the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be > able to use the new GRANT command! > > You can start the MySQL daemon with: > cd / ; /usr/bin/safe_mysqld & > > You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: > cd sql-bench ; run-all-tests > > Please report any problems with the /usr/bin/mysqlbug script! > > The latest information about MySQL is available on the web at > http://www.mysql.com > Support MySQL by buying support/licenses at https://order.mysql.com > > > > > Now at this point what do I do ?? > > I put in my passwords successfully but when I entered the > "safe_mysqld &" I got this; > > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1759 > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission >denied > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > Please remove it manually and start /usr/bin/safe_mysqld again > mysqld daemon not started >From the sounds of it you must remove those files as root since mysql is the owner of them. John Coder - 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
Re: Basic RPM Installation
Did you install from the SuSE CD? If so then you have to tell YaST to start MySQL. You can start it from /etc/rc.d/mysql. If you want to use PHP you will need to tell YaST to install PHP for apache as well. SuSE has made running MySQL and PHP so easy by using YaST. Also run YaST to update PHP there been an update on 7.3. If you need any more help. Let me know I have used SuSE since 5.3 and I am currently on 8.0. Chuck Payne On 9/27/02 7:27 PM, "DeNewbie" <[EMAIL PROTECTED]> wrote: > > I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how > to use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am > trying to install these RPM files. > > MySQL-3.23.52-1.i386.rpm > MySQL-client-3.23.52-1.i386.rpm > MySQL-devel-3.23.52-1.i386.rpm > > They all installed successfully; > > Then from /usr/local I ran mysql_install_db and I got this; > > > > cords-orj86jfje:/usr/local # mysql_install_db > Installing all prepared tables > 020927 18:06:15 /usr/sbin/mysqld: Shutdown Complete > > > To start mysqld at boot time you have to copy support-files/mysql.server > to the right place for your system > > PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > This is done with: > /usr/bin/mysqladmin -u root password 'new-password' > /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' > See the manual for more instructions. > > NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run > the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be > able to use the new GRANT command! > > You can start the MySQL daemon with: > cd / ; /usr/bin/safe_mysqld & > > You can test the MySQL daemon with the benchmarks in the 'sql-bench' > directory: > cd sql-bench ; run-all-tests > > Please report any problems with the /usr/bin/mysqlbug script! > > The latest information about MySQL is available on the web at > http://www.mysql.com > Support MySQL by buying support/licenses at https://order.mysql.com > > > > > Now at this point what do I do ?? > > I put in my passwords successfully but when I entered the > "safe_mysqld &" I got this; > > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1759 > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: > Permission denied > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > Please remove it manually and start /usr/bin/safe_mysqld again > mysqld daemon not started > > > > What do I do from here ??? > > Thanks, DeNewbie > > - > 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 > > - 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
Basic RPM Installation
-- Forwarded message -- Date: Fri, 27 Sep 2002 19:27:22 -0400 From: DeNewbie <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Basic RPM Installation > > I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to >use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to >install these RPM files. > > MySQL-3.23.52-1.i386.rpm > MySQL-client-3.23.52-1.i386.rpm > MySQL-devel-3.23.52-1.i386.rpm > > They all installed successfully; > > Then from /usr/local I ran mysql_install_db and I got this; > > > > cords-orj86jfje:/usr/local # mysql_install_db > Installing all prepared tables > 020927 18:06:15 /usr/sbin/mysqld: Shutdown Complete > > > To start mysqld at boot time you have to copy support-files/mysql.server > to the right place for your system > > PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > This is done with: > /usr/bin/mysqladmin -u root password 'new-password' > /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' > See the manual for more instructions. > > NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run > the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be > able to use the new GRANT command! > > You can start the MySQL daemon with: > cd / ; /usr/bin/safe_mysqld & > > You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: > cd sql-bench ; run-all-tests > > Please report any problems with the /usr/bin/mysqlbug script! > > The latest information about MySQL is available on the web at > http://www.mysql.com > Support MySQL by buying support/licenses at https://order.mysql.com > > > > > Now at this point what do I do ?? > > I put in my passwords successfully but when I entered the > "safe_mysqld &" I got this; > > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1759 > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission >denied > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > Please remove it manually and start /usr/bin/safe_mysqld again > mysqld daemon not started > > > > What do I do from here ??? > > Thanks, DeNewbie - 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
Basic RPM Installation
I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to install these RPM files. MySQL-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm MySQL-devel-3.23.52-1.i386.rpm They all installed successfully; Then from /usr/local I ran mysql_install_db and I got this; cords-orj86jfje:/usr/local # mysql_install_db Installing all prepared tables 020927 18:06:15 /usr/sbin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd / ; /usr/bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Now at this point what do I do ?? I put in my passwords successfully but when I entered the "safe_mysqld &" I got this; mike@cords-orj86jfje:/usr/bin> safe_mysqld & [1] 1759 mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission denied rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied Please remove it manually and start /usr/bin/safe_mysqld again mysqld daemon not started What do I do from here ??? Thanks, DeNewbie - 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
