Re: Problem in installing Mysql
Keep reading the istructions expecially the part where it istructs you where to copy the mysql.server. I had the same problem and i still do not know what the @HOSTNAME@ is, however after rebooting the error message still displays but i get a running mysql. harry Kasi Viswanthan Arunachalam wrote: Hi, I need some help in installing MySQL.I did the following things 1) Downloaded the mysql version 3.23.36-pc-linux-gnu-i686.tar.gz 2) tar -zxvf mysql-version 3) ln -s /usr/local/mysql-version mysql 4) adduser mysql 5) passwd mysql 6) chown -R mysql mysql-vesion mysql 7) chgrp -R root mysql-version mysql 8) su mysql 9) cd mysql 10) scripts/mysql_install_db 11) exit 12) chmod 755 /usr/local/mysql/support-files/mysql.server 13) /usr/local/mysql/support-files/mysql.server start Till the step 12 the installation went great. But after i executed the = step 13 i got the following message /usr/local/mysql/support-files/mysql.server:@HOSNAME@:command not found starting mysqld daemon with databases from /var/lib/mysql 010920 = 13:23:52 mysqld ended Thank You Kasi Get free email and a permanent address at http://www.amexmail.com/?A=1 - 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: starting problems. . .
I had similar problems with sue7.2 i finally got fed up and downloaded the most current binary distribution and followed directions. I am still trying to work out some issues but at least i have a working system XAPHS Chris Bolt wrote: I am currently using Slackware 8 (linux) and I have some problems. There is mysql package in the slackware installation, which I installed it but never manage to run it successfully. Everytime I type the following safe_mysqld and I get the following message: Starting mysqld daemon with databases from /var/lib/mysql 010912 15:13:45 mysqld ended which means that for a strange reason the server doesn't starts. Do you have any idea what might be the problem ? I also dowload your docs from the site but couldn't manage to solve it out. Look at the .err file in /var/lib/mysql - 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: help with mysql.sock error
I had the same problem with suse 7.2. I see that the path to mysql.sock is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover from the mysql that i installed from the distribution. the downloaded version though stores the mysql.sock in /tmp/mysql.sock - i had to tell a few of my programs to look for it there. may you need to add a line in your php program to look for it there good luck harry a. adam wrote: I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect via web page with the error mysql.sock (111). - 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: 'localhost' problem
I had the same problem with suse 7.2. I see that the path to mysql.sock is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover from the mysql that i installed from the distribution. the downloaded version though stores the mysql.sock in /tmp/mysql.sock - i had to tell a few of my programs to look for it there. may you need to add a line in your php program to look for it there good luck harry a. Crazy Linux wrote: yes..the /etc/hosts file reads like the following: 127.0.0.1 localhost.localdomain localhost 138.xx.xx.xx mydomain.edu mymachine thanks --- Lance Rochelle [EMAIL PROTECTED] wrote: is localhost setup correctly in /etc/hosts file? i.e. 127.0.0.1 localhost, if not put that in there and then try again lance - Original Message - From: Crazy Linux [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 2:53 PM Subject: 'localhost' problem hello all, i am running mysql on a red hat linux v7.0 box. when i am trying to connect to the mysql database to read a table that is present in the mysql database i am facing a strange problem. i am able to get into the database(named 'newone') to read the table (named 'namelist') from the command line on the machine that is running mysql in any of the following ways: # mysql -u myname -p mypassword # mysql -u myname -p mypassword -h localhost # mysql -u myname -p mypassword -h mydomain.edu All these 3 commands are successful, without returning an error. So i have created a php file named 'namelist.php' to read this 'namelist' table, which reads like the following: html head titleName List/title /head body ?php mysql_connect ('localhost','myname','mypassword') or die ('bUnable to connect to the database/b'); mysql_select_db ('newone') or die ('bUnable to connect to the database/b'); $result = mysql_query (select * from namelist); printf (First Name: %sbr\n, mysql_result($result, 0, firstname)); printf (Last Name: %sbr\n, mysql_result($result, 0, lastname)); ? /body /html when i run this php script from the browser, it is producing the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 Unable to connect to the database But if change the 'localhost' to 'mydomain.edu' in line 7 it shows the contents of the table on the browser without any glitch. My question is eventhough if it doesn't complain any thing from the command line when i specify '-h localhost', why it returns the above error when i run the script in a browser? i am able to reach the index.html page from the browser by typing any of the following, on the same machine: 127.0.01 localhost mydomain.edu 138.xx.xx.xx --my ip address Can any one please help me with this. TIA __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.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 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.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 - 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: @HOSTNAME@error
I checked my boot log and found the follwing errors /etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found /etc/init.d/rc.d/S61mysql: my_print_defaults: command not found I have checked the manual but could not figure out if this is a problem or not mysql seems t run fine for now. What are these commands use for? any insight would greatly be appreciated Harry Amarantidis - 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