473,471 Members | 1,937 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

php.ini file for mySQL

2 New Member
I don't know if this is the right place to ask this question...

My php.ini file look like following..
There are some empty spot to fill.. I do not know what values should I assign,,
To us mySQL what values do I need to set?(port, socket, host)

Thanks..
Expand|Select|Wrap|Line Numbers
  1. [MySQL]
  2. ; Allow or prevent persistent links.
  3. mysql.allow_persistent = On
  4.  
  5. ; Maximum number of persistent links.  -1 means no limit.
  6. mysql.max_persistent = -1
  7.  
  8. ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
  9. mysql.max_links = -1
  10.  
  11. ; Default port number for mysql_connect().  If unset, mysql_connect() will use
  12. ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
  13. ; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
  14. ; at MYSQL_PORT.
  15. mysql.default_port =
  16.  
  17. ; Default socket name for local MySQL connects.  If empty, uses the built-in
  18. ; MySQL defaults.
  19. mysql.default_socket =
  20.  
  21. ; Default host for mysql_connect() (doesn't apply in safe mode).
  22. mysql.default_host =
  23.  
  24. ; Default user for mysql_connect() (doesn't apply in safe mode).
  25. mysql.default_user =
  26.  
  27. ; Default password for mysql_connect() (doesn't apply in safe mode).
  28. ; Note that this is generally a *bad* idea to store passwords in this file.
  29. ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
  30. ; and reveal this password!  And of course, any users with read access to this
  31. ; file will be able to reveal the password as well.
  32. mysql.default_password =
  33.  
  34. ; Maximum time (in secondes) for connect timeout. -1 means no limit
  35. mysql.connect_timeout = 60
  36.  
  37. ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
  38. ; SQL-Errors will be displayed.
  39. mysql.trace_mode = Off
Mar 27 '07 #1
0 1224

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: francescomoi | last post by:
Hi. I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2: ---------------------------------- # export PATH=$PATH:/usr/local/mysql/bin/ # export mysqlclient=mysqlclient_r # python setup.py...
0
by: JL | last post by:
Platform: Linux Red Hat RHEL 3 (and red hat 9) Installed MySQL from source. As a matter of fact, installed all LAMPS from source, and the mysql socket file was arranged in a place other than...
0
by: Jean Hagen | last post by:
I'm trying to write a script to weekly remove MySQL logs, the general, error and binary log files. Following the MySQL documentation, I've written a script that moves all current log files, then...
12
by: jacob nikom | last post by:
Hi, I would like to store XML files in MySQL. What is the best solution: 1. Convert it to string and store it as CLOB/text 2. Serialize it and store as byte array 3. Flatten it out and create...
0
by: Jason Reljac | last post by:
Howdy, I'm looking for a little help. I had a W2K server with Apache/PHP/mySQL installed and working. I had a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the outfile into a...
4
by: news | last post by:
Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
3
by: doctorhardik | last post by:
hai all i am try configure php4.3.9 on my FC-3 machine. and my mysql database version 5.0.1, in phpinfo file it show mysql but when i run php -v command it show error like
1
ddtpmyra
by: ddtpmyra | last post by:
When Im downloading a file from mysql database the file is already corrupted below are the code I used on downloading to mysql and uploading from mysql. PDF file are doing okay as long as it is a...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.