[PHP] MySQL Server
I am the first to admit that this question belongs on a MySQL newsgroup instead of here, but I can't seem to find a newsgroup that will answer me... Here is a newbie question. I am running a Win2K Advanced Server with IIS 5, PHP4, and MySQLmax 3.23.53. I am by no means experienced in setting up any of these items, but my simple question is, how do I determine the name of the MySQL server so I can get PHP to connect to it? My PHP is installed and running great, but if I can't hook up to my database it doesn't do me any good. TIA Chase -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Server
On Tuesday 03 December 2002 23:09, Chase wrote: > I am the first to admit that this question belongs on a MySQL newsgroup > instead of here, but I can't seem to find a newsgroup that will answer > me... www.mysql.com > Here is a newbie question. I am running a Win2K Advanced Server with IIS > 5, PHP4, and MySQLmax 3.23.53. I am by no means experienced in setting > up any of these items, but my simple question is, how do I determine the > name of the MySQL server so I can get PHP to connect to it? If they're all on the same server use 'localhost'. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* My father was a God-fearing man, but he never missed a copy of the New York Times, either. -- E.B. White */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Server
Thanks for the info... As it turns out, I am just a blithering idiot... I didn't know that I had to create a separate user... As I said, that shows my newbieness... However, this has lead me to another question... The default database, "mysql," comes with a "users" file already... How do I create that in a new database?? Or can I just copy the existing to a new database? Chase "Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Tuesday 03 December 2002 23:09, Chase wrote: > > I am the first to admit that this question belongs on a MySQL newsgroup > > instead of here, but I can't seem to find a newsgroup that will answer > > me... > > www.mysql.com > > > Here is a newbie question. I am running a Win2K Advanced Server with IIS > > 5, PHP4, and MySQLmax 3.23.53. I am by no means experienced in setting > > up any of these items, but my simple question is, how do I determine the > > name of the MySQL server so I can get PHP to connect to it? > > If they're all on the same server use 'localhost'. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > My father was a God-fearing man, but he never missed a copy of the > New York Times, either. > -- E.B. White > */ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Server
"mysql"-database contains all the system tables and users. Users are only inserted there and defined for which database they are made. As Jason suggested, look at mysql.com they have a fine manual with tutorials and long descriptions which lead to easy solutions to create users. i.e. search for the "grant"-statement. Thomas On Tue, 3 Dec 2002 16:56:40 -0700 [EMAIL PROTECTED] (Chase) wrote: > Thanks for the info... As it turns out, I am just a blithering idiot... I > didn't know that I had to create a separate user... As I said, that shows > my newbieness... > > However, this has lead me to another question... The default database, > "mysql," comes with a "users" file already... How do I create that in a new > database?? Or can I just copy the existing to a new database? > > Chase > > > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > On Tuesday 03 December 2002 23:09, Chase wrote: > > > I am the first to admit that this question belongs on a MySQL newsgroup > > > instead of here, but I can't seem to find a newsgroup that will answer > > > me... > > > > www.mysql.com > > > > > Here is a newbie question. I am running a Win2K Advanced Server with > IIS > > > 5, PHP4, and MySQLmax 3.23.53. I am by no means experienced in > setting > > > up any of these items, but my simple question is, how do I determine the > > > name of the MySQL server so I can get PHP to connect to it? > > > > If they're all on the same server use 'localhost'. > > > > -- > > Jason Wong -> Gremlins Associates -> www.gremlins.biz > > Open Source Software Systems Integrators > > * Web Design & Hosting * Internet & Intranet Applications Development * > > > > /* > > My father was a God-fearing man, but he never missed a copy of the > > New York Times, either. > > -- E.B. White > > */ > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Server
> Thanks for the info... As it turns out, I am just a blithering idiot... I > didn't know that I had to create a separate user... As I said, that shows > my newbieness... Hey we don't always castrate blithering idiots here. Only those who pretend not to be one. > However, this has lead me to another question... The default database, > "mysql," comes with a "users" file already... How do I create that in a new > database?? Or can I just copy the existing to a new database? Mysql lets you create databases. Within each database, you create tables. Databases contain tables, It is the tables which contain data. Use MyCC (download from www.mysql.com) or some gui to help you set these up. Or phpMyAdmin if you want browser based admin. Or simply c:\mysql\bin\mysql if you like command line and sql commands. Don't touch the database named 'mysql' and the tables in it. It is a special database containing system tables. As you create databases, tables and users, these will be updated automatically. Once you have set up your databases and tables, use the GRANT command to allow user access to the tables. If you are using php to access the database and the database is on the same machine as the web server, you grant a user privileges to a database on localhost and then use the following command to connect. "); ?> After connection, use php statements to construct your sql queries to reference the data in the tables. and you're away... (after a bit more reading in www.mysql.com and www.php.net. ) Lots of tutorials on this. Use google to find them. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP/MySQL/Server not working
Hey, just a quick question, I have a form that users can fill out to join a certain group, we can then view that info from an admin page that requires logging in. When a user fills out the form I get an email letting me know that the form was submitted with the users info as well. Here recently, I've been getting that info but their info isn't being saved into the database for somereason, anyone have any idea why ? I have filled out the form at least 15-25 times using different info and everyone of them worked for me. I even filled out the form using different special characters and still with no problems, I am using stripslashes on the form data, but I don't think that could keep the info from being saved to the database, it only does this periodically. Could this be due to a slow server ? or is there some sort of special character that could conflict with my PHP or with the MySQL syntax ? I just have no clue now. Any thoughts are appreciated. Thanks ConbuD -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/MySQL/Server not working
Are the variables quoted out by php setting magic_quotes_gpc or do you have to use addslashes in your code? conbud wrote: Hey, just a quick question, I have a form that users can fill out to join a certain group, we can then view that info from an admin page that requires logging in. When a user fills out the form I get an email letting me know that the form was submitted with the users info as well. Here recently, I've been getting that info but their info isn't being saved into the database for somereason, anyone have any idea why ? I have filled out the form at least 15-25 times using different info and everyone of them worked for me. I even filled out the form using different special characters and still with no problems, I am using stripslashes on the form data, but I don't think that could keep the info from being saved to the database, it only does this periodically. Could this be due to a slow server ? or is there some sort of special character that could conflict with my PHP or with the MySQL syntax ? I just have no clue now. Any thoughts are appreciated. Thanks ConbuD -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/MySQL/Server not working
magic_quotes_gpc is on, I dont use addslashes ConbuD "Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Are the variables quoted out by php setting magic_quotes_gpc or do you > have to use addslashes in your code? > > conbud wrote: > > Hey, just a quick question, I have a form that users can fill out to join a > > certain group, we can then view that info from an admin page that requires > > logging in. When a user fills out the form I get an email letting me know > > that the form was submitted with the users info as well. Here recently, I've > > been getting that info but their info isn't being saved into the database > > for somereason, anyone have any idea why ? I have filled out the form at > > least 15-25 times using different info and everyone of them worked for me. I > > even filled out the form using different special characters and still with > > no problems, I am using stripslashes on the form data, but I don't think > > that could keep the info from being saved to the database, it only does this > > periodically. Could this be due to a slow server ? or is there some sort of > > special character that could conflict with my PHP or with the MySQL syntax ? > > I just have no clue now. Any thoughts are appreciated. > > > > Thanks > > ConbuD > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP/MySQL/Server not working
Hey, Also the webhost only allows us database direct database connection using phpMyadmin, I did notice that on the table that stores the info, it keep getting an error after someone is posting the form. The error says something about Overhead: 275 bytes, Is this just an MySQL limitation that is set by the webhost ? and this overhead you think that would keep the info from being entered into the database. To get the error to go away I have to optimize the table. ConbuD "Conbud" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hey, just a quick question, I have a form that users can fill out to join a > certain group, we can then view that info from an admin page that requires > logging in. When a user fills out the form I get an email letting me know > that the form was submitted with the users info as well. Here recently, I've > been getting that info but their info isn't being saved into the database > for somereason, anyone have any idea why ? I have filled out the form at > least 15-25 times using different info and everyone of them worked for me. I > even filled out the form using different special characters and still with > no problems, I am using stripslashes on the form data, but I don't think > that could keep the info from being saved to the database, it only does this > periodically. Could this be due to a slow server ? or is there some sort of > special character that could conflict with my PHP or with the MySQL syntax ? > I just have no clue now. Any thoughts are appreciated. > > Thanks > ConbuD -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] setting up a php/mysql server on linux
I'm a Linux newbie. I just installed Linux Red Hat 7.2 successfully. I have some instructions to install php/mysql/apache and have a couple questions... Which is better, GNOME or KDE? I seem to like the feel of KDE better. Does Apache or php or mysql already come preloaded on Linux Red Hat? Any tips you want to give me when installing all this stuff. I had a hard ass time getting this to work on Windows, so now I gave up and went to Linux. Your thoughts? Thanks!!
Re: [PHP] setting up a php/mysql server on linux
Phil Schwarzmann wrote: >I'm a Linux newbie. I just installed Linux Red Hat 7.2 successfully. I >have some instructions to install php/mysql/apache and have a couple >questions... > > Fire away. > >Which is better, GNOME or KDE? I seem to like the feel of KDE better. > This is just for a user logged in. It does not affect apache/php/mysql as those are simply server processes over a network. By default both Gnome and KDE are installed (well, I choose the "custom" then "install everything" option). You can switch from one to another. > >Does Apache or php or mysql already come preloaded on Linux Red Hat? > Yes, all of them > >Any tips you want to give me when installing all this stuff. I had a >hard ass time getting this to work on Windows, so now I gave up and went >to Linux. > As I use linux, I've never tried installing these under windows. I gather there are several installers around, some are reputed to work very well. > >Your thoughts? > What I am thinking is not for this list :-) > >Thanks!! > You are welcome. Hope it helps. Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php