Hello Mohammed,
Thank you for contacting Yahoo! Small Business Support.
My name is Sanjana and i will be happy to assist to assist you.If i
clearly understood your mail, i see that you are having issues
connecting your Mysql database with ODBC. We apologize for the
inconveniece caused to you.
If you are using a PHP script that connects to a MySQL database, this
may require a database host name, a database name, and a database user
name and password.
NOTE: Yahoo! Web Hosting does not support third party scripts.
Hostname
========
The host name is always "mysql." Many scripts will set the host name to
"localhost" by default. Please note that this will not work. You must
change the host name to "mysql."
Database Username and Password
==============================
When you initially set up a MySQL account, you will create a database
user name and password. To create a MySQL account, log in to your Yahoo!
Web Hosting account. Under the "Create & Update" tab, choose "MySQL
Database," then "Create Username and Password Now."
Database Name
=============
When you initially set up a MySQL account, a database named "mysql" is
created. Please do not use the database name "mysql" as this database is
used to administrate your MySQL database environment.
NOTE: Do not delete the database named "mysql," the user "yroot," or
your own database user name, as this will permanently disable your
database access.
To add a new database:
1. Log in to the phpMyAdmin tool. If the directory name where you
installed phpMyAdmin is "db," you would go to:
https://www.your-domain.com/db
You will be prompted for your database user name and password.
2. Choose a new database name. Make sure this name has not already been
used.
3. In the phpMyAdmin tool, enter the database name of your choice in the
"Create New Database" field. The name you enter here is the database
name. Click the "Create" button to create the database.
I am sorry but Yahoo! Web Hosting does not provide assistance for
advanced PHP scripts or ODBC.
We encourage you to explore these technologies, and use what you are
comfortable with. However, you would need to troubleshoot any problems
caused by these yourself.
Here are some helpful links to find answers to your advanced scripting
questions or to find useful PHP scripts:
PHP Manual - A very good resource for PHP information:
https://www.php.net/manual/en/index.php
Zend tutorials - A very good resource for PHP tutorials:
https://www.zend.com/zend/tut/
If you are using software or services provided by a company other than
Yahoo! Web Hosting, please consult the product's help documentation for
assistance.
We believe this should resolve your issue. If you have any other
questions, please feel free to contact us again.
Please do not hesitate to reply if you need further assistance.
Regards,
Sanjana
Yahoo! Small Business Support
For online assistance with all Yahoo! Small Business services, please
visit:
https://help.yahoo.com/l/us/yahoo/smallbusiness/
To check the status of any Yahoo! Small Business issues, please visit:
https://www.ysmallbizstatus.com/
For tips, news, and advice about Yahoo! Small Business, follow us on
Twitter and Facebook:
https://twitter.com/ysmallbusiness
https://www.facebook.com/YahooSmallBusiness
Please note: Twitter and Facebook are not official support channels. To
get support for your Yahoo! Small Business service, please log into your
account by visiting:
https://smallbusiness.yahoo.com/contactus
Original Message Follows:
------------------------
Yahoo Id: mo_ly2003
First Name: mohammed
Last Name: AL_Ebdan
Email Address:
mo_ly2003@yahoo.com
Domain Name:
dbsystemssite.com
Comments: BOTH PHP & MYSQL HAS BEEN INSTALLED IN MY WEBSITE, AND NOW I
WANT TO CREATE APLICATIONS PROGRAMED BY VISUAL FOXPRO LANGUAGE THAT
ACCESS MYSQL DATABASE AND THAT CAN BE POSIBLE THROGH ODBC, BUT I TRIED
TO CONNECT MYSQL DATABASE WITH ODBC BY USING (MySQL CONNECTOR /ODBC)
AND I USED THESE INFORMATIONS :
DATA SOURCE NAME: mysql
DESCRIPTION: MYSQL FOR WEBSITE
NAME PIPE:
https://dbsystemssite.com
USER: (MYSQL USER ID)
PASSWORD: (MYSQL PASSWORD)
DATABASE: mysql
BUT WHEN I PUSH (TEST) BUTTON IN THIS CONNECTOR THIS MESSAGE APPEAR
{Connection Faild:[HY000][MySQL][ODBC 5.1 Driver]Can't open named pipe
to host :67.195.145.142 pipe
https://dbsystemssite.com (53)}
SO PLZ IF THERE IS ANYTHING WRONG IN THESE INFORMATIONS TELL ME HOW TO
FIX IT.
REGARDS...
MOHAMMED .L. NURI
Subject: About MySQL Connector/ODBC settings
Browser: Internet Explorer
Operating System: Windows XP
Email Tool: none
Site Building Tool: none
Internet Connection: Dial-up
Permit Test: yes
Permit Publish: yes
واللي يحجي على الـ(phpMyAdmin) واللي طبعاً ميفيدني بأي شي لأن جنت اعرفه كله ما عدا الفقرة اللي باللون الاحمر (اني غيرت لونهة) اللي معناها (اذهب انت وربك يا موسى ...) ههههههههههه
المفضلات