:
- Original Message -
From: Rafael Ribeiro rafaelribeiro...@gmail.com
Subject: Remote Access to MySQL
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
It doesn't work is not a helpful comment
- Original Message -
From: Rafael Ribeiro rafaelribeiro...@gmail.com
Subject: Remote Access to MySQL
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
It doesn't work is not a helpful comment
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro:
Hello List,
I'm not an expertise on MySQL and we are facing a strange issue:
We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1).
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to
and also make sure tcp port of your DB instance has been added to firewall
expeption.
check the iptables for this to verify.
On Mon, Mar 9, 2015 at 2:13 PM, Florian Schaal mailingl...@schaal-24.de
wrote:
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro:
Hello List,
I'm not an expertise on
Hello List,
I'm not an expertise on MySQL and we are facing a strange issue:
We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1).
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
I
On Sat, 07 Mar 2015 21:49:10 -0300, Rafael Ribeiro wrote:
I read a lot of tutorials and tips without success.
What I need to do, to come back to working configuration like oldest
machine, allowing remote connections?
By no means am I an expert, but, while not specific to your question:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --password=* --user=wybo
I get:
ERROR 1045
Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin. When I do that, the only host that appears is localhost.
However, when I browse
Yes, that worked - thank you very much!
On 2014-08-20 22:51, shawn l.green wrote:
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html
Am 04.06.2011 22:30, schrieb Abdul Vali:
Dear All
I have installed MySQL 5 on Ubuntu 10.04 Server. It is working fine but
when I try to access MySQL through any other client using ODBC connector, it
says access is denied for user
On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
I have to move the back-end of an Access application to MySQL, and I’ve run
into one issue that I haven’t been able to solve yet.
The Access database stores dates as text in a “/mm/dd” format. The
problem is that the default value
What about this?
date_format(now(), %Y/%m/%d)
--
João Cândido de Souza Neto
Jerry Schwartz je...@gii.co.jp escreveu na mensagem
news:011201cb9d6c$eccc1e60$c6645b...@co.jp...
I have to move the back-end of an Access application to MySQL, and I've run
into one issue that I haven't been able
-Original Message-
From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk]
Sent: Friday, December 17, 2010 6:07 AM
To: Jerry Schwartz
Cc: 'MySQL'
Subject: Re: Access to MySQL
On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
I have to move the back-end of an Access application to MySQL
-Original Message-
From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Friday, December 17, 2010 6:11 AM
To: mysql@lists.mysql.com
Subject: Re: Access to MySQL
What about this?
date_format(now(), %Y/%m/%d)
[JS] I don't think you can use anything but a constant
Hi Jerry,
On 12/17/2010 09:34, Jerry Schwartz wrote:
-Original Message-
From: Jo�o C�ndido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Friday, December 17, 2010 6:11 AM
To: mysql@lists.mysql.com
Subject: Re: Access to MySQL
What about this?
date_format(now(), %Y/%m/%d)
[JS
-Original Message-
From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com]
Sent: Friday, December 17, 2010 10:35 AM
To: Jerry Schwartz
Cc: j...@consultorweb.cnt.br; mysql@lists.mysql.com
Subject: Re: Access to MySQL
Hi Jerry,
On 12/17/2010 09:34, Jerry Schwartz wrote:
-Original
I have to move the back-end of an Access application to MySQL, and I’ve run
into one issue that I haven’t been able to solve yet.
The Access database stores dates as text in a “/mm/dd” format. The problem
is that the default value is a formula that generates the current date,
formatted
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS
Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience
trying to make it work with MySQL Cluster?
Ben Wiechman
Network Admin
Wisper High Speed Internet
[EMAIL PROTECTED]
]
To: MySQL List mysql@lists.mysql.com
Sent: Wednesday, January 17, 2007 5:23 PM
Subject: ASP.NET Access to MySQL BIT field-Help
OK. I don't recall having a problem with this before, but, how do I
assign
a variable to a MySQL Bit field? I'm trying to set up a CheckBox that is
on
my form
OK. I don't recall having a problem with this before, but, how do I assign
a variable to a MySQL Bit field? I'm trying to set up a CheckBox that is on
my form, and I've tried variations of the following:
FirstTime.Checked = CBool(RS(FirstTime))
FirstTime.Checked = CBool(RS(FirstTime).ToString)
what I have to do to be able to access to mysql on my web server from
other computer?
e.g., I want to access to web server using MySQL Administrator?
I have root access to web server.
As far as I know, mysql server is set up by edfault to be acessed only
through localhost and I have to add
You ought to conect on localhost and create a new user with the specific ip
in the Host field.
[EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
what I have to do to be able to access to mysql on my web server from
other computer?
e.g., I want to access to web server using MySQL
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'm getting error message
2003 (Can't connect to the server...).
On users table I can see in user column 'root' and 'admin' as users and
both have for host 'localhost' (root
I don´t think it´s a problem with firewall.
The error figured out below seems it´s been a username or password problem.
[EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL
U can chk firewall by doing a telnet to the remote host on 3306 (
default ) port .
Error message looks like username/password might be wrong .
[EMAIL PROTECTED] wrote:
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now
username/password might be wrong .
[EMAIL PROTECTED] wrote:
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'm getting error message
2003 (Can't connect to the server...).
On users table I can see in user column 'root
September 2006 4:30 a.m.
To: Praj
Cc: mysql@lists.mysql.com
Subject: Re: how can I access to mysql fro moutside?
I can connect using Putty to the server using port 22.
When I try to connect to the server using port 3306 and got Connection
timed out?
Does it mean the port 3306 is blocked?
-afan
U
be wrong .
[EMAIL PROTECTED] wrote:
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'm getting error message
2003 (Can't connect to the server...).
On users table I can see in user column 'root' and 'admin' as users
Hello all,
I just recieved a mysql server box from another department within my
company.. I would like to get the password for the mysql database for
mysql.. Is this possible in any other way other then using mysql -u
admin -p ?
--
Antoine W. Solomon Jr.
--
MySQL General Mailing List
For
Hello everyone,
Please correct me if my understanding is wrong. Does the implementation
of linked table mentioned on 18.1.11.3. How to Import or Link MySQL
Database Tables to Access?
(http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that
data is actually stored in MySQL and
Bing Du [EMAIL PROTECTED] wrote on 04/04/2006 12:20:23 PM:
Hello everyone,
Please correct me if my understanding is wrong. Does the implementation
of linked table mentioned on 18.1.11.3. How to Import or Link MySQL
Database Tables to Access?
The only way to link tables in MySQL (to use the term from Access) is to
use the Federated database engine. A Federated table physically exists on
one server but virtually exists on another. This is exactly like creating
a linked table.
However, AFAIK, the Federated database engine only
welcome.
We need to move the contents of a bunch of tables
from Access to the
existing tables on MySQL. The target tables in
MySQL already have some
information. So we need some how to map Access
fields to MySQL fields.
Anybody would like to share experience about how you
did your
information. So we need some how to map Access fields to MySQL fields.
Anybody would like to share experience about how you did your migration
and what kind of tool can best meet needs as such?
Thanks much in advance,
Bing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
. Seems there are many options and
tools that can help do it. Guidance and directions are highly welcome.
We need to move the contents of a bunch of tables from Access to the
existing tables on MySQL. The target tables in MySQL already have some
information. So we need some how to map Access fields
that copies the records directly
from Access to mySQL via ODBC. It uses DoCmd.TransferDatabase, if you'd
like to write your own.
I'd be happy to share it.
-- Brett
- Original Message -
From: Bing Du [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, July 28, 2005 9:32 AM
Subject
information. So we need some how to map Access fields to MySQL fields.
Anybody would like to share experience about how you did your migration
and what kind of tool can best meet needs as such?
Thanks much in advance,
Bing
Thanks all who replied. I had no problem transfering Access
Hi All.
Does anyone know of any tools to convert a MS Access file to MySQL from
the Linux command line?
Thanks.
Andrew
Hi Adam.
I need to get all the data.
Andrew
Adam wrote:
Drew,
That's vague. Specifically what do you want from the Access database (e.g.
schema, data, etc.)?
A-
Export as CSV.
MySQL command line client.
Run a script with LOAD DATA INFILE.
Chris
On 5/23/05, Andrew Dixon - MSO.net [EMAIL PROTECTED] wrote:
Hi Adam.
I need to get all the data.
Andrew
Adam wrote:
Drew,
That's vague. Specifically what do you want from the Access
Access databases to MySQL. I'm using the latest
unstable MySQL version and am all setup with user, passwords, and
privileges, so can create and modify databases in MySQL. Searching for
tools to migrate my MS Access databases, I've come across mdbtools, with
which I can see and export the tables
Dear List members,
Having relatively recently moved to GNU/Debian Linux from Windows, I'd
like to move my MS Access databases to MySQL. I'm using the latest
unstable MySQL version and am all setup with user, passwords, and
privileges, so can create and modify databases in MySQL. Searching
Hi all, does anyone use this program MySQL Front 2.8 to convert access to
mysql? I have been looking in the menus and cant see anything to do it. Any
other programes that do the job?
Thanks a lot for any advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Rodney,
Did you EVER get a response to your question ?
Im keenly interested to know the answer.
M i l e s
+++
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo/msn:
I am new to MYSQL and I want to set-up a database with two or more tables that
need to be linked. I come from a basic MS Access background, and in Access
linking two tables is done by creating a relationship. Is it done the same
way in MYSQL? If so, could someone please shed some light on this
/04 12:18:37 AM
please include the query, you are using with no success and also
specify the
version of your mysql.
Nitin
- Original Message -
From: Ed Reed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
I'm
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: Ed Reed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
I'm coverting an Access
/04 12:18:37 AM
please include the query, you are using with no success and also
specify the
version of your mysql.
Nitin
- Original Message -
From: Ed Reed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
I'm
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query
Greeting to the list.
I am running MS Access as a front end to data stored on MySql in
a Redhat 7.3 box.
I have about 95% functionality so far!
(The Database is of a Youth Soccer league).
I am having one problem though with one of my tables.
The table seems to double itself when I
Are you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
Original Message
On 3/4/04, 1:57:15 PM, Steve Siesel [EMAIL PROTECTED] wrote regarding MS
Access and MySql:
Greeting
and MySql
Are you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
Original Message
On 3/4/04, 1:57:15 PM, Steve Siesel [EMAIL PROTECTED] wrote regarding MS
Access and MySql
What is `special` about this one? If you are using ODBC links why are you
needing to convert the table? MS Access is merely your GUI to the
underlying data.
Original Message
On 3/4/04, 2:28:31 PM, Steve Siesel [EMAIL PROTECTED] wrote regarding Re:
MS Access and MySql:
I am using ODBC
The Database was originally made in Access
- Original Message -
From: [EMAIL PROTECTED]
To: Steve Siesel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 3:35 PM
Subject: Re: MS Access and MySql
What is `special` about this one? If you are using ODBC links why
to view the tables?
Original Message
On 3/4/04, 2:47:51 PM, Steve Siesel [EMAIL PROTECTED] wrote regarding Re:
MS Access and MySql:
The Database was originally made in Access
- Original Message -
From: [EMAIL PROTECTED]
To: Steve Siesel [EMAIL PROTECTED]
Cc: [EMAIL
PROTECTED]
Sent: Thursday, March 04, 2004 2:57 PM
Subject: MS Access and MySql
Greeting to the list.
I am running MS Access as a front end to data stored on MySql in
a Redhat 7.3 box.
I have about 95% functionality so far!
(The Database is of a Youth Soccer league).
I am having one problem though
Hello, Could someone help me with a tip on how I can convert my old Access DBs to
MySQL?
Regards
/Jonas
Jonas Lindén wrote:
Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL?
Hello Jonas, I managed to do this out of Access by exporting the tables
to a MyODBC DSN.
Please check the column types later - don't know if they are all
converted correctly.
Regards
I use SQLyog - http://www.webyog.com/sqlyog
It has a pretty good ODBC Import Wizard.
Karam
--- Jonas_Lindén [EMAIL PROTECTED] wrote:
Hello, Could someone help me with a tip on how I can
convert my old Access DBs to MySQL?
Regards
/Jonas
__
Do you Yahoo
[mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 25. Februar 2004 09:33
An: [EMAIL PROTECTED]
Betreff: Transfering from access to MySQL?
Hello, Could someone help me with a tip on how I can convert my old Access
DBs to MySQL?
Regards
/Jonas
--
MySQL General Mailing List
For list archives: http
At 02:32 2/25/2004, Jonas Lindén wrote:
Hello, Could someone help me with a tip on how I can convert my old Access
DBs to MySQL?
Regards
/Jonas
I've had some success with Cynergi.net's ExportSQL script
http://www.Cynergi.net/exportsql/
Start Here to Find It Fast! - http://www.US
There was some discussion in December of converting MS Access databases to
Mysql and the DBManager program was recommended. I have DBManager running
and select Tools=Data Management=Import/Export Wizards, but the
command is greyed out and won't activate. I am using Office 2000 and I
have made
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data
: Sunday, December 21, 2003 11:00 AM
To: [EMAIL PROTECTED]
Subject: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would like to know
the best way to do this. I was going to write an asp or php script that
would read the MS Access db row by row and insert into the MySql db
An: [EMAIL PROTECTED]
Betreff: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would
like to know the best way to do this. I was going to write an
asp or php script that would read the MS Access db row by row
and insert into the MySql db row by row
://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
-Ursprüngliche Nachricht-
Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 21. Dezember 2003 19:00
An: [EMAIL PROTECTED]
Betreff: Convert MS Access to MySql
I need
Thanks everyone for great advice!
Tom's question below is also interesting.
Also, are there data compatibility/integrity issues moving from Windows/MS
Access to Linux/MySql? I know that Linux is case sensitive and MySql wants
dates to be stored as -mm-dd. Does anyone know of other issues
I need to convert an MS Access database to MySql. I would like to know the
best way to do this. I was going to write an asp or php script that would
read the MS Access db row by row and insert into the MySql db row by row. Is
that the only way to move the data from the one db to the other?
Many
Subject: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would like to know the
best way to do this. I was going to write an asp or php script that would
read the MS Access db row by row and insert into the MySql db row by row.
Is
that the only way to move
Arthur
On converting data from MS Access. I've done this several times myself, and
found the easiest way is to:
1. Create your mySQL database tables
2. Define a DSN (ODBC Connection) from your workstation to the mySQL
database
3. Link the mySQL tables into your MS Access database
4. Copy the
On Wed, 22 Oct 2003 14:00:13 +0800
Hiu Yen Onn [EMAIL PROTECTED] wrote:
i want to create a user who access from internet remotely to my db (outside
firewall)?
what is the solution then? how can i define the user accoutn?
[EMAIL PROTECTED]
if your firewall allows other users to connect to
Or just use an ssh tunnel to access it and then the firewall stays intact, and with
the tunnel, it will be a local user, and it can come from any
address, and all the database is concerned with is localhost access.
Kelley
Antony Dovgal wrote:
On Wed, 22 Oct 2003 14:00:13 +0800
Hiu Yen Onn
i want to create a user who access from internet remotely to my db (outside
firewall)?
what is the solution then? how can i define the user accoutn?
[EMAIL PROTECTED]
Cheers,
yenonn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi everyone,
I'm using an Access database and trying to use a macro to export to a text
file for mysql. It's no problem to export to a text file, but it's in a
format that mysql won't recognize. I know it just needs to be formatted on
export a little but the macro options aren't available for
Use myodbc
www.mysql.com/downloads/api-myodbc.html
Best regards
On Fri, 10 Oct 2003 12:34:48 -0400, Montagna, Dan wrote
Hi everyone,
I'm using an Access database and trying to use a macro to export to
a text file for mysql. It's no problem to export to a text file,
but it's in a
all ears.
Also, I was wondering if it's possible to use Berkeley DB tools and
libraries to access MySQL data files, which are set to use BDB as the
storage engine. If it is, can somebody point me at some examples (except
what's in the source already).
I have read several posts on the list from
Jeremy Proffitt wrote:
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I
Dumb Question. I need to move my data from their current access database to my new
MySQL server through an ODBC connection. The tables on both ends are set up
identially. I have added a linked table to the access database called EXPARTAB1. The
data is in EXPARTAB. I tried: INSERT INTO
Has anyone ever used a non-ODBC, 3rd party ADO connector to MySQL?
Any suggestions would be greatly appreciated. My client does not wish to use
ODBC.
/tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi
I am running mysql 4 on linux server. I want to have a remote access on it. what are
the setting that i need to do this.
--jatin
http://mcabca.cjb.net
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Jatin,
I am running mysql 4 on linux server. I want to have a remote access
on it. what are the setting that i need to do this.
You need to log into your MySQL server and grant access to your
databases from wherever you want to grant access, like:
mysql GRANT ALL ON *.* TO 'remoteuser
Hi.
I'm using MySQL on my web host. I'm a dba of the db's that I create, but I
have no access to the mysql db. I can create users (GRANT USAGE ON my_db ...
works), but I don't know how to get rid of them.
I searched the manual, and the only reference to removing users that I could
find
Message-
From: Stephan Samuel [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 5:39 PM
To: [EMAIL PROTECTED]
Subject: Delete user/no access to mysql db
Hi.
I'm using MySQL on my web host. I'm a dba of the db's that I create, but I
have no access to the mysql db. I can create users
AND hostname. In case
you want to be able to access mysql from anywhere then you will need an ' % '
entry for the host. That would make your statement something like:
GRANT ALL ON database TO 'root'@'%' IDENTIFIED BY 'password';
Best regards
Nils Valentin
Tokyo/Japan
2003 6 16 08:28Renato
. Talk with your ISP to give all others, from
the Internet, access to your MySQL port.
The poor Windows is not guilty for this. It has too much guilty for the
other problems...
Good Luck,
Iulian
- Original Message -
From: Renato [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]; [EMAIL
recall it was
something commented out, perhaps the port number if I recall correctly.
-Shane
- Original Message -
From: Renato [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:11 PM
Subject: RES: Remote access to MySQL
I have
: MySQL LIST [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:42 PM
Subject: Re: Remote access to MySQL
Yes, indeed. You don't have a firewall.
But the firewall from the Internet Service Provider's computer prohibits
the
access of the others users from the Internet to the port of your MySQL
: RES: Remote access to MySQL
I have all privileges to all the databases and tables, with user
'root'.
User 'root' likely doesn't have access from the desired IP.
Users are configured by both name and approved hosts. Try this:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2+PHP) and e-mail e ftp server.
Everything works perfectly accessing from my INTRANET (local network). I
obtain access to MySQL without problems.
In Internet, all servers works
Digital
www.becomingdigital.com
- Original Message -
From: Renato [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 19:28
Subject: Remote access to MySQL
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2
On Friday 28 March 2003 01:02, Rich Allen wrote:
i found in the ODBC faq how to link from mysql to access, can this be
done in reverse? link from access to mysql?
What do you mean by that?
MySQL can be used as a backend for Access, i.e. you can create an Access
application that could
iH
i found in the ODBC faq how to link from mysql to access, can this be
done in reverse? link from access to mysql?
thanks
- hcir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, 2003 4:54 PM
Subject: Migrating Microsoft Access to MySQL
I am with a small business in Southern California that would like to
migrate
our MS Access databases to MySQL server. Are their any computer service
companies who can help me
I am with a small business in Southern California that would like to migrate
our MS Access databases to MySQL server. Are their any computer service
companies who can help me?
-
Before posting, please check:
http
there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html
It has a very good ODBC import tool which will import your Access data to
MySQL without any fuss and its FREE!!!
Insane
- Original Message -
From: Edward Kim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
1 - 100 of 321 matches
Mail list logo