RE: Installation Question
Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation Question
-Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 12:16 PM À : '[EMAIL PROTECTED]' Objet : RE: Installation Question Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! It is not optimized. It is optimizeable, not the same thing. However, you need to know exacly what are the compiler flags to optimize it. If you run on x86, you are better of with the binary or the .rpm. No offense, but people who compile at mysql are a lot better than you and me to get the best flags. hth Ugo Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Question
I second Ugo's opinion. dan Ugo Bellavance wrote: -Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 12:16 PM À : '[EMAIL PROTECTED]' Objet : RE: Installation Question Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! It is not optimized. It is optimizeable, not the same thing. However, you need to know exacly what are the compiler flags to optimize it. If you run on x86, you are better of with the binary or the .rpm. No offense, but people who compile at mysql are a lot better than you and me to get the best flags. hth Ugo Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Question - RedHat 9.0
For RedHat, just download the rpms and install it, it's far much simpler... Nicolas - Original Message - From: Ryan Sinnwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:21 PM Subject: Installation Question - RedHat 9.0 I am trying to setup Jabberd2 as a test for our IT users and have run into a few issues. Here is a link to the instructions I'm following: http://www.jabberdoc.org/app_mysql.html I know there are things missing because after I complete the make install in step A.4.6, it goes right on to have me change the root password, but mysqld isn't even running at this point. Could someone that has installed mySQL many times give these a look and see what steps they have left out that I will need for RedHat 9.0? One other step that doesn't appear to be correct is A.4.9 because /usr/local/var/mysql/ does not even exist after the install as they describe it. Also, if I want mysqld to start every time the computer is booted, and use the mysql user that I created per these instructions, is this what I would add to rc.local: /usr/local/libexec/mysqld --user=mysql Is rc.local the correct file to put this in or is there a better place? Any help that is provided will be much appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: installation question...missing 'host.frm'
Craig, Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. -Original Message- From: Craig A. Finseth [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:42 PM To: [EMAIL PROTECTED] Subject: installation question...missing 'host.frm' I am trying to install: mysql-standard-4.0.14-sun-solaris2.8-sparc.tar on a Solaris 8 system. I am getting this message in the .err file: 030910 11:05:41 mysqld started 030910 11:05:41 InnoDB: Started 030910 11:05:41 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030910 11:05:41 Aborting I haven't been able to find any reference to that file in any of the MySQL documentation. I've tried creating such a file, but the message remains unchanged. I am doing a little weird install. The commands and scripts go into /usr/local/bin and the database lives in /local/mysql. I have added symbolic cross links. Anyone have any ideas? Craig A. Finseth[EMAIL PROTECTED] Firwood Consulting, Inc.[EMAIL PROTECTED] 1343 Lafond, St Paul MN 55104 +1 651 644 4027 USA http://www.firwood.net +1 651 644 4027 fax (yes, same number) A ship is safe in a harbor, but that's not what a ship is for--Adm Grace Hopper -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation question...missing 'host.frm'
Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. Thank you. That was the problem. The host.frm really threw me. Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation question
Muriel, Friday, April 26, 2002, 1:14:02 AM, you wrote: M My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our M dedicated server. They discovered they did not install their client M libraries after I had already created users with the Grant permissions. How did you create users? M Now that they have reinstalled I can not access mysqladmin in the shell. M I cannot even do a shutdown. No one not even root can shutdown the MYSQL M server. I did the test in the manual to see if the server can connect: M Shell mysql-u root testIt comes back with the server unable to M connect. Unable to connect is a too short error message. What is the full message? M In the user table there are three users with all permissions M (one of them is root) none of the three users are able to do a shutdown M or any of the permissions that are in the table. It comes back with M access denied and password = No It means that you didn't used password when you tried to connect. So, if you want to connect to the MySQL server you should use: mysql -uuser_name -ppassword or for mysqladmin: mysqladmin -uuser_name -ppassword command You can find description of syntax at: http://www.mysql.com/doc/m/y/mysql.html http://www.mysql.com/doc/m/y/mysqladmin.html M but it is Y in the user table. What M needs to be done? I can with all three users leave the shell and it will M accept the passwords and I can go into mysql and do SQL queries fine. M Warm M regards, M Muriel -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: INSTALLATION QUESTION on Cobalt Raq3
Don't use RPM. The RPMs for the Cobalt RaQ3 suck. I have 8 different Cobalt RaQ3's and here's the way I've used to install: I've installed it this way successfully each time. Sounds like a bit of a pain, but puts you in much better control of MySQL. INSTALLATION INSTRUCTIONS #1 - download the newest MySQL *source* tarball from mysql.com or its mirrors. Do all the following stuff as "root" user: ## UNTAR IT tar -xvfz mysql-#.#.tar.gz ## - FIRST: TO MAKE A USER NAME 'mysql' GROUP NAME 'mysql' TO SAFELY RUN MYSQL UNDER /usr/sbin/groupadd mysql /usr/sbin/useradd mysql -g mysql ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-lz make make install ## - SET THE DATA DIRECTORY TO BE /VAR/DB - MAKE A SYMLINK FOR IT HERE IN THE MYSQL FOLDER cd mysql ln -s /var/db var ## - INSTALL THE BASIC DATABASE NEEDED TO RUN bin/mysql_install_db ## - if there's a problem, do the next step then come back and do this step again. ## - GO SET PERMISSIONS FOR THE DATA DIRECTORY cd /var chown mysql:mysql -R db chmod 700 -R db ## - COPY THE STARTUP/INIT/CONFIG FILES TO THE RIGHT PLACE cd share/mysql cp mysql.server /etc/rc.d/init.d/ cp my-small.cnf /var/db/my.cnf ## - PUT STARTUP FILES IN EVERY STARTUP FOLDER - so if they reboot the server, MySQL starts! cd /etc/rc.d/init.d/ chmod 755 mysql.server cd ../rc3.d ln -s ../init.d/mysql.server S88mysql cd ../rc4.d ln -s ../init.d/mysql.server S88mysql cd ../rc6.d ln -s ../init.d/mysql.server K18mysql cd ../rc0.d ln -s ../init.d/mysql.server K18mysql ## - SYMLINK THE COMMANDS INTO THE PATH SO WE CAN JUST TYPE "mysql" FROM ANYWHERE cd /usr/bin ln -s /usr/local/mysql/bin/* ./ cd /usr/sbin ln -s /usr/local/mysql/bin/* ./ ## - START IT! safe_mysqld mysqladmin -u root -p password 'somesecretpassword' mysql -u root -p use mysql; delete from user where user=''; exit; from now on, connect to mysql with 'mysql -u root -p' then type the magic password afterwards. Voila! - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSTALLATION QUESTION on Cobalt Raq3
"l" == lkeeton [EMAIL PROTECTED] writes: l First does anybody know the website address for that searchable l site that allows you to search on mysql archive emails. I would l appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they get from the mailing list or are they just wasting electrons on my box? - 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