Question about Apple Mac OS X 10.4

1 Answer

OS X 10.4 PHP MySQL problem

I don’t know what's going on, PHP and MySQL aren't connecting with each other, what could be the cause of this?

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 2,336 Answers

To change the location where MySQL creates its socket file, do this:
1. Open your preferred text editor and create a plain text file.
2. Type this text (on two lines as shown):
[mysqld]
socket=/tmp/mysql.sock

3. Save the file as: /etc/my.cnf


To change the location where PHP looks for the socket file, follow these steps:
1. In Terminal: sudo cp /etc/php.ini.default /etc/php.ini
2. Open /etc/php.ini in your preferred text editor.
3. Find the [MySQL] section, and change the mysql.default_socket directive:
4. ; Default socket name for local MySQL connects. If empty, uses
5. the built-in
6. ; MySQL defaults.
7. mysql.default_socket = /var/mysql/mysql.sock
8. Change the permissions on /var/mysql so that www can read the socket, by executing this in Terminal:
sudo chmod 775 /var/mysql

Posted on Aug 26, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Why mysql blackscreen dissapear when press enter button


this is normal for mysql server. It's simply wanting you to set the administrator password. the black box appears, you type your password, the black box closes.
This means the password is now set to what you typed in the black box (command prompt box)

Aug 07, 2014 | Microsoft Windows 7 Ultimate for PC

1 Answer

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)


Open up the PHP Config File Config.php (File name can vary) where the MySQL DB connection details are entered.
Change the machine source name, user name and password as per the current system config.
If still not fixing, go to the PHP line causing the issue and echo the connection details, and see if correct values are there.

Mar 04, 2013 | Operating Systems

1 Answer

I need a windows 95 security


My friend, Security for Windows 95 at the very best will be at least 10 years out of date and will offer you little to no protection.

I do not know where you are located and please don't say nor do I know your financial condition and again, please don't say. Obvioiusly you have WWW access and a computer, you are able to connect and operate at some level.

Since Windows 95, we have had Windows 98, 98 Second Edition, Millenium Edition, and XP, not to mention Vista and Windows 7 after that (current and to be eclipsed sometime next year)

Please consider obtaining a newer computer equipped with XP or newer operating system. If you lived down the street, I would give you several XP computers if you would just take them away. But you aren't so I am stuck with them. You may find very low cost or free XP or newer computers in your area if you take a look around.

Good luck to you and thank you for using FixYa.com

Sep 05, 2011 | Operating Systems

1 Answer

Write a C/C++ program that connects to a MySQL server and checks if the InnoDB plug-in is installed on it. If so, your program should print the maximum number of concurrent threads that the InnoDB plug-in...


I know this is a Homework problem. You aren't going to learn anything if we do it for you. I will give you this hint: There is a C++ library that has to be loaded in the header section in order to access the MySql Functions. It can be done using the core C++ header file for Databases but it is much harder to do. Once you add the proper header it should take you about an Hour to complete the program. Good Luck

Jul 28, 2011 | Operating Systems

1 Answer

How to develop online inventory system for a iron sail shop and which programming language is good for inventory and which database ? and php, mysql can help?


Thank you for using FixYa
Hello I see that you may be leaning toward open source, and that is a good idea for your inventory. Of course MySql will work. You could use MS Office Access, or Oasis is another good one. My previous experience has been that people hear all these big names about databases and might not even need one that expensive. Are you determined to write this one yourself or do you have a programmer in the family or are you going to pay for one? It depends on how extensive your inventory is, if you are looking at less than 500 to 1000 items then these programs may really be overkill. It is surprising how many small businesses are actually running on Quickbooks. You can take a program like that and others similiar and use just the inventory module. Some people might even be able to get by with Microsoft Works or other smaller programs. Most database programs have templates that may not be exactly like your business, but allow modification to the templates to make it more like your own. I hope this was useful and please comment if this was helpful to you.

Apr 26, 2011 | Operating Systems

1 Answer

I searched in net to download InnoDB plugin for mysql. I have installed MySQL-server-5.1.54-1.glibc23.i386.rpm on my linux box.. Could you please help me out. and also can you give me a solution for...


Write a C/C++ program that connects to a MySQL server and checks if the InnoDB plug-in is installed on it. If so, your program should print the maximum number of concurrent threads that the InnoDB plug-in can create.

Jan 09, 2011 | Operating Systems

1 Answer

Im getting a MySQL error saying : "Exception EMyxError in module MySQLQueryBrowser.exe at 00111E52. Error while loading stored connections. Error Number 3."


I think your MySQL Server databases got corrupt.
Try to remove or rename your existing connection file, creates a new one if it does not find any existing, allowing so to recover from broken files from the utilies below-

MySql Fix Toolbox provides easy ways of MySQL fix

Worried for Losing Data due to MySQL Corruption

Dec 27, 2010 | Operating Systems

2 Answers

How to create my hard disk as server like a website in my lan..............


you must install IIS (internet information service) or you can install wamp (mysql+ apache web server + php)

Jul 08, 2009 | Microsoft Windows XP Professional SP2 Full...

2 Answers

How to connect from jsp login page to database


hey try this code......just found it on the net... Put the code in tomcat and test the application through browser. The browser should display the display the data stored in the table.

Here is the code of our JSP file
<%@ page language="java" import="java.sql.*"%>
<html>
<head><title>Read from mySQL Database</title>
</head>
<body>

<p align="center"><b>Following records are selected from the 'jakartaproject' table.</b><br>&nbsp;</p>

<div align="center" width="85%">
<center>
<table border="1" borderColor="#ffe9bf" cellPadding="0" cellSpacing="0" width="658" height="63">
<tbody>
<td bgColor="#008080" width="47" align="center" height="19"><font color="#ffffff"><b>Sr.
No.</b></font></td>
<td bgColor="#008080" width="107" height="19"><font color="#ffffff"><b>Project</b></font></td>
<td bgColor="#008080" width="224" height="19"><font color="#ffffff"><b>Url
Address</b></font></td>
<td bgColor="#008080" width="270" height="19"><font color="#ffffff"><b>Description
of the project</b></font></td>

<%
String DRIVER = "org.gjt.mm.mysql.Driver";
Class.forName(DRIVER).newInstance();


Connection con=null;
ResultSet rst=null;
Statement stmt=null;

try{
String url="jdbc:mysql://192.168.10.2/tutorial?user=tutorial&password=tutorial";

int i=1;
con=DriverManager.getConnection(url);
stmt=con.createStatement();
rst=stmt.executeQuery("select * from jakartaproject ");
while(rst.next()){

if (i==(i/2)*2){
%>
<tr>
<td bgColor="#ffff98" vAlign="top" width="47" align="center" height="19"><%=i%>.</td>
<td bgColor="#ffff98" vAlign="top" width="107" height="19"><%=rst.getString(2)%></td>
<td bgColor="#ffff98" vAlign="top" width="224" height="19"><a href="<%=rst.getString(3)%>"><%=rst.getString(3)%></a>&nbsp;</td>
<td bgColor="#ffff98" vAlign="top" width="270" height="19"><%=rst.getString(4)%></td>
</tr>
<%
}else{
%>
<tr>
<td bgColor="#ffcc68" vAlign="top" width="47" align="center" height="19"><%=i%>.</td>
<td bgColor="#ffcc68" vAlign="top" width="107" height="19"><%=rst.getString(2)%></td>
<td bgColor="#ffcc68" vAlign="top" width="224" height="19"><a href="<%=rst.getString(3)%>"><%=rst.getString(3)%></a>&nbsp;</td>
<td bgColor="#ffcc68" vAlign="top" width="270" height="19"><%=rst.getString(4)%></td>
</tr>
<% }

i++;
}
rst.close();
stmt.close();
con.close();
}catch(Exception e){
System.out.println(e.getMessage());
}
%>

</tbody>
</table>
</center>
</div>


</body>
</html>

Feb 27, 2009 | Compaq Operating Systems

2 Answers

Convert dbf file to MySql file


php is not a database file, it is a script file used to build active web pages. I use Perl to automatically convert dbf files to SQL Server, which would be the same syntax.

Jul 19, 2008 | Operating Systems

Not finding what you are looking for?
Apple Mac OS X 10.4 Logo

Related Topics:

160 people viewed this question

Ask a Question

Usually answered in minutes!

Top Apple Operating Systems Experts

Yoav Shilon
Yoav Shilon

Level 2 Expert

101 Answers

Scott Fryer

Level 2 Expert

80 Answers

Custom Exchange
Custom Exchange

Level 3 Expert

397 Answers

Are you an Apple Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...