Setup MySQL On A Standalone Machine
Has anyone setup MySQL on a standalone machine?
View Complete Forum Thread with Replies
Related Forum Messages:
Why My PHP And My MySQL Can't Connect In Different Machine
I'm working with PHP and MySQL on a RedHat7.0 machine. It's work well, but When I install apache in my WIN2000 and place the PHP code under here, it can't connect the RedHat's MySQL? <html> <body> <?php $db = mysql_connect("192.168.1.100:3306", "root","password"); mysql_select_db("mydb",$db); $result = mysql_query("SELECT * FROM employees",$db); printf("First Name: %s<br>", mysql_result($result,0,"first")); printf("Last Name: %s<br>", mysql_result($result,0,"last")); printf("Address: %s<br>", mysql_result($result,0,"address")); printf("Position: %s<br>", mysql_result($result,0,"position")); ?> </body> </html> ERROR MESSAGE:
View Replies !
Mysql Setup
when I setup mysql database server open mysql.server the error:couldn't find mysql manager or server my operate course is:
View Replies !
How I Setup My Mysql Database(s)...
Quick question on how I setup my mysql database(s)... If my setup is such that I have multiple clients, and each client gets 10 tables to store their data, is it better for performance if I put all of these tables into 1 large database (with a unique identifier prepended to each one) or create a separate database for each client? i.e., assuming 1000 clients, I either would have: A) 1 database and 10,000 tables in it, 10,000 total tables B) 1000 databases with 10 tables in each, 10,000 total tables Intuition tells me that the multiple databases would be better for isolating data between clients, but I am not sure if this would slow things down. All the info I found on this online was inconclusive and mostly was people speculating, so I hoped you all could help more.
View Replies !
MySql Field Setup
how to link different tables as to UPDATE and PULL information when needed for a specific ID. Example DATABASE: OCBB TABLES: USERS ID | NAME | COMPANY | ADDRESS | CITY | STATE | 1 DAN TEST INC 123 R RD ANY ANY 2 BOB ABC INC 123 L RD ANY ANY 3 TED RED INC 123 P RD ANY ANY BILLING ID | AMOUNT | DATE DUE | 1 12.00 1/1/2008 2 15.00 1/15/2008 3 20.00 1/31/2008 What do I need to do to connect the USERS and BILLING fields so that when I pull up USERS ID1 it will show BILLING ID1 info. Also how do I go about updating all the fields at one time. If we add another USER ID4 how do we update BILLING to add ID4 and the amount and due date.
View Replies !
Linux, MySQL Setup
I decided to fire my programmer who managed our Linux Server/ Apache. I have figured out how to create virtual host to map domains to 1 i.p. No I need to figure out which directory to get in to add/create mysql databases. I currently am just overwritting the ones he had created but I need to know how to create them myself. Any ideas or suggestions?
View Replies !
Download.php Setup With Mysql
I need help to set-up my MySQL database using php. I am trying to make a download.php which would let users to download files after 5 seconds. The only problem is that my /download directory has many sub directory. For example if someone wants to download FireFox, then firefox.exe is located in /download/FireFox/firefox.exe. I want somewhat like this www.domain.com/download.php?fileid=firefox.exe as an output URL to download. I know that I can use MySQL and setup a nice database to do something like this as long as fileid is unique. Any ideas on how to setup the MySQL database so that I can easily add multiple files from different sub directory at the same time.
View Replies !
PHP And PEAR And MySQL Setup On Apache
Very experienced developer, newbie to PHP. My situation: I have installed on my WIndows XP machine the following: * PHP 5.2.1 * MySQL 5.0 * Apache 2.2 All of these are installed under C:Program Files under their own directories. The PHP installation works fine. I can put PHP files under the Apache htdocs directory and have them run. My challenge now is getting the MDB2.php libraries to run - right now I am getting an MDB2.php not found error, which I believe is due to a include_path error... So, I have 2 PHP.INI files -- one in C:Program FilesPHP and one in the htdocs directory of Apache. They both have the exact same include_path defined in the them. The very strange thing is that when I run phpinfo(), the include_path comes out to be .;C:PHP5PEAR. I have no idea where this value is coming from (it is the value for Master and Local). I have search everywhere -- the PHP.INI files, the registry, the ENV variables --- everywhere -- and I have no idea where this value is coming from. Where does phpinfo() pull the include_path from? If I can track down and change this value to the "real" PHP path, I may be able to get to the next hurdle of using MDB2!
View Replies !
Setup Problems Php / Mysql /phpmyadmin
I used this php package to install on my system... (i had problems with the isapi package from php so im back to the cgi portion of PHP php-cgi.exe) PHP 5.0.0 installer [2,235Kb] - 26 July 2004 (CGI only, packaged as Windows installer to install and configure PHP, and automatically configure IIS, PWS and Xitami, with manual configuration for other servers. N.B. no external extensions included It works fine... as the test page outputs the correct php page. i also setup MySQL database 4.0.20a-nt that works fine too. I installed PHP to make use of the mysql database thrue phpmyadmin. When i try phpadmin it gives the messages; cannot load MySQL extension, check PHP Configuration. Documentation So how do i load the mysql extenstion thrue php.ini in system dir to work with php-cgi.exe ? When i tried to load the php_mysql.dll with php.ini wich is provided with the isapi package of php it gives an error loading ... Php startup mysql: unable to initialize module. Module compiled with module Api=20040718 , debug = o , thread safety =1 PHP compiled with module Api=20040412 , debug = o, thread safety =1 these options need to match.
View Replies !
Newbie Connection / Setup Problems With MySql
I'm a newbie to MySQL and just needs little help with a couple of problems. I am currently working through a book on Dreamweaver MX 2004, and I'm using MySQL and PHP. Unfortunately though I can't seem to connect to the database and I'm not sure my user info was setup correctly in the first place. The book says to copy the newland_tours.sql database to the c:mysql folder. however I'm pretty sure that the test and mysql database files that the root user has access to are in the c:mysqldata folder so I have copied this file to this folder as well. When I go back into Dreamweaver and click on Applications, Databases and the Plus sign to add a MySql connection, if I click the button that says Select, to choose the database, only test and mysql are still listed. I'm not entirely sure that I would be able to connect to the database anyway even if it was showing because when I try one of the databases listed with the following info: Connection Name: conn_test MySQL Server: localhost Usename:root Password: Database:test It asks me to select a password. It doesn't seem that I would be able to connect as the root user without a password. When I click on the traffic lights signal in the taskbar to go to WinMySqlAdmin, in the MyIni Setup section it has the user down as House and a password that is familiar to me, so I think I must have entered this info when I set up the My.ini file. However, even if I enter the user as House and enter the password I chose it gives me an error 1045, access denied. Before trying to load this database that I want to use, I thought I needed to sort out the user problems and to see if I could log into MySql. So I opened a command prompt and CD to c:mysqlin. When I get here I type C:mysqlin> mysql and I get the "welcome to the mysql monitor" message and leaves me at a mysql> sign. Someone told me that I should be able to get the database loaded seen as I can get the mysql screen up by logging in as the root user without any password or username. The person said to copy the newland_tours.sql database into the c:mysqlin fodder which I did. If I try to CD to that directory from the mysql> after logging in it gives me errors saying unknown command 'm' and '' To be able to CD to that directory again I have to exit from the mysql monitor by typing exit or q and it returns me to the c:mysqlin> prompt. If I now try and type this: C:mysqlinmysql < newland_tours.sql to load the database from the c:mysqlin> prompt, it gives me an error saying: Error 1044 at line 1, access denied for user "@localhost" to database 'database' If I try this with the username and password that are listen in the my.ini file I get the following error: Error 1045: Access denied for user: 'house@localhost" <using password: yes> If you can help me with the user problems and connection/access problems I'm having so I can get the connection set up I'd be very grateful as I'm starting to get a tad confused by it all.
View Replies !
Running PHP/Apache On A User Mode Linux Machine, Where To Stick Mysql?
I hope no one minds me running this past them. I'm running a linux machine with with apache, php and mysql. This is not accessable from the internet. I want a server that is visable to the internet. For that purpose I am running a user mode linux machine and using apache on that as the external looking web server. This means that stuff I want to see on the outside is on a copy of apache that is doing little and does not get messed around with as much as my main copy of apache. I am not using mysql with it at the moment. If I do am I better running mysql on the user mode machine or running a second copy of mysql on a different port on the 'main' machine. I'm beginning to think the latter has advantages.
View Replies !
Standalone Problem
I've set up PHP 4 with Apache on an intel/Redhat 6.2 linux box with no network interface. Using URL PHP code with the .php extension works fine, but php code in html documents does nothing. In fact, view source shows the php code on the browser.
View Replies !
Multithreading For Standalone Php
I'm trying to write a mutlithreading server with standalone PHP. Concurrent requests is possible. Normally it is done by handling each socket spawn by serversocket in separate threads. But it seems that there is no thread support in PHP at all. Would anyone give me some suggestions? BTW, is the community considering add thread support to PHP in the future? What is the major difficulty to import an existing thread library (such as pthread library) into PHP
View Replies !
Standalone Program
I'm going to be doing a program for an elderly couple who owns a horse ranch, and wants some software to keep track of all their horses, owners, doctors, etc. I'm going to be writing the program in PHP using a MySQL database. I set up one like this for my work and it runs off of Apache on our server. I need this program to be a stand-alone install, without installing MySQL, PHP, and Apache seperately. How could I go about integrating it all into one package?
View Replies !
Standalone PHP Installation
I have never installed PHP before. It's always been set up for me. I have a client whose site is hosted as a virtual server. I'm trying to set up ecom for him, but the mhash library is not installed. So I use fopen to open a script on my website that hashes the variables. Obviously, this is not ideal because if my site goes down his ecom will too. I asked the tech people at his hosting company to set that up, but they said they don't do custom compilations. "As per compiling PHP with --with-mhash=[DIR] this is how that works: any custom compilations, custom applications, etc. are up to the user to compile and install. Use gcc/etc. to compile PHP with the options that you like. The php.ini in /etc is available for your customization as well. If you compile your own binary of PHP, you can place it where you like (or leave it at the default) and get the paths updated to use it, or you can obviously use it directly if necessary." I was planning on compiling a new, minimalist version of PHP (with just mhash) in a different directory, but I'm hesitant to do it in case I get unexpected results (I don't want to take the rest of his site down). Can anyone tell me if this sounds feasible? What kind of pitfalls can I expect? And can anyone recommend a tutorial? Most of the tutorials I've found assume you have root access and/or are compiling PHP/Apache together. I was also wondering if it would be possible to just compile the mhash library and add it to php.ini? That seems to be the simplest thing, though I don't know if it would work...
View Replies !
Php Install Standalone
I need to install php like standalone. can somebody say me that way to install it like standalone on linux, with support for mysql, apache and oci8?
View Replies !
Standalone Sig Generator
I currently have my sig generator running, the problme Im facing is that it outputs like this http://mysite.com/image.php?sigimage.png I need to have it out put like this -> http://mysite.com/image.png?sigimage.png or something like it because a lot of sites do not allow image.php. Code:
View Replies !
Standalone Apps And Php
I have a project in mind for a library management system which I would like to try building with php/mysql. Are there any Delphi-like IDE apps out there that would do the job? Can the code be compiled into an executable?
View Replies !
Standalone Solution
I was asked to write a database solution for a friend.. it was supposed to do the normal add/retrieve/modify/search functions of a databse. i started with vb6 then decided to use php/sql. I might sound really dumb and ignorant but the question is... if i want to "package" this to him... how can i do this without having to personally go and install a webserver and php and sql and the rest so he can use it just through his web browser? can i use an installer that will allow it to be packaged so after the install he would just have to open the databsae through his browser?
View Replies !
PHP Standalone: Charset Setting
I'm simply using PHP as a programming language, and I just want to print some text information to stdout, but instruction print "é" (é) does not print my "e" with an accent in the shell window: wrong charset. How to set the correct charset?
View Replies !
Standalone DB (like Access) For PHP/Apache
I am in the process of translating an WIndows/ASP/MsSQL Content Managment System (CMS) to Linux/PHP/???. Is there a popular database I can use that will allow standalone files like Access did (which used .MDB files)? In order for the CMS to work, there needs to be a standalone database file that is self-contained, just like Access .mdb files are under Windows. I guess I am asking for an Access equivalent for Linux/Apache.
View Replies !
Standalone Executable File
I downloaded the tarball and while was able to compile within PHP with no problems, I am having memory timeout issues involving image manipulation with extremely large images (800K - 2mb). Requirements are to create thumbnails for even these banner-sized images, but PHP + GD + [huge image] = too much memory. I'm trying to prove that it is undoable, though the suggestion was to do a command-line GD call to the image instead of using the PHP functions to do so to save some memory; if it still times out, then it's undoable altogether. However, I cannot find the standalone executable file that will ensure I can run GD from the command line.
View Replies !
Submit Standalone Programs With Php
I'm building an application which submits scheduled php jobs. The way I would like it to work is to have one php program to submit the other php programs on a scheduled basis. This control program shouldn't have to wait until one job finishes before it can start the next one; instead, it should be able to submit all the jobs in one go, but it also needs to be able to be informed of the return codes of the submitted programs so dependent programs can be submitted too. I've looked at the exec() and system() commands, but they either don't seem to allow return codes to be returned from a submitted program to the submitter program or they unconditionally print anything the submitted programs produce.
View Replies !
Where Can I Find The GD Library Standalone Executable File?
I downloaded the tarball and while was able to compile within PHP with no problems, I am having memory timeout issues involving image manipulation with extremely large images (800K - 2mb). Requirements are to create thumbnails for even these banner-sized images, but PHP + GD + [huge image] = too much memory. I'm trying to prove that it is undoable, though the suggestion was to do a command-line GD call to the image instead of using the PHP functions to do so to save some memory; if it still times out, then it's undoable altogether. However, I cannot find the standalone executable file that will ensure I can run GD from the command line.
View Replies !
Machine Name?
is there a way to detect the name of the machine a user's on. like u would an IP. also how do i change my machine's name? =).
View Replies !
V4 And V5 On The Same Machine
We want to set up a PHP server for instructors to teach PHP, but different instructors have different needs. Is it possible to install PHP 4.3.8 *and* PHP 5 on the same machine? Perhaps using different ports or something to keep them separated? I have a Windows 2003 Server running IIS6.
View Replies !
Get Machine Name
I have a survey on my company website. I want to only allow each person to vote once a day. I can use $_SERVER['REMOTE_ADDR'] to get the IP address but we have a proxy server and that is the ip address that is showing up. Is there any other way to do this? I have been looking for a way to get the client machine name but have not had any luck.
View Replies !
PHP On Local Machine
Back in 2004 I installed PHP, Apache and MySQL on my local machine to do some testing. I have not used it since. I just tried to browse one of my .php test files in IE and it opened up in Dreamweaver! Everything seems to be in place where I left it, I restarted Apache just in case - but no joy. Is there something simple that I have forgotten to do? - something I should have started up? - or something I can check? I would like to avoid reinstalling the software if possible as I recall having a few "teething problems."
View Replies !
Php Talk To A Fax Machine?
Is there any way I can capture data from a fax machine using PHP? I do not need a solution for faxing, I need a solution for capturing the data whenever a document is faxed directly to the fax machine.
View Replies !
Validation Machine
i created some php/mysql code, and want to offer it to ppl, but if they want to use it i want there to be a link at the bottom of the page, going to my site. here's the trick, i want the code not to work if the link is taken away. Code:
View Replies !
Installation Win Xp Pro Sp2 Machine
I've setup my pc as a development webserver with the following installed (on a win xp pro sp2 machine): apache - apache_2.0.54-win32-x86-no_ssl php - php-5.0.4-Win32 phpmyadmin - phpMyAdmin-2.6.3-pl1 tomcat - apache-tomcat-5.5.12 mysql - mysql-4.1.12a-win32 myodbc - MyODBC-3.51.11-2-win smtp (IIS) - XP SP2
View Replies !
Problem With COM On Just One Machine?
Running PHP 5.1.6 on a Windows Server 2003 machine, running as a CGI under IIS 6. I call a class in each of my pages that performs an LDAP query to automatically look up user name / email / other details (this is taking place on a company intranet). This works fine on every machine tested, except 1 - on which the code throws the following error: Code:
View Replies !
Ghost In The Machine
this is the second time this has happen now on two seperate products and it's very strange. I'll be coding away and then previewing my work through a browser when all of a sudden I get an number 1 appearing on the screen. it is not in the any of the php files but it shows up in the browser window.
View Replies !
Check If 2nd Machine Is Alive.
Is there a way using php to check if another server is alive. I want to check to see if a certain server (irc.blah.com for example) is alive and if it is print something like "Irc is active" if not print "Sorry irc is unavailable". is there a way using php to do this ?
View Replies !
Session Does Not Work On My Win Xp Machine.
Session does not work on my win xp machine. I am using PHP Version 4.3.8 Apache Version Apache/1.3.31 (Win32) PHP/4.3.8 any help is appriciated my session variable are: session Session Support enabled Registered save handlers files user Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 Off Off session.bug_compat_warn On On session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 1000 1000 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path C:AppServphpsession C:AppServphpsession session.serialize_handler php php session.use_cookies On On session.use_only_cookies Off Off session.use_trans_sid Off Off
View Replies !
PHP Copy To Local Machine?
I am building a small page to copy files from our server(s) to our users local machines. It's very simple... (below, "f" is a mapped network drive) <?php $source_file = 'f:somefile.whatever' $destination_path = (I want to move it to the USERS C:somedirectorysomefile); copy($source_file, $destination_path); ?>
View Replies !
Install CURL On An IIS Machine
I have been coding PHP for years and have been a Sys Admin even longer. Unfortunately, I have always used the installer version for Windows since our servers are running IIS. I currently have PHP 4.4.4 on a partcular development machine and now need cURL to be installed for a website we are developing. Is there any way to install cURL on an IIS machine without having to uninstall PHP, then manually reinstall PHP and add cURL support?
View Replies !
Remote Machine Access
I have to access the remote machines of the intranet of my organization. All the system information regarding free memory available and what operating system they have n all such system level details.
View Replies !
Logout From Other Browser Or Machine
i am working on a site where users are able to login. i want if a user say 'a' logins from one computer and then after some time another user logins with the same login then first user 'a' should be logout. example if we login on msn messenger and somebody logins with out login, then we get logout.
View Replies !
Orders Sent Via Computer To Fax Machine
I have a client that wants an online menu built for his web site! My client wants his customers to place orders via internet, and in return he'll have the orders ready at the desired time! Now for the kicker! he has no internet connection at his restaurant. Can a form be built to send the information via computer to his fax machine? If so, please tell me how or point me to the tutorial.
View Replies !
Getting Unlink() On My Local Machine
I am having trouble getting unlink() to work on my local machine (win 2000, Apache, php 4.2.2) when I invoke unlink() in order to change a file name during a 'picture edit' change from a form upload on my local machine using simple stuff like: <?php if(file_exists($new_file_name)){ unlink($new_file_name); } if($new_pic){rename($old_file_name,$new_file_name) ;} } ?>........
View Replies !
How Does Cache Corrupt On Some Machine?
The site is working fine on IE and FireFox in default cookie status. on some machine site opens after clearing the cache. why clearing of cache is required for some user to open the site ? i guess that the problem is arising due to corrupted cache. how does cache corrupt on some machine?
View Replies !
|
TRACKER
