473,508 Members | 4,712 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql connection

25 New Member
i installed easy php which has both the Apache and MySql server,but when i try to connect to mysql in php using the mysql_connect() ,im not setting any parameters there is an error notifying me that it cant connect ,are there any configurations that i have to do to the mysql so that it connects,im mainly concerned on the issue of clients who can connect to the mysql.pliz help
Dec 13 '07 #1
5 1248
code green
1,726 Recognized Expert Top Contributor
using the mysql_connect() ,im not setting any parameters
You are not giving php much chance here.
Why are you passing empty parameters?
Dec 13 '07 #2
mwasif
802 Recognized Expert Contributor
Checkout the examples how to connect to MySQL using mysql_connect.
Dec 13 '07 #3
bowtie
25 New Member
You are not giving php much chance here.
Why are you passing empty parameters?
i have tried to pass some parameters ,but the issue is it seems as if there are some configurations that you have to do so that those parameters ie host,username and password ,will be recognised,so that is what i really want to understand.
Dec 14 '07 #4
bowtie
25 New Member
Checkout the examples how to connect to MySQL using mysql_connect.
i have checked the examples and there seems to be some enlightment now,but still the issue remains,on the issue of the parameters,when i try to use my own host name,username and password ,there is an error that those parameters are not recognised and when i dont pass any parameters ie will be assuming that it uses the default parameters still there is this error CANNOT CONNECT USING ODBC@localhost .what could be the problem !!!!where do i first set those parameters so that there will recognised,and what do you do so that the default parameters wil be recognised
Dec 14 '07 #5
mwasif
802 Recognized Expert Contributor
You need a valid MySQL user to connect to MySQL Server. You can create a user using command GRANT. You can also create users with GUIs like phpMyAdmin.
Dec 14 '07 #6

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

Similar topics

0
4231
by: Robert Mazur | last post by:
MySQL 5.0 alpha (binary install) on Solaris 9 -or- RedHat 8.0 mysql-connector-java-3.0.8-stable ----------------------- Is there something different going on with JDBC and the alpha version...
0
3925
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
11
17526
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...
1
13886
by: zMisc | last post by:
I am looking at using MySQL in my application (currently works with Access and SQL Server 2000). Is it possible to access MySQL database using ADO? What is the connection string for this? ...
15
4564
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
7
2478
by: Ike | last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on 111.111.111.111 allowing all incoming and outgoing ports. I have a username and password setup, which CAN connect to this database,...
5
2020
oll3i
by: oll3i | last post by:
my librarybean package library.ejb; import java.sql.*; import javax.ejb.*; import library.common.*; @Stateless @Remote
3
5479
by: tulika dutta | last post by:
after 8 hrs my MySQL connection with JDBC gets time out. It gives the error java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying...
39
5823
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
0
7128
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7502
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5635
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,...
1
5057
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4715
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
3206
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
1565
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 ...
1
769
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
426
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.