Re: Need A book for dynamic website
I myself like the following PHP4 Bible Sams Teach yourself MySql in 21 days Webmaster [EMAIL PROTECTED] on 11/14/2001 10:37:53 AM To: [EMAIL PROTECTED] cc:(bcc: Lad Gaal/MarconiMedical) Subject: Need A book for dynamic website Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Welling, Laura Thomson Database Driven Web Sites By Joline Morrison,Joline Morrison Sams Teach Yourself Active Web Database Programming in 21 Days By Dina Fleet,Matt Warren (Editor) Building Database Applications on the Web Using Php3 By Craig Hilton,Bjorn Borud,Jeff Willis Create Dynamic Webpages Using PHP and MySQL David Tansley PHP: Fast and Easy Web Development J. Meloni Thanx again: DavidJaymz - 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
Can't stop mysql
Howdy, I'm running version 3.23.41 on RH7.2. For the life of me I can't figure out why I can't stop mysqld. Linuxconf was where I first noticed this where mysqld would not respond to the stop request. I then tried to reboot the box and watched the shutdown process and noticed that mysqld failed the stop request. The only way to 'stop' mysqld is to use the 'killall mysqld' command. Any ideas on what could be wrong. If there is scripting changes, please give me very specific instructions. Thanks.. - 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: Can't stop mysql
The only reference to mysqladmin is for the reload at the end. I think this whole thing started after doing the mysql_install_db and then creating the root password - but it may be a coincidence. Any and all help is welcome as to why /etc/init.d/mysqld stop fails. The /etc/init.d/mysql is as follows: #!/bin/bash # # mysqldThis shell script takes care of starting and stopping # the MySQL subsystem (mysqld). # # chkconfig: - 78 12 # description: MySQL database server. # processname: mysqld # config: /etc/my.cnf # pidfile: /var/run/mysqld/mysqld.pid # Source function library. . /etc/rc.d/init.d/functions # Source networking configuration. . /etc/sysconfig/network # Source subsystem configuration. [ -f /etc/sysconfig/subsys/mysqld ] . /etc/sysconfig/subsys/mysqld prog=MySQL start(){ touch /var/log/mysqld.log chown mysql.mysql /var/log/mysqld.log chmod 0640 /var/log/mysqld.log if [ ! -d /var/lib/mysql/mysql ] ; then action $Initializing MySQL database: /usr/bin/mysql_install_db ret=$? chown -R mysql.mysql /var/lib/mysql if [ $ret -ne 0 ] ; then return $ret fi fi chown -R mysql.mysql /var/lib/mysql chmod 0755 /var/lib/mysql /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf /dev/null 21 ret=$? if [ $ret -eq 0 ]; then action $Starting $prog: /bin/true else action $Starting $prog: /bin/false fi [ $ret -eq 0 ] touch /var/lock/subsys/mysqld return $ret } stop(){ /bin/kill `cat /var/run/mysqld/mysqld.pid 2 /dev/null ` /dev/null 21 ret=$? if [ $ret -eq 0 ]; then action $Stopping $prog: /bin/true else action $Stopping $prog: /bin/false fi [ $ret -eq 0 ] rm -f /var/lock/subsys/mysqld [ $ret -eq 0 ] rm -f /var/lib/mysql/mysql.sock return $ret } restart(){ stop start } condrestart(){ [ -e /var/lock/subsys/mysqld ] restart || : } reload(){ [ -e /var/lock/subsys/mysqld ] mysqladmin reload } # See how we were called. case $1 in start) start ;; stop) stop ;; status) status mysqld ;; reload) reload ;; restart) restart ;; condrestart) condrestart ;; *) echo $Usage: $0 {start|stop|status|reload|condrestart|restart} exit 1 esac exit $? Bill Adams [EMAIL PROTECTED] on 11/12/2001 01:11:37 PM To: Lad Gaal/MarconiMedical@Marconi, Mysql List [EMAIL PROTECTED] cc: Subject: Re: Can't stop mysql [EMAIL PROTECTED] wrote: I'll agree with you but - when I shutdown my linux box or restart it, it tries to stop the mysql server and it can't. The command /etc/init.d/mysqld stop should work and it isn't. The question is why can't I stop the mysql server with this command. As a matter of fact, using /etc/init.d/mysqld stop restart fails when it tries the stop. There has to be something convoluted in one of the script files. Besides that, I'm not the only one with this issue. thanks This is really a distribution issue then. But I would look inside the init.d/mysqld script and see if it is calling mysqladmin or not. If it is: Does it have the full path to mysqladmin? Did you set the root password in MySQL and now need to specify it in the file, e.g.: mysqladmin -pthe.root?password shutdown? b. - 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: Can't stop mysql / possible bug?
I changed the script and now all is well. However I have two concerns: 1) Paranoid about the password being in this script. Is there a way around this. 2) Since I had to change the script to make it work, Is there a bug in 3.23.41?? Thanks for pointing me in the right direction. Bill Adams [EMAIL PROTECTED] on 11/12/2001 01:58:18 PM To: Lad Gaal/MarconiMedical@Marconi cc: Mysql List [EMAIL PROTECTED] Subject: Re: Can't stop mysql [EMAIL PROTECTED] wrote: The only reference to mysqladmin is for the reload at the end. I think this whole thing started after doing the mysql_install_db and then creating the root password - but it may be a coincidence. Any and all help is welcome as to why /etc/init.d/mysqld stop fails. The /etc/init.d/mysql is as follows: I would update the script: stop(){ /path/to/mysqladmin -uroot -pyour?root.password shutdown /dev/null 21 ret=$? if [ $ret -eq 0 ]; then action $Stopping $prog: /bin/true else action $Stopping $prog: /bin/false fi [ $ret -eq 0 ] rm -f /var/lock/subsys/mysqld [ $ret -eq 0 ] rm -f /var/lib/mysql/mysql.sock return $ret } restart(){ stop start } condrestart(){ [ -e /var/lock/subsys/mysqld ] restart || : } reload(){ [ -e /var/lock/subsys/mysqld ] mysqladmin -uroot -pyour?root.password reload } b. - 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
how to move db
I'm switching over to a bigger better faster server. My old server is running version 3.23.22-6 mysql on RH and I need to move all the db's to my new box using 3.23.41 installed on RH7.2. So do I just simply move all of the db directories from /var/lib/mysql from one box to the next or are there other files that I need to copy as well. Thanks for the assist - 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: phpMyAdmin
Muchas gratias. I now know why everyone keeps referring to this little jewel. thanks again to you and to all replying. Scott Baker [EMAIL PROTECTED] on 02/14/2001 12:17:45 PM To: Lad Gaal/MarconiMedical@Marconi, [EMAIL PROTECTED] cc: Subject: Re: phpMyAdmin http://www.phpwizard.net/projects/phpMyAdmin/ At 11:08 AM 2/14/2001 -0500, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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
SECURITY: Not running as root, etc
For security reasons, I don't want to run mysql as root of the OS. However, the only way I can run mysql is if I log into the server as root. So I guess I have to create another superuser with: GRANT ALL ON *.* TO lgaal@localhost IDENTIFIED BY 'whocares' WITH GRANT OPTIONS; Is this correct? and afterwards should I revoke root@localhost? Next item is why when I'm logged in as myself can I access 'mysql' without using a password and why do I have access to all of the databases except for mysql? tx - 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: Newbie Questions
You're correct in that /var/lib/mysql/mysql/* was not owned by mysql. I did a chown mysql.mysql and then did a chmod 775 on the directory. So I still get basically the same thing. I enter: mysqladmin -u root -p password meg123 Enter password:(I leave it blank and CR) mysqladmin: unable to change password; error: 'Table 'user' is read only' But if I enter: mysqladmin -u root -p password meg123 (cr) Enter password: meg123 (CR) mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I'm open for suggestions TX "Aaron Sinclair" [EMAIL PROTECTED] on 02/09/2001 08:20:16 PM To: Lad Gaal/MarconiMedical@Marconi cc: Subject: Re: Newbie Questions check that /var/lib/mysql/mysql/* are owned by mysql and have read write premissions. I am hanging out at www.mercylink.com/chat/chat.php chat server for a while if you want to talk about it. Aaron Sinclair - Original Message - From: [EMAIL PROTECTED] To: "Aaron Sinclair" [EMAIL PROTECTED] Sent: Saturday, February 10, 2001 2:05 PM Subject: Re: Newbie Questions I just tried mysqladmin -u root password meg123 the return was: mysqladmin: unable to change password; error: 'Table 'user' is read only' I then tried running the mysql_install_db again and then typed mysqladmin -u root -p password meg123 the response was t enter the password which I left blank and hit return and got: mysqladmin: unable to change password; error: 'Table 'user' is read only' I installed MYSQL during the redhat 7 install. Do I need a .cnf file someplace like in /etc. I think I saw a mf.cnf file that I need to copy from /usr/share/mysql/my-medium.cnf. I feel like it's something simple, but I just can't grasp it. Things were so much easier with postgresql. This is what I get for trying to advance!!! Tx... "Aaron Sinclair" [EMAIL PROTECTED] on 02/09/2001 06:22:26 PM To: Lad Gaal/MarconiMedical@Marconi cc: Subject: Re: Newbie Questions after running the mysql_install scripts.. mysqladmin -uroot password password mysql requires you to specify what user you are ie mysql -uusername -pthis prompts for a password - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, February 10, 2001 11:22 AM Subject: Newbie Questions Just got mysql running (Ithink) on Redhat Linux 7. The version is mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 TCX Datakonsult AB, by Monty Server version 3.23.22-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock So how do I change/add passwords for the users and how do I add users? I tried 'mysqladmin password newpassword' (where newpassword is my password) The response I get is: 'mysqladmin: unable to change password; error: 'You are using MySQL as an anonym' ' So then I switch to superuser and try again. The response I get is: 'mysqladmin: unable to change password; error: 'Table 'user' is read only' ' I try : 'mysqladmin -password newpassword' The response is: 'mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' So how the heck do I do this?? Thanks ____ Lad. Gaal - 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: Newbie Questions and a resolution
Well, I finally got that portion working. After I putzed around for awhile, I said to myself - Self, With all this putzing, I probably need to restart the mysqld server. So I tried that from linuxconf and for some reason it just didn't want to restart! So, I went and did a /etc/rc5.d/S85mysqld stop and then a /etc/rc5.d/S85mysqld start. Low and behold, I could now change the password from a blank to meg123. So now my next question is how do I add users? Do I do that from the mysql database?? Tx for your help "mysql-return-64843-gaal=ct.marconimed.com"@lists.mysql.com on 02/10/2001 01:06:43 PM To: "Aaron Sinclair" [EMAIL PROTECTED] cc: [EMAIL PROTECTED] (bcc: Lad Gaal/MarconiMedical) Subject: Re: Newbie Questions You're correct in that /var/lib/mysql/mysql/* was not owned by mysql. I did a chown mysql.mysql and then did a chmod 775 on the directory. So I still get basically the same thing. I enter: mysqladmin -u root -p password meg123 Enter password:(I leave it blank and CR) mysqladmin: unable to change password; error: 'Table 'user' is read only' But if I enter: mysqladmin -u root -p password meg123 (cr) Enter password: meg123 (CR) mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I'm open for suggestions TX "Aaron Sinclair" [EMAIL PROTECTED] on 02/09/2001 08:20:16 PM To: Lad Gaal/MarconiMedical@Marconi cc: Subject: Re: Newbie Questions check that /var/lib/mysql/mysql/* are owned by mysql and have read write premissions. I am hanging out at www.mercylink.com/chat/chat.php chat server for a while if you want to talk about it. Aaron Sinclair - Original Message - From: [EMAIL PROTECTED] To: "Aaron Sinclair" [EMAIL PROTECTED] Sent: Saturday, February 10, 2001 2:05 PM Subject: Re: Newbie Questions I just tried mysqladmin -u root password meg123 the return was: mysqladmin: unable to change password; error: 'Table 'user' is read only' I then tried running the mysql_install_db again and then typed mysqladmin -u root -p password meg123 the response was t enter the password which I left blank and hit return and got: mysqladmin: unable to change password; error: 'Table 'user' is read only' I installed MYSQL during the redhat 7 install. Do I need a .cnf file someplace like in /etc. I think I saw a mf.cnf file that I need to copy from /usr/share/mysql/my-medium.cnf. I feel like it's something simple, but I just can't grasp it. Things were so much easier with postgresql. This is what I get for trying to advance!!! Tx... "Aaron Sinclair" [EMAIL PROTECTED] on 02/09/2001 06:22:26 PM To: Lad Gaal/MarconiMedical@Marconi cc: Subject: Re: Newbie Questions after running the mysql_install scripts.. mysqladmin -uroot password password mysql requires you to specify what user you are ie mysql -uusername -pthis prompts for a password - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, February 10, 2001 11:22 AM Subject: Newbie Questions Just got mysql running (Ithink) on Redhat Linux 7. The version is mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 TCX Datakonsult AB, by Monty Server version 3.23.22-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock So how do I change/add passwords for the users and how do I add users? I tried 'mysqladmin password newpassword' (where newpassword is my password) The response I get is: 'mysqladmin: unable to change password; error: 'You are using MySQL as an anonym' ' So then I switch to superuser and try again. The response I get is: 'mysqladmin: unable to change password; error: 'Table 'user' is read only' ' I try : 'mysqladmin -password newpassword' The response is: 'mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' So how the heck do I do this?? Thanks Lad. Gaal - 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 unsubscribin
Newbie Questions
Just got mysql running (Ithink) on Redhat Linux 7. The version is mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 TCX Datakonsult AB, by Monty Server version 3.23.22-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock So how do I change/add passwords for the users and how do I add users? I tried 'mysqladmin password newpassword' (where newpassword is my password) The response I get is: 'mysqladmin: unable to change password; error: 'You are using MySQL as an anonym' ' So then I switch to superuser and try again. The response I get is: 'mysqladmin: unable to change password; error: 'Table 'user' is read only' ' I try : 'mysqladmin -password newpassword' The response is: 'mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' So how the heck do I do this?? Thanks Lad. Gaal - 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