Here's the basics for MySQL database access (seven lines total:
use mysql;
create database myDB;
insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER',
'Y','Y','Y','Y','N','N','N','N','N','N');
insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N');
insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y',
'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
quit
-----Original Message-----
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:26 AM
To: Andrew Hazen; [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname
corresponding to the XPwkst w/ODBC.
-----Original Message-----
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:02 AM
To: [EMAIL PROTECTED]
Subject: MyODBC arrrgghh!
Alright, I'm feeling pretty clueless on this one.
I've downloaded and installed MyODBC.
I am trying to go from my local WinXP to my database on a unix/apache
webserver. (I want to use CodeCharge to build a site).
I have asked my ISP to grant remote access and he says he has. I can
access from a phpMyAdmin on one webserver to a db on the other webserver
fine. But when I try to access with ODBC, using the same
username/password it's no go.
????????
mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
