Re: Remote Access to MySQL

[patrick]

Check your border router access list.

Patrick Sherrill
patr...@coconet.com

Coconet Corporation
SW Florida's First ISP

(239) 540-2626 Office
(239) 770-6661 Cell

Confidentiality Notice.  This email message, including any attachments, 
is for the sole use of the intended recipient(s) and may contain 
confidential and privileged information.  Any unauthorized review, use, 
disclosure or distribution is prohibited.  If you are not the intended 
recipient, please contact the sender by reply email and destroy all 
copies of the original message.


On 3/9/2015 8:54 AM, Johan De Meersman wrote:

- Original Message -

From: "Rafael Ribeiro" 
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 :-) What error message are you 
getting? Can you connect to other services on the host? Can you connect from a local 
shell?




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Remote Access to MySQL

[Johan De Meersman]

- Original Message -
> From: "Rafael Ribeiro" 
> 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 :-) What error message are you 
getting? Can you connect to other services on the host? Can you connect from a 
local shell?


-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Remote Access to MySQL

[Pothanaboyina Trimurthy]

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 
wrote:

> 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 connect to mysql remotely, from external IPs.
>>
>> 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?
>>
>
> did you check "bind-address" in your my.cnf?
>
> regards
> Florian
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>


-- 
Thanks,
Trimurthy P
Mobile : +91 97397 64298
http://mysqlinternals.blogspot.in/
https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b

Re: Remote Access to MySQL

[Florian Schaal]

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 connect to mysql remotely, from external IPs.

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?


did you check "bind-address" in your my.cnf?

regards
Florian


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Remote Access to MySQL

[Thufir]

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:

http://dba.stackexchange.com/a/3496/52307

shows how to grant remote access for different users.  I'm not quite sure 
what the "netblock" means, but I think that's so that it only allows 
connections from certain ip address ranges.  (Probably that can be 
spoofed, anyhow?)

I would start with granting all to a specific user, make sure to use the 
%, which, I think, allows remote connections.


HTH,

Thufir


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Remote Access to MySQL

[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 connect to mysql remotely, from external IPs.

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?

Thanks in advanced!

Atenciosamente,
Rafael Ribeiro – CEO XPS NetWorks Group

rafael.ribe...@xpsnetworks.net

Skype: xpsnetworks
Celular: 11 98909-1838 / 51 9201-6908

11 3522-5293
21 3527-0235
51 4063-9078


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

RE: Access to MySQL

[Jerry Schwartz]

>-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 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 as a default value.
>>
>
>You are correct with one exception that was already mentioned earlier:
>the TIMESTAMP storage type.
>
>from http://dev.mysql.com/doc/refman/5.1/en/create-table.html
>###
>The DEFAULT clause specifies a default value for a column. With one
>exception, the default value must be a constant; it cannot be a function
>or an expression. This means, for example, that you cannot set the
>default for a date column to be the value of a function such as NOW() or
>CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as
>the default for a TIMESTAMP column. See Section 10.3.1.1, "TIMESTAMP
>Properties".
>###
>
>However, nothing says you can't use a function or other computation in a
>TRIGGER to set the default value to an empty column of a new row to
>whatever you wanted it to be.
>
>http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html
>
>I know it's a workaround but it will keep the default value management
>out of your application and inside the database.
>
[JS] Thanks. I did have that in the back of my mind, but to be honest I never 
used a trigger.

I'll have to think about this.


Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com



>--
>Shawn Green
>MySQL Principal Technical Support Engineer
>Oracle USA, Inc.
>Office: Blountville, TN
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Access to MySQL

[Shawn Green (MySQL)]

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] I don't think you can use anything but a constant as a default value.



You are correct with one exception that was already mentioned earlier: 
the TIMESTAMP storage type.


from http://dev.mysql.com/doc/refman/5.1/en/create-table.html
###
The DEFAULT clause specifies a default value for a column. With one 
exception, the default value must be a constant; it cannot be a function 
or an expression. This means, for example, that you cannot set the 
default for a date column to be the value of a function such as NOW() or 
CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as 
the default for a TIMESTAMP column. See Section 10.3.1.1, “TIMESTAMP 
Properties”.

###

However, nothing says you can't use a function or other computation in a 
TRIGGER to set the default value to an empty column of a new row to 
whatever you wanted it to be.


http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html

I know it's a workaround but it will keep the default value management 
out of your application and inside the database.


--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Access to MySQL

[Jerry Schwartz]

>-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 as a default value.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com



>--
>João Cândido de Souza Neto
>
>""Jerry Schwartz""  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 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 as text. In Access, it looks like
>
>
>
>'=Format$(Now(),\"/mm/dd\")'
>
>
>
>This construct is used throughout the table definitions.
>
>
>
>Is there any alternative to setting the default to something else (NULL, for
>example) and moving the "default" into the application code? That would be a
>significant PITA.
>
>
>
>Regards,
>
>
>
>Jerry Schwartz
>
>Global Information Incorporated
>
>195 Farmington Ave.
>
>Farmington, CT 06032
>
>
>
>860.674.8796 / FAX: 860.674.8341
>
>E-mail:  <mailto:je...@gii.co.jp> je...@gii.co.jp
>
>Web site:  <http://www.the-infoshop.com/> www.the-infoshop.com
>
>
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Access to MySQL

[Jerry Schwartz]

>-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, 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 as text. In Access, it looks like
>>
>> '=Format$(Now(),\"/mm/dd\")'
>>
>> This construct is used throughout the table definitions.
>>
>> Is there any alternative to setting the default to something else (NULL, 
>> for
>example) and moving the "default" into the application code? That would be a
>significant PITA.
>
>If a 32-bit date range is enough, then you can use the timestamp data type.
>That supports having the current time as the default value. See also
>http://dev.mysql.com/doc/refman/5.1/en/timestamp.html
>
[JS] Unfortunately, I have to keep that field as a text field.

Also, a timestamp would change every time a record is updated and you can only 
have one per record.

Thanks for trying.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com



>Regards,
>Jesper




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Access to MySQL

[Jo�o C�ndido de Souza Neto]

What about this?

date_format(now(), "%Y/%m/%d")

-- 
João Cândido de Souza Neto

""Jerry Schwartz""  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 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 as text. In Access, it looks like



'=Format$(Now(),\"/mm/dd\")'



This construct is used throughout the table definitions.



Is there any alternative to setting the default to something else (NULL, for 
example) and moving the "default" into the application code? That would be a 
significant PITA.



Regards,



Jerry Schwartz

Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032



860.674.8796 / FAX: 860.674.8341

E-mail:   je...@gii.co.jp

Web site:   www.the-infoshop.com






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Access to MySQL

[Jesper Wisborg Krogh]

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 is a formula that generates the current 
> date, formatted as text. In Access, it looks like
> 
> '=Format$(Now(),\"/mm/dd\")'
> 
> This construct is used throughout the table definitions.
> 
> Is there any alternative to setting the default to something else (NULL, for 
> example) and moving the “default” into the application code? That would be a 
> significant PITA.

If a 32-bit date range is enough, then you can use the timestamp data type. 
That supports having the current time as the default value. See also 
http://dev.mysql.com/doc/refman/5.1/en/timestamp.html

Regards,
Jesper

Access to MySQL

[Jerry Schwartz]

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 as text. In Access, it looks like

 

'=Format$(Now(),\"/mm/dd\")'

 

This construct is used throughout the table definitions.

 

Is there any alternative to setting the default to something else (NULL, for 
example) and moving the “default” into the application code? That would be a 
significant PITA.

 

Regards,

 

Jerry Schwartz

Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

 

860.674.8796 / FAX: 860.674.8341

E-mail:   je...@gii.co.jp 

Web site:   www.the-infoshop.com

 

Re: From MS Access to MySQL

[curtis]

> 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 Access fields are:
>
> Currency (formatted to £ with two decimal places e.g. £10.00)

DECIMAL(nnn,2)
You'll have to add your own signage ($,£, etc.) upon extraction.

>
> Currency (formatted to £#,##0.00;(£#,##0.00)
>
> Date/Time (with a Now() default)

>From the manual:

 The DATETIME type is used when you need values that contain both date and
time information. MySQL retrieves and displays DATETIME values in
'-MM-DD HH:MM:SS' format. The supported range is '1000-01-01
00:00:00' to '-12-31 23:59:59'.


>
> Yes/No

enum() or set()
>
> Number (as a percentage)

decimal()

>
> Number (with field size of Double and Decimal Places of 2)
>

decimal()

> What would be the equivalent of the above for MySQL 5.1.35? If there
> isn't an equivalent for some, how can I work around it considering
> that the Access version of the database is already used in an ASP
> website?
>

see: http://dev.mysql.com/doc/refman/5.1/en/data-types.html

--Curtis


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

From MS Access to MySQL

[Matthew Stuart]

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 Access fields are:

Currency (formatted to £ with two decimal places e.g. £10.00)

Currency (formatted to £#,##0.00;(£#,##0.00)

Date/Time (with a Now() default)

Yes/No

Number (as a percentage)

Number (with field size of Double and Decimal Places of 2)

What would be the equivalent of the above for MySQL 5.1.35? If there  
isn't an equivalent for some, how can I work around it considering  
that the Access version of the database is already used in an ASP  
website?


Thanks.

Mat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: ASP.NET Access to MySQL BIT field????-Help

[Jesse]

Since no one seemed able to answer my question, I went looking elsewhere, 
and found the solution.  Just wanted to share with you, in case anyone else 
is having the problem.  I realize now (too late), that I should have posted 
this on the MySQL .NET list.  I'm sure someone would have answered there. 
Anyway...


Apparently, MySQL Stores a BIT value as a character.  Chr(0) = False, and 
Chr(1) = True.  Once I discovered this, I was easily able to do a 
FirstTime.Checked = (RS("FirstTime") = Chr(1)), and it worked perfectly.


Jesse
- Original Message - 
From: "Jesse" <[EMAIL PROTECTED]>

To: "MySQL List" 
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, and I've tried variations of the following:

FirstTime.Checked = CBool(RS("FirstTime"))
FirstTime.Checked = CBool(RS("FirstTime").ToString)
FirstTime.Checked = RS("FirstTime")
FirstTime.Checked = Convert.ToBoolean(RS("FirstTime"))

I believe that all of them give the error, "String was not recognized as a
valid Boolean".  When I view the field value in SQL Manager 2005 Lite, It
presents a check box for the field value.  When I view it through the 
MySQL

Query Browser, it presents the value as b'1'

Any hints?  I'm sure this is a basic issue, but I just can't seem to find 
a

way to do it.

Thanks,
Jesse

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ASP.NET Access to MySQL BIT field????-Help

[Jesse]

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)
FirstTime.Checked = RS("FirstTime")
FirstTime.Checked = Convert.ToBoolean(RS("FirstTime"))

I believe that all of them give the error, "String was not recognized as a
valid Boolean".  When I view the field value in SQL Manager 2005 Lite, It
presents a check box for the field value.  When I view it through the MySQL
Query Browser, it presents the value as b'1'

Any hints?  I'm sure this is a basic issue, but I just can't seem to find a
way to do it.

Thanks,
Jesse 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how can I access to mysql fro m"outside"?

[Praj]

Okie there might be a entry in mysql.user table having username and 
password column as blank .


That might result in Access denied when u use password .

Try this ,

use mysql ; select * from user where user='';

if so , Delete those entries .

[EMAIL PROTECTED] wrote:


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 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 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 has tough localhost.localdomains
too)

After some googling I think I have to create a user (e.g. 'admin2') and
grant:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%'
  -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

(123.123.123.% means I'll access from IPs that start with 123.123.123
right?)
mysql> FLUSH PRIVILEGES;

Is this all? Do I have to do something else? I do have to restart mysql
server, right?

Back to top: right now, when I try to access, I'm getting error message
2003. Since I didn't get error "Access denied for
[EMAIL PROTECTED]",
I think, even I have correct user/pass, someting else will stop me
(firewall, 3306 is blocked,...), right?
How can I check this?

Thanks for any help.

-afan






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: how can I access to mysql fro m"outside"?

[Quentin Bennett]

>>Does it mean the port 3306 is blocked?

Not necessarily - it could mean that MySQL didn't respond as your telnet client 
expected (which is not surprising!).

The "Access denied for [EMAIL PROTECTED]" message comes from the server, so 
there will be something wrong with your mysql.user or mysql.db tables that 
results in another entry being used before this one.

Do a 'select user, host, password from user' and go through each entry in the 
order that they come out and see if another entry can match your login - the 
manual has a good section on how the MySQL server does this.

As another tip, I've found that 

$ mysqladmin flush-privileges

is more reliable than

mysql> FLUSH PRIVILEGES;

I know that they should both result in the same thing, but my experience is not 
so.

HTH

Quentin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 20 September 2006 4:30 a.m.
To: Praj
Cc: mysql@lists.mysql.com
Subject: Re: how can I access to mysql fro m"outside"?


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 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 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 has tough localhost.localdomains
>> too)
>>
>>After some googling I think I have to create a user (e.g. 'admin2') and
>>grant:
>>mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%'
>>-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
>>
>>(123.123.123.% means I'll access from IPs that start with 123.123.123
>> right?)
>>mysql> FLUSH PRIVILEGES;
>>
>>Is this all? Do I have to do something else? I do have to restart mysql
>>server, right?
>>
>>Back to top: right now, when I try to access, I'm getting error message
>>2003. Since I didn't get error "Access denied for
>> [EMAIL PROTECTED]",
>>I think, even I have correct user/pass, someting else will stop me
>>(firewall, 3306 is blocked,...), right?
>>How can I check this?
>>
>>Thanks for any help.
>>
>>-afan
>>
>>
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If received in error you are asked to destroy this email
and contact the sender immediately. Your assistance is appreciated.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how can I access to mysql fro m"outside"?

[afan]

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 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 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 has tough localhost.localdomains
>> too)
>>
>>After some googling I think I have to create a user (e.g. 'admin2') and
>>grant:
>>mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%'
>>-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
>>
>>(123.123.123.% means I'll access from IPs that start with 123.123.123
>> right?)
>>mysql> FLUSH PRIVILEGES;
>>
>>Is this all? Do I have to do something else? I do have to restart mysql
>>server, right?
>>
>>Back to top: right now, when I try to access, I'm getting error message
>>2003. Since I didn't get error "Access denied for
>> [EMAIL PROTECTED]",
>>I think, even I have correct user/pass, someting else will stop me
>>(firewall, 3306 is blocked,...), right?
>>How can I check this?
>>
>>Thanks for any help.
>>
>>-afan
>>
>>
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how can I access to mysql fro m"outside"?

[Praj]

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 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 has tough localhost.localdomains too)

After some googling I think I have to create a user (e.g. 'admin2') and
grant:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%'
   -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

(123.123.123.% means I'll access from IPs that start with 123.123.123 right?)
mysql> FLUSH PRIVILEGES;

Is this all? Do I have to do something else? I do have to restart mysql
server, right?

Back to top: right now, when I try to access, I'm getting error message
2003. Since I didn't get error "Access denied for [EMAIL PROTECTED]",
I think, even I have correct user/pass, someting else will stop me
(firewall, 3306 is blocked,...), right?
How can I check this?

Thanks for any help.

-afan






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how can I access to mysql fro m"outside"?

[Jo�o C�ndido de Souza Neto]

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 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 has tough localhost.localdomains too)
>
> After some googling I think I have to create a user (e.g. 'admin2') and
> grant:
> mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%'
>-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
>
> (123.123.123.% means I'll access from IPs that start with 123.123.123 
> right?)
> mysql> FLUSH PRIVILEGES;
>
> Is this all? Do I have to do something else? I do have to restart mysql
> server, right?
>
> Back to top: right now, when I try to access, I'm getting error message
> 2003. Since I didn't get error "Access denied for [EMAIL PROTECTED]",
> I think, even I have correct user/pass, someting else will stop me
> (firewall, 3306 is blocked,...), right?
> How can I check this?
>
> Thanks for any help.
>
> -afan
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how can I access to mysql fro m"outside"?

[afan]

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 has tough localhost.localdomains too)

After some googling I think I have to create a user (e.g. 'admin2') and
grant:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

(123.123.123.% means I'll access from IPs that start with 123.123.123 right?)
mysql> FLUSH PRIVILEGES;

Is this all? Do I have to do something else? I do have to restart mysql
server, right?

Back to top: right now, when I try to access, I'm getting error message
2003. Since I didn't get error "Access denied for [EMAIL PROTECTED]",
I think, even I have correct user/pass, someting else will stop me
(firewall, 3306 is blocked,...), right?
How can I check this?

Thanks for any help.

-afan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: access to mysql from outside

[Jo�o C�ndido de Souza Neto]

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 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 permission to specific IP to be able
> to access it.
>
> please, how?
>
> on google I found this:
>
> "If you CAN connect to the databse from the local host, but you get a
> can't connect message from a remote host,
> you meight want to check, if the "skip-networking" option in
> /etc/mysql/my.conf is enabled.
>
> the access from a remote host is disabled by default using:
>
> bind-address = 127.0.0.1
>
> If the the access from a remote host is needed you should comment this
> line and also:
>
> skip-networking"
>
> first, I dont have /etc/mysql/my.conf file (mandrake 10.0) but have
> /etc/my.cnf and there skip-networking is already commented. and there is
> no line with bind-address?
>
> Found this too:
> "To restrict the access to port 3306 you may use in /etc/hosts.deny:
>
> mysql: ALL
>
> and in /etc/hosts.allow:
>
> mysql: IP_ADDRESS_ALLOWED_1 IP_ADDRESS_ALLOWED_2"
>
> is this enough?
>
> thanks for any help.
>
> -afan 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

access to mysql from outside

[afan]

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 permission to specific IP to be able
to access it.

please, how?

on google I found this:

"If you CAN connect to the databse from the local host, but you get a
can't connect message from a remote host,
you meight want to check, if the "skip-networking" option in
/etc/mysql/my.conf is enabled.

the access from a remote host is disabled by default using:

bind-address = 127.0.0.1

If the the access from a remote host is needed you should comment this
line and also:

skip-networking"

first, I dont have /etc/mysql/my.conf file (mandrake 10.0) but have
/etc/my.cnf and there skip-networking is already commented. and there is
no line with bind-address?

Found this too:
"To restrict the access to port 3306 you may use in /etc/hosts.deny:

mysql: ALL

and in /etc/hosts.allow:

mysql: IP_ADDRESS_ALLOWED_1 IP_ADDRESS_ALLOWED_2"

is this enough?

thanks for any help.

-afan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to get access to mysql db with in mysql server

[Antoine Solomon]

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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: link MS Access to MySQL?

[Bing Du]

> 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 supports direct MySQL
> to MySQL sharing. It is not ready to do MySQL to  yet.
>
> http://dev.mysql.com/doc/refman/5.0/en/federated-description.html
> http://dev.mysql.com/doc/refman/5.0/en/federated-limitations.html
>

Interesting, thanks much for the information, Shawn.

Bing

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: link MS Access to MySQL?

[SGreen]

"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?"
> (http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that
> data is actually stored in MySQL and tables in Access are links pointing
> to tables in MySQL?
> 
> What I want is do linked table the other way, which is store data in
> Access and make tables in MySQL links that point to tables in Access? Is
> it possible and how?
> 
> Thanks in advance,
> 
> Bing
> 

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 supports direct MySQL 
to MySQL sharing. It is not ready to do MySQL to  yet.

http://dev.mysql.com/doc/refman/5.0/en/federated-description.html
http://dev.mysql.com/doc/refman/5.0/en/federated-limitations.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

link MS Access to MySQL?

[Bing Du]

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 tables in Access are links pointing
to tables in MySQL?

What I want is do linked table the other way, which is store data in
Access and make tables in MySQL links that point to tables in Access?   Is
it possible and how?

Thanks in advance,

Bing

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: migrate Access to MySQL

[Karam Chand]

http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027&showtopic=1536&view=getnewpost

Karam

--- Bing Du <[EMAIL PROTECTED]> wrote:

> Hello,
> 
> I've been looking around for a while.  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 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/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 




__ 
Yahoo! Mail for Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: migrate Access to MySQL

[Bing Du]

> Hello,
>
> I've been looking around for a while.  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 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 tables to
MySQL as they are.  My problem is we need to munge the data first before
they can be loaded into MySQL.  I see coding is inevitable.

Bing

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: migrate Access to MySQL

[avrombay]

I've used the exportSQL script
(http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt) to dump tables
out of Access into a file that can be imported by mySQL. Since a lot of my
work is porting Access apps to web apps, it comes in very handy.

I've also written a really simple VB script 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: 
Sent: Thursday, July 28, 2005 9:32 AM
Subject: migrate Access to MySQL


Hello,

I've been looking around for a while.  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 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/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: migrate Access to MySQL

[Kieran Kelleher]

Make a select query in Access whose result mimics the table layout of 
the target table in MySQL. Then export the query as tab-delimited text 
and import into the MySQL table using LOAD DATA INFILE.


On Jul 28, 2005, at 12:32 PM, Bing Du wrote:


Hello,

I've been looking around for a while.  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 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/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

migrate Access to MySQL

[Bing Du]

Hello,

I've been looking around for a while.  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 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/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access to MySQL from Linux command line

[Chris Faulkner]

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 database (e.g.
> >schema, data, etc.)?
> >
> >A-
> >
> >
> >
> >
> 
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access to MySQL from Linux command line

[Andrew Dixon - MSO.net]

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- 
 

 

Access to MySQL from Linux command line

[Andrew Dixon - MSO.net]

Hi All.

Does anyone know of any tools to convert a MS Access file to MySQL from 
the Linux command line?


Thanks.

Andrew

Re: access to mysql in linux

[Gleb Paharenko]

Hello.



It is a frequently asked question. Search in the list. For example see

thread:

  http://lists.mysql.com/mysql/160391







Sebastian Luque <[EMAIL PROTECTED]> wrote:

> 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 for

> tools to migrate my MS Access databases, I've come across mdbtools, with

> which I can see and export the tables to csv, but the process of getting

> them into MySQL is tedious and cumbersome. The script mdb-schema in

> mdbtools can export the tables to other DBMS formats, excluding MySQL

> unfortunately.

> 

> Can somebody please suggest other, more convenient, tools (free

> preferably) to make this transition?

> 

> Best wishes,



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

access to mysql in linux

[Sebastian Luque]

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 for
tools to migrate my MS Access databases, I've come across mdbtools, with
which I can see and export the tables to csv, but the process of getting
them into MySQL is tedious and cumbersome. The script mdb-schema in
mdbtools can export the tables to other DBMS formats, excluding MySQL
unfortunately.

Can somebody please suggest other, more convenient, tools (free
preferably) to make this transition?

Best wishes,
-- 
Sebastian Luque


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Converting access to mysql db

[EWAGW]

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
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie: Transitioning from MS Access to MYSQL

[m i l e s]

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: magikmiles
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie: Transitioning from MS Access to MYSQL

[Rodney Kanno]

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 matter? Is 
there a good MYSQL book out there for someone with my background? Thanks!

Rodney


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access to MySQL query problem

[Ed Reed]

I already specified the version, 4.1.1. My problem query is this,
 
SELECT Item 
FROM StoredProc 
GROUP BY Item 
HAVING (First(User)="Gus");

my StoredProc query is a simple one,
 
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;

Any Thoughts?
 
Thanks
 
>>> "Nitin Mehta" <[EMAIL PROTECTED]> 3/29/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 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 get results that
> look like this
>
> Item Op User
> 2751 2 Dude
> 2751 3 Aguy
> 4785 1 Dude
> 4785 2 Gus
> 5623 1 Dude
> 5623 2 Gus
> 5654 1 Gus
> 5654 2 Aguy
>
> I then query these results to get only the Items for a user when the
> specified user is the first person for that Item ID, for example. If
I
> query the results for Dude Items 2751, 4785 & 5623 are returned. If
I
> query the results for Gus Item 5654 are return but not Items 4785 or
> 5623. If I query the results for Aguy no Items are returned.
>
> Does anyone have any thoughts on this?
>
> Thanks
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access to MySQL query problem

[Ed Reed]

I already specified the version, 4.1.1. My problem query is this,
 
SELECT Item 
FROM StoredProc 
GROUP BY Item 
HAVING (First(User)="Gus");

my StoredProc query is a simple one,
 
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;

Any Thoughts?
 
Thanks
 
>>> "Nitin Mehta" <[EMAIL PROTECTED]> 3/29/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 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 get results that
> look like this
>
> Item Op User
> 2751 2 Dude
> 2751 3 Aguy
> 4785 1 Dude
> 4785 2 Gus
> 5623 1 Dude
> 5623 2 Gus
> 5654 1 Gus
> 5654 2 Aguy
>
> I then query these results to get only the Items for a user when the
> specified user is the first person for that Item ID, for example. If
I
> query the results for Dude Items 2751, 4785 & 5623 are returned. If
I
> query the results for Gus Item 5654 are return but not Items 4785 or
> 5623. If I query the results for Aguy no Items are returned.
>
> Does anyone have any thoughts on this?
>
> Thanks
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access to MySQL query problem

[Nitin Mehta]

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 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 get results that
> look like this
>
> Item  OpUser
> 2751  2 Dude
> 2751  3 Aguy
> 4785  1 Dude
> 4785  2 Gus
> 5623  1 Dude
> 5623  2 Gus
> 5654  1 Gus
> 5654  2 Aguy
>
> I then query these results to get only the Items for a user when the
> specified user is the first person for that Item ID, for example. If I
> query the results for Dude Items 2751, 4785 & 5623 are returned. If I
> query the results for Gus Item 5654 are return but not Items 4785 or
> 5623. If I query the results for Aguy no Items are returned.
>
> Does anyone have any thoughts on this?
>
> Thanks
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Access to MySQL query problem

[Ed Reed]

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 get results that
look like this

Item  OpUser
2751  2 Dude
2751  3 Aguy
4785  1 Dude
4785  2 Gus
5623  1 Dude
5623  2 Gus
5654  1 Gus
5654  2 Aguy
 
I then query these results to get only the Items for a user when the
specified user is the first person for that Item ID, for example. If I
query the results for Dude Items 2751, 4785 & 5623 are returned. If I
query the results for Gus Item 5654 are return but not Items 4785 or
5623. If I query the results for Aguy no Items are returned. 
 
Does anyone have any thoughts on this?
 
Thanks

Access to MySQL query problem

[Ed Reed]

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 get results that
look like this

Item  OpUser
2751  2 Dude
2751  3 Aguy
4785  1 Dude
4785  2 Gus
5623  1 Dude
5623  2 Gus
5654  1 Gus
5654  2 Aguy
 
I then query these results to get only the Items for a user when the
specified user is the first person for that Item ID, for example. If I
query the results for Dude Items 2751, 4785 & 5623 are returned. If I
query the results for Gus Item 5654 are return but not Items 4785 or
5623. If I query the results for Aguy no Items are returned. 
 
Does anyone have any thoughts on this?
 
Thanks

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Access to MySQL problem

[Ed Reed]

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 get results that
look like this

Item  OpUser
2751  2 Dude
2751  3 Aguy
4785  1 Dude
4785  2 Gus
5623  1 Dude
5623  2 Gus
5654  1 Gus
5654  2 Aguy
 
I then query these results to get only the Items for a user when the
specified user is the first person for that Item ID, for example. If I
query the results for Dude Items 2751, 4785 & 5623 are returned. If I
query the results for Gus Item 5654 are return but not Items 4785 or
5623. If I query the results for Aguy no Items are returned. 
 
Does anyone have any thoughts on this?
 
Thanks

Re: Transfering from access to MySQL?

[W. D.]

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-Webmasters.com/best-start-page/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: Transfering from access to MySQL?

[Freddie Sorensen]

Jonas

Check out the free DBManager at http://www.dbtools.com.br/EN/dbmanager.php

It can not only import directly from Access but might be very handy later in
your every day work with MySQL as a front-end

Couldn't live without it !

Freddie

-Ursprüngliche Nachricht-
Von: Jonas Lindén [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://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Transfering from access to MySQL?

[Karam Chand]

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!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Transfering from access to MySQL?

[Frederic Wenzel]

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,
Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Transfering from access to MySQL?

[Jonas Lindén]

Hello, Could someone help me with a tip on how I can convert my old Access DBs to 
MySQL?

Regards
/Jonas

Re: Convert MS Access to MYSQL

[Matthew Stuart]

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 was in the right place. I then built a 
table in mysql ensuring that all columns were in the same order as the 
access table (and of the correct format) I then used a plugin for 
access called MyAccess (shareware available via mysql.com), it enables 
you to use access as your GUI to mysql. I then simply used access to 
copy from one table to the other.

It was a very text heavy import to deal with, with hundreds if not 
thousands of illegal characters that would corrupt a mysql db. Myaccess 
escaped them all for me. It was dead simple and I'm no techie.

Job done - in about an hour.

Mat

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Convert MS Access to MYSQL

[kc68]

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 sure that Preferences=>Data=>Use DAO 3.6 is checked as 
instructed.  What am I doing wrong?

Ken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: AW: Convert MS Access to MySql

[Arthur Klimowicz]

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?

Thanks again
Arthur





-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: AW: Convert MS Access to MySql


question... does anyone know how it sets up the indexes, security
preferences , relationships..??? I mean does it do this or  does it just
create the tables and upload the data???


Thanks Tom T

At 06:01 PM 12/22/2003 +0100, you wrote:
>Arthur
>
>Get DBManager Professional (for free) here :
>http://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 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 thanks
> > Arthur
> >
> >
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mann Library
Cornell University
[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: Convert MS Access to MySql

[Thomas Trutt]

question... does anyone know how it sets up the indexes, security 
preferences , relationships..??? I mean does it do this or  does it just 
create the tables and upload the data???

Thanks Tom T

At 06:01 PM 12/22/2003 +0100, you wrote:
Arthur

Get DBManager Professional (for free) here :
http://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 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 thanks
> Arthur
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mann Library
Cornell University
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: Convert MS Access to MySql

[Freddie Sorensen]

Arthur

Get DBManager Professional (for free) here :
http://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 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 thanks
> Arthur
> 
> 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Convert MS Access to MySql

[Matt Lynch]

Hi Arthur,

Dbtools is a free product and it will do the conversion for you. 
http://www.dbtools.com.br/EN/index.php

We have had success converting from MSAccess to MySQL in the past with
it.

Regards,

Matt

-Original Message-
From: Arthur Klimowicz [mailto:[EMAIL PROTECTED] 
Sent: 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 row
by row. Is that the only way to move the data from the one db to the
other?

Many thanks
Arthur


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Convert MS Access to MySql

[Martin Gainty]

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 content over to mySQL

http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

-Martin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Convert MS Access to MySql

[jamie murray]

I'm new to MySql as well but  the "LOAD DATA" statement is probably what
your looking for. It's a bulk loader and dumps the data from a flat file
into a designated table for you. You could easily automate this by writing a
simple perl script(probably php also but im not to familiar with that
language yet) to connect to access,create and load flat files upon closing
you could connect to mysql and run the "LOAD DATA"  and point to the
directory where you just saved the flat files from access.
Course the files will have to be in a particular format tab delimited if im
correct with each line ending with linefeed.
Maybe some MySql veteran would like to add to this or make correction to
what I have stated.
Hopefully this will get you going in the right direction.


- Original Message - 
From: "Arthur Klimowicz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 21, 2003 2:30 PM
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 the data from the one db to the other?
>
> Many thanks
> Arthur
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Convert MS Access to MySql

[Arthur Klimowicz]

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 thanks
Arthur

Low-Level access to MySQL data

[Mark Gimelfarb]

Hello all,
 Has anybody had experience accessing MySQL tables via MyISAM library?
I'm working on an application that has to have both SQL-like and ISAM-like
(file-level) access to the table data. I thought that using MyISAM
directly would be a good idea. If anybody has any better suggestions, I am
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 Sinisa and Sergei concerning use
of HANDLER keyword, and there was one in early 2001 in which Sergei said
that syntax for HANDLER WRITE and HANDLER DELETE was implemented as well. He
then went on to say that he was wrong and only the read access was
implemented via HANDLER. He also said that this might be a project for the
future. Has there been any progress in that area?
 
Thanks in advance.
 
Regards,
 Mark.
P.S. Both C/C++ and Delphi examples/URLs/pointers/ideas will work.
 

Re: Dumb Question - Moving Data from Access to MySQL

[Daniel Kasak]

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 tried:  INSERT INTO EXPARTAB1 VALUES (SELECT * FROM EXPARTAB)
 

That should be:

insert into EXPARTAB1
select * from EXPARTAB
or maybe you should do something like:

insert into destination_tablename ( field_1, field_2 )
select field_1, field_2 from source_tablename
You'll have to do it the 2nd way if you change any field names.

This is the most reliable way to shift data from one database to the 
other ( via Access ).
You can use scripts, but you have to rely on the author of the script 
setting the data types correctly.
Setup your tables yourself, making sure all your destination fields can 
accommodate your data, and the make a set of queries in Access ( access 
calls them 'append queries' ). If there is a problem, Access will 
usually let you know where it occured so you can go and fix it.

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Dumb Question - Moving Data from Access to MySQL

[Jeremy Proffitt]

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 EXPARTAB1 VALUES (SELECT * FROM EXPARTAB)

I have used exportSQL from CYNERGI which is a very simple script for access, but the 
file it creates is 125 Megs to add the data, and I can't easily work with that.

Ugh!  And I can't just UNLOAD/LOAD it all to a file like I did back in my Informix 
Days.  It's gotta be simple, but this had been beating me up all day.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Q: 3rd party ADO access to Mysql?

[Tbird67ForSale]

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 PROTECTED]

RE: Delete user/no access to mysql db

[csebe]

The REVOKE command should do most of the job for you, which is removing the
privileges for a specific user. See the manual for more.

However, the user remains defined in the "user" table (while having no
privileges), until one with access, deletes him/her manually.

HTH,
Lian

> -Original 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 (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 was deleting records from mysql.user. Is there another way?
>
> Thanks,
> Stephan Samuel
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Delete user/no access to mysql db

[Stephan Samuel]

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 was deleting records from mysql.user. Is there another way?

Thanks,
Stephan Samuel


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remote access to MySQL

[Nils Valentin]

Hi Renato,

I think you should check once more the right sfor the user you have. Log in to 
mysql and do:

mysql> SHOW GRANS FOR root ;

You will get something like this:

 GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '17cb702624900fa5'

Check what it says for the combinaion of "username" 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:28、Renato さんは書きました:
> 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 perfect, except MySQL. Always I get error of
>
> access when use:
> > mysql - h xx.xx.xx.xx - u root - p
>
> ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)
>
> Informations:
>
> * I don't have any firewall
> * I have all privileges to all the databases and tables, with user 'root'.
> * I have pleny access to the 'server' machine.
> * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
> network, the reply is positive, what confirms server is on
> * I work with PHP and I have access to Mysql with PHP programming, never
> directly.
> * I use 'mysqld.exe', as MySQL server, without any special configuration in
> my.ini:
> [WinMySQLAdmin]
> Server=C:/MYSQL/bin/mysqld.exe
> [mysqld]
> basedir=C:/MYSQL
> datadir=C:/MYSQL/data
>
> Summarizing: I can't access to the Mysql from Internet!
>
> Some additional suggestions?
>
> Regards,
> Renato Uchoa
> [EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remote access to MySQL

[gerald_clark]

Shane Bryldt wrote:

Just a thought, what about encryption of passwords?  Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
No, it should not.

Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your problem is most likely similar to the problem I had. I don't
know about it working on the intranet for you but by default the windows
version does not have TCP connections enabled, only named pipes (localhost
connections).  It took me a few minutes to realize this the last time I had
it installed on windows.  Check your configuration, as I 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 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 BY 'password';
Edward Dudlik
Becoming Digital
www.becomingdigital.com
 

I have all grant statements:
GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Still not working...
Do you know if Win98 have some trouble receiving telnet commands?
Thanks again.

Regards,
Renato Uchoa
[EMAIL PROTECTED]
- 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+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 perfect, except MySQL. Always I get error
   

of
 

access when use:
   

mysql - h xx.xx.xx.xx - u root - p
 

ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)

Informations:

* I don't have any firewall
* I have all privileges to all the databases and tables, with user 'root'.
* I have pleny access to the 'server' machine.
* Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
network, the reply is positive, what confirms server is on
* I work with PHP and I have access to Mysql with PHP programming, never
directly.
* I use 'mysqld.exe', as MySQL server, without any special configuration
   

in
 

my.ini:
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld.exe
[mysqld]
basedir=C:/MYSQL
datadir=C:/MYSQL/data
Summarizing: I can't access to the Mysql from Internet!

Some additional suggestions?

Regards,
Renato Uchoa
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
   



 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remote access to MySQL

[Shane Bryldt]

This is a good point, my last post was under the assumption that your ISP
did not firewall any ports, since you are on a static IP, that suggests a
server package with no restrictions on hosting.  If so, and you are in fact
running the MySQL on the machine directly live on the internet with no
firewalling in occurance, Windows may still be the criminal, or at least the
Windows version of MySQL with it's default my.ini file.

If I've just been ranting uselessly, ignore me :)

-Shane
- Original Message - 
From: "Primaria Falticeni" <[EMAIL PROTECTED]>
To: "Renato" <[EMAIL PROTECTED]>
Cc: "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
> server. Or you are in a private network which must use IP port forwarding
to
> be reached from the Internet. 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 PROTECTED]>
> Sent: Tuesday, June 17, 2003 9:11 PM
> Subject: 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 BY 'password';
> > >Edward Dudlik
> > >Becoming Digital
> > >www.becomingdigital.com
> >
> >
> > I have all grant statements:
> > GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password';
> > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
> > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY
'password';
> > FLUSH PRIVILEGES;
> >
> > Still not working...
> > Do you know if Win98 have some trouble receiving telnet commands?
> >
> > Thanks again.
> >
> > Regards,
> > Renato Uchoa
> > [EMAIL PROTECTED]
> >
> > - 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+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 perfect, except MySQL. Always I get error
> of
> > access when use:
> > > mysql - h xx.xx.xx.xx - u root - p
> > ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)
> >
> > Informations:
> >
> > * I don't have any firewall
> > * I have all privileges to all the databases and tables, with user
'root'.
> > * I have pleny access to the 'server' machine.
> > * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
> > network, the reply is positive, what confirms server is on
> > * I work with PHP and I have access to Mysql with PHP programming, never
> > directly.
> > * I use 'mysqld.exe', as MySQL server, without any special configuration
> in
> > my.ini:
> > [WinMySQLAdmin]
> > Server=C:/MYSQL/bin/mysqld.exe
> > [mysqld]
> > basedir=C:/MYSQL
> > datadir=C:/MYSQL/data
> >
> > Summarizing: I can't access to the Mysql from Internet!
> >
> > Some additional suggestions?
> >
> > Regards,
> > Renato Uchoa
> > [EMAIL PROTECTED]
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remote access to MySQL

[Shane Bryldt]

Just a thought, what about encryption of passwords?  Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');

Not sure if that is related to the problem, but it may cause an invalid
password error.

However, your problem is most likely similar to the problem I had. I don't
know about it working on the intranet for you but by default the windows
version does not have TCP connections enabled, only named pipes (localhost
connections).  It took me a few minutes to realize this the last time I had
it installed on windows.  Check your configuration, as I 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 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 BY 'password';
> >Edward Dudlik
> >Becoming Digital
> >www.becomingdigital.com
>
>
> I have all grant statements:
> GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password';
> GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
> GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
> FLUSH PRIVILEGES;
>
> Still not working...
> Do you know if Win98 have some trouble receiving telnet commands?
>
> Thanks again.
>
> Regards,
> Renato Uchoa
> [EMAIL PROTECTED]
>
> - 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+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 perfect, except MySQL. Always I get error
of
> access when use:
> > mysql - h xx.xx.xx.xx - u root - p
> ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)
>
> Informations:
>
> * I don't have any firewall
> * I have all privileges to all the databases and tables, with user 'root'.
> * I have pleny access to the 'server' machine.
> * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
> network, the reply is positive, what confirms server is on
> * I work with PHP and I have access to Mysql with PHP programming, never
> directly.
> * I use 'mysqld.exe', as MySQL server, without any special configuration
in
> my.ini:
> [WinMySQLAdmin]
> Server=C:/MYSQL/bin/mysqld.exe
> [mysqld]
> basedir=C:/MYSQL
> datadir=C:/MYSQL/data
>
> Summarizing: I can't access to the Mysql from Internet!
>
> Some additional suggestions?
>
> Regards,
> Renato Uchoa
> [EMAIL PROTECTED]
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remote access to MySQL

[Primaria Falticeni]

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
server. Or you are in a private network which must use IP port forwarding to
be reached from the Internet. 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 PROTECTED]>
Sent: Tuesday, June 17, 2003 9:11 PM
Subject: 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 BY 'password';
> >Edward Dudlik
> >Becoming Digital
> >www.becomingdigital.com
>
>
> I have all grant statements:
> GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password';
> GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
> GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
> FLUSH PRIVILEGES;
>
> Still not working...
> Do you know if Win98 have some trouble receiving telnet commands?
>
> Thanks again.
>
> Regards,
> Renato Uchoa
> [EMAIL PROTECTED]
>
> - 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+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 perfect, except MySQL. Always I get error
of
> access when use:
> > mysql - h xx.xx.xx.xx - u root - p
> ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)
>
> Informations:
>
> * I don't have any firewall
> * I have all privileges to all the databases and tables, with user 'root'.
> * I have pleny access to the 'server' machine.
> * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
> network, the reply is positive, what confirms server is on
> * I work with PHP and I have access to Mysql with PHP programming, never
> directly.
> * I use 'mysqld.exe', as MySQL server, without any special configuration
in
> my.ini:
> [WinMySQLAdmin]
> Server=C:/MYSQL/bin/mysqld.exe
> [mysqld]
> basedir=C:/MYSQL
> datadir=C:/MYSQL/data
>
> Summarizing: I can't access to the Mysql from Internet!
>
> Some additional suggestions?
>
> Regards,
> Renato Uchoa
> [EMAIL PROTECTED]
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remote access to MySQL

[Becoming Digital]

> 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 BY 'password';

Edward Dudlik
Becoming 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+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 perfect, except MySQL. Always I get error of
access when use:
> mysql - h xx.xx.xx.xx - u root - p
ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)

Informations:

* I don't have any firewall
* I have all privileges to all the databases and tables, with user 'root'.
* I have pleny access to the 'server' machine.
* Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
network, the reply is positive, what confirms server is on
* I work with PHP and I have access to Mysql with PHP programming, never
directly.
* I use 'mysqld.exe', as MySQL server, without any special configuration in
my.ini:
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld.exe
[mysqld]
basedir=C:/MYSQL
datadir=C:/MYSQL/data

Summarizing: I can't access to the Mysql from Internet!

Some additional suggestions?

Regards,
Renato Uchoa
[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Remote access to MySQL

[Renato]

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 perfect, except MySQL. Always I get error of
access when use:
> mysql - h xx.xx.xx.xx - u root - p
ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)

Informations:

* I don't have any firewall
* I have all privileges to all the databases and tables, with user 'root'.
* I have pleny access to the 'server' machine.
* Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
network, the reply is positive, what confirms server is on
* I work with PHP and I have access to Mysql with PHP programming, never
directly.
* I use 'mysqld.exe', as MySQL server, without any special configuration in
my.ini:
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld.exe
[mysqld]
basedir=C:/MYSQL
datadir=C:/MYSQL/data

Summarizing: I can't access to the Mysql from Internet!

Some additional suggestions?

Regards,
Renato Uchoa
[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: link from Access to MySQL

[Egor Egorov]

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 be used to modify data in MySQL. 

> - hcir




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

link from Access to MySQL

[Rich Allen]

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]

Re: Migrating Microsoft Access to MySQL

[Crercio O. Silva]

Hi Edward,

Use DBTools Manager 2.0.1 (http://www.dbtools.com.br). It imports
structure, data, indexes, queries and relationships from MSAccess and it's
totally free.

[]s

Crercio

- Original Message -
From: "Edward Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 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?





-
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

Re: Migrating Microsoft Access to MySQL

[Insanely Great]

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: Wednesday, February 12, 2003 1:24 AM
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?
>
>
> -
> 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

Migrating Microsoft Access to MySQL

[Edward Kim]

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://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

Re: Connection ms access to mysql

[Gelu Gogancea]

Hi,

I think is better to export your each table from Access to a .txt formatted
file...fields separated by ',' and end_of_line by ';'.It's better to avoid
Cr or CrLf.
Copy the .txt files into MySQL server host in a directory where MySQL have
reading rights.
And after this you can import in your MySQL tables using (...this can be a
way) LOAD DATA...
E.g:
LOAD DATA INFILE 'the_path_to_one_of_txt_files' INTO TABLE
one_of_table_to_load FIELDS TERMINATED BY ',' LINES TERMINATED BY ';';

This it should be work.

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]

- Original Message -
From: "mc 02" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 7:51 AM
Subject: Re: Connection ms access to mysql


> Hi Bob hall,
>
> I do apologize for being unclear in my previous message.
>
> To answer your question:
>
> >Does the MySQL server run on your FreeBSD system?
>
> Yes MySQL runs prefectly with my FreeBSD 4.6 system.
>
> > How are you trying to export your Jet tables? I assume that's
> what  you mean when you refer to "files". If you actually want to
> put your mdb files on FreeBSD, then you should be asking the
> freebsd-questions list about Samba.
>
> Im still unsure how im exporting the tables. What i want to do is
> exporting all the tables in the mdb files to mysql database and i
> dont know how to go about it.
>
> Thanx
>
> p.s: I'm looking into Samba as u mentioned previously.
>
> Regards
> MC
> --
> __
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> Meet Singles
> http://corp.mail.com/lavalife
>
>
> -
> 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

Re: Connection ms access to mysql

[mc 02]

Hi Bob hall,

I do apologize for being unclear in my previous message.

To answer your question:

>Does the MySQL server run on your FreeBSD system?

Yes MySQL runs prefectly with my FreeBSD 4.6 system.

> How are you trying to export your Jet tables? I assume that's 
what  you mean when you refer to "files". If you actually want to 
put your mdb files on FreeBSD, then you should be asking the 
freebsd-questions list about Samba.

Im still unsure how im exporting the tables. What i want to do is  
exporting all the tables in the mdb files to mysql database and i  
dont know how to go about it. 

Thanx

p.s: I'm looking into Samba as u mentioned previously.

Regards
MC
-- 
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Meet Singles
http://corp.mail.com/lavalife


-
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

RE: Connection ms access to mysql

[mc 02]

Christensen, Dave

There doesnt seem to be any error when performed exports, 
however i still cant see the tables in mysql.


- Original Message -
From: "Christensen, Dave" <[EMAIL PROTECTED]>
Date: Fri, 17 Jan 2003 07:51:28 -0600
To: "'mc 02'" <[EMAIL PROTECTED]>
Subject: RE: Connection ms access to mysql

> What errors are you seeing when you try to perform the 
export?


-- 
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Meet Singles
http://corp.mail.com/lavalife


-
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

Re: Connection ms access to mysql

[Bob Hall]

On Fri, Jan 17, 2003 at 03:15:05AM -0500, mc 02 wrote:
> I've downloaded the necessary application MySQL 3.51 and myODBC for
> freeBSD. On the XP side i only downloaded myODBC. I played around the
> configuration but i still cant seem to export the files to my FreeBSD
> box. 
> 
> What am i doing wrong? Any help will be appreciated.

I think the current port for FreeBSD is 3.23.54. If you've installed 
version 3.51.x, then you're using technology that's way too advanced 
for me. If you've installed 3.32.51, then upgrade to 3.23.54. If your 
port is an earlier version, cvsup the port and then upgrade.

You say that you've downloaded it, but you don't mention installation 
and testing, so I'll ask a dumb question: Does the MySQL server run on 
your FreeBSD system?

If the MySQL server runs on your FreeBSD system, the next question is:
How are you trying to export your Jet tables? I assume that's what 
you mean when you refer to "files". If you actually want to put your 
mdb files on FreeBSD, then you should be asking the freebsd-questions 
list about Samba.

Bob Hall

-
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

Migrate data from access to mysql

[Edgard Dapás]

Hi !!!
I'm new with mysql database.

 I have to migrate the data  from access to mysql, is it posible? How can I
do it?

Thanks for your help




La   información  contenida  en  este  correo  es  para  uso exclusivo de
los destinatarios  del  mismo. Está prohibido a  las personas o entidades
que no sean los destinatarios de este correo, realizar cualquier tipo de
modificación, copia o distribución del mismo.
Si  Ud. recibe este correo por error, tenga a  bien notificar al emisor y
eliminarlo.

This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author  and do not necessarily represent those of
Personal. If you are not the intended recipient, be advised that you have
received this email in error and that any use, dissemination, forwarding,
printing, or copying of this email is strictly prohibited. If you have
received this email in error please contact the sender.(Embedded image
moved to file: pic32301.pcx)


-
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

Connection ms access to mysql

[mc 02]

Hi,

I'm New to the networking world so bare with me. Now i know im
suppose to look through the manual in the mysql website but i still
cant make it work. So i need all the help i can get. 

What i want to do:
===
I want to export my MS Access (2000) files (.mdb)in my WinXP Box to
MySQL server in my FreeBSD 4.6 Box


Here's my problem:
==
I've downloaded the necessary application MySQL 3.51 and myODBC for
freeBSD. On the XP side i only downloaded myODBC. I played around the
configuration but i still cant seem to export the files to my FreeBSD
box. 

What am i doing wrong? Any help will be appreciated.

Regards
MC

-- 
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Meet Singles
http://corp.mail.com/lavalife


-
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

RE: Access to MySQL

[Yves Arsenault]

Thanks to all who replied!

I was just looking at MySQL Front.

Thanks all,

Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242


-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]] 
Sent: December 17, 2002 12:24 PM
To: 'Charles Mabbott'; [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL

There are many tools. Use a gui. mysql front (free), premium soft (my
pick
but has a 29 day trial). There are also many small window applications
to do
this. Do a search at one of the famous downloads. +client +mysql +gui

-Original Message-
From: Charles Mabbott [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 1:45 PM
To: [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL


Yves,

I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.

In Access exported as .txt make sure tab sequential.

Back in MySql I made database active that had 'member'
And did a:
>mysql  load data infile "c:\\mysql\\tmp.txt" into member;

it actually went in quite cleanly.  I am sure there are probably better
ways, I am always willing to learn.  But this is what worked for me
today.

Regards,
Chuck




-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:21 PM
To: 1Mysql
Subject: Access to MySQL

Hello,

Is there a small program that would transfer the contents of an Access
database to MySQL?

TIA,

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823


-
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




-
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

RE: Access to MySQL

[Grant Cooper]

There are many tools. Use a gui. mysql front (free), premium soft (my pick
but has a 29 day trial). There are also many small window applications to do
this. Do a search at one of the famous downloads. +client +mysql +gui

-Original Message-
From: Charles Mabbott [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 1:45 PM
To: [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL


Yves,

I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.

In Access exported as .txt make sure tab sequential.

Back in MySql I made database active that had 'member'
And did a:
>mysql  load data infile "c:\\mysql\\tmp.txt" into member;

it actually went in quite cleanly.  I am sure there are probably better
ways, I am always willing to learn.  But this is what worked for me
today.

Regards,
Chuck




-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:21 PM
To: 1Mysql
Subject: Access to MySQL

Hello,

Is there a small program that would transfer the contents of an Access
database to MySQL?

TIA,

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823


-
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

RE: Access to MySQL

[Charles Mabbott]

Yves,

I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.

In Access exported as .txt make sure tab sequential.

Back in MySql I made database active that had 'member'
And did a:
>mysql  load data infile "c:\\mysql\\tmp.txt" into member;

it actually went in quite cleanly.  I am sure there are probably better
ways, I am always willing to learn.  But this is what worked for me
today.

Regards,
Chuck




-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 16, 2002 12:21 PM
To: 1Mysql
Subject: Access to MySQL

Hello,

Is there a small program that would transfer the contents of an Access
database to MySQL?

TIA,

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823


-
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

Re: Access to MySQL

[B. van Ouwerkerk]

Search the archive!

Short answer:
export to .txt and import in mysql or use ODBC



B.

At 13:20 16-12-2002 -0400, Yves Arsenault wrote:

Hello,

Is there a small program that would transfer the contents of an Access
database to MySQL?

TIA,

Yves Arsenault



-
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

Access to MySQL

[Yves Arsenault]

Hello,

Is there a small program that would transfer the contents of an Access
database to MySQL?

TIA,

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823


-
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

RE: Converting Access to MySQL

[Adolfo Bello]

SELECT @myvar := 1 ;


> -Original Message-
> From: Gerald Norman [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, December 01, 2002 10:37 PM
> To: [EMAIL PROTECTED]
> Subject: Converting Access to MySQL
> 
> 
> I have an application that currently is using an Access 
> database and am 
> in the process of converting over to MySQL.  I downloaded the ODBC 
> driver and have been using ADO and have had no problems at all up to 
> this point.  I have a number of  parameterized SQL statements that 
> worked fine in Access, but aren't working at all with MySQL.  I know 
> that MySQL supports variables in SQL statements using the @ prefix. 
>  I've tried setting that as the prefix for the parameters but 
> it doesn't 
> work.  I keep getting a 'unspecified error' when the SQL statement 
> executes.  Am I missing something or does MySQL not support 
> parameters 
> that can be set at runtime?  Thanks in advance for any assistance.
> 
> 
> -
> 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

Converting Access to MySQL

[Gerald Norman]

I have an application that currently is using an Access database and am 
in the process of converting over to MySQL.  I downloaded the ODBC 
driver and have been using ADO and have had no problems at all up to 
this point.  I have a number of  parameterized SQL statements that 
worked fine in Access, but aren't working at all with MySQL.  I know 
that MySQL supports variables in SQL statements using the @ prefix. 
I've tried setting that as the prefix for the parameters but it doesn't 
work.  I keep getting a 'unspecified error' when the SQL statement 
executes.  Am I missing something or does MySQL not support parameters 
that can be set at runtime?  Thanks in advance for any assistance.


-
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

Re: Help Transferring Data from MS Access to mySQL

[David Gardner]

At 04:12 PM 11/30/02, you wrote:

I've pretty much resigned myself to writing some kind of script to manually
export these records using some kind of unique record delimiter, but I
thought I'd check and see if anyone has any other better ideas on how to get
my data transferred.


You'll find all kinds of converters (including Access to MySQL) at: 
http://www.mysql.com/doc/en/SEC669.html



-
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

Help Transferring Data from MS Access to mySQL

[Jeff Brewer]

I'm very new to mysql and haven't got much of a background in databases
generally, so thanks in advance to any who have the patience to deal with my
question.

I'm trying to get data from ms access 97 to mysql by exporting to a text
file then using the "load data" command to import it.

The data in one of the fields contains all sorts of text, punctuation and
formatting characters, even some html tags and linefeed characters (there's
all kinds of crap in there).

On export, ms access will put quotes around my large text field. I was
hoping that mysql would accept everything inbetween the quotes as the field
value, but it doesn't...it starts a new record with each linefeed character
it encounters.

I believe I read that I can change the record delimiter mysql uses from a
linefeed to something else, but I don't seem to be able to do the same with
the export in ms access (it will let me change the field delimiter but not
the record delimiter).

I've pretty much resigned myself to writing some kind of script to manually
export these records using some kind of unique record delimiter, but I
thought I'd check and see if anyone has any other better ideas on how to get
my data transferred.

Thanks



-
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

Re: Is it possible to export data from access to MySQL?

[Listen Hinz]

Dear Steve,

> Is it possible to export data from MS Access into MySQL?

If you don't care to export every single table manually, this is what
you do:

1. Install MyODBC 3.51.04
2. Configure a system DSN for your MySQL server.
3. In Access, right-click the table to be exported.
4. Choose Export...
5. Choose Data Type "ODBC".
6. Choose a name for the table (default: the Access name).
7. On Computer Data Source, choose the DSN you set up in step 2.

The table will be created in the database you set up in step 2. The
export will create the table definition (.frm) and import the data.

Make sure _all_ your Access tables have primary keys, this makes things
easier.

You may run into trouble if your Access tables have strange column names
(e.g., with spaces, umlauts etc.).

Recently, I tried this procedure on a 500 MB Access table with 1.2
million records, and it took 4 minutes on a 2 GHz single processor
Pentium machine running Win2K with Service Pack 2.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3


- Original Message -
From: "Steve Jackson" <[EMAIL PROTECTED]>
To: "MySQL General Mailing list" <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 3:37 PM
Subject: Is it possible to export data from access to MySQL?


> Is it possible to export data from MS Access into MySQL?
> If so how?
> I have a huge amount of data that will take weeks to input and I've
> convinced my boss to use MySQL rather than any other DB because of
it's
> compatibility with PHP. However I (probably hastily) *assumed* that
> there would be a way to export the data.
> Any ideas?
>
> Steve Jackson
> Web Developer
> Viola Systems Ltd.
> http://www.violasystems.com
> [EMAIL PROTECTED]
> Mobile +358 50 343 5159
>
>
> -
> 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

RE: Is it possible to export data from access to MySQL?

[Steve Bradwell]

I like that one.

Steve Bradwell
MIS Department.

"If you give someone a program, you will frustrate them for a day. If
you
teach them how to program, you will frustrate them for a lifetime."


-Original Message-
From: John Ragan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 12:50 PM
To: MySQL General Mailing list; [EMAIL PROTECTED]
Subject: Re: Is it possible to export data from access to MySQL?



you're gonna get lots of neat high tech answers 
to your problem, so here's a low tech answer just 
because it's fun.

construct the database in mysql.

copy the access database to a working copy to be 
safe.

in the working copy, link to the mysql tables.

open the access table a and copy the data.  open 
the mysql table a and paste the data.

: )   the kid in me loves doing that.  copy and 
paste is the most powerful concept in windows. 
the only reason that i don't use it in corereader 
is that it would permanently tie corereader into 
ms. windows.


> Is it possible to export data from MS Access into MySQL?
> If so how?
> I have a huge amount of data that will take weeks to input and I've
> convinced my boss to use MySQL rather than any other DB because of it's
> compatibility with PHP. However I (probably hastily) *assumed* that
> there would be a way to export the data.
> Any ideas?
> 
> Steve Jackson
> Web Developer
> Viola Systems Ltd.
> http://www.violasystems.com
> [EMAIL PROTECTED]
> Mobile +358 50 343 5159
> 
> 



-- 
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/ 


-
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

Re: Is it possible to export data from access to MySQL?

[John Ragan]

you're gonna get lots of neat high tech answers 
to your problem, so here's a low tech answer just 
because it's fun.

construct the database in mysql.

copy the access database to a working copy to be 
safe.

in the working copy, link to the mysql tables.

open the access table a and copy the data.  open 
the mysql table a and paste the data.

: )   the kid in me loves doing that.  copy and 
paste is the most powerful concept in windows. 
the only reason that i don't use it in corereader 
is that it would permanently tie corereader into 
ms. windows.


> Is it possible to export data from MS Access into MySQL?
> If so how?
> I have a huge amount of data that will take weeks to input and I've
> convinced my boss to use MySQL rather than any other DB because of it's
> compatibility with PHP. However I (probably hastily) *assumed* that
> there would be a way to export the data.
> Any ideas?
> 
> Steve Jackson
> Web Developer
> Viola Systems Ltd.
> http://www.violasystems.com
> [EMAIL PROTECTED]
> Mobile +358 50 343 5159
> 
> 



-- 
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/ 


-
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

Re: Is it possible to export data from access to MySQL?

[Ed Reed]

I used MyAccess to convert my 40mb .mdb file into MySQL and it works
great. You can find it and a whole bunch of other conversion tools on
the MySQL site in Downloads/Other. Here's the link,
http://www.mysql.com/downloads/os-win32.html
 
Good Luck

>>> "Steve Jackson" <[EMAIL PROTECTED]> 11/26/02 6:37:45
AM >>>
Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data that will take weeks to input and I've
convinced my boss to use MySQL rather than any other DB because of
it's
compatibility with PHP. However I (probably hastily) *assumed* that
there would be a way to export the data.
Any ideas?

Steve Jackson
Web Developer
Viola Systems Ltd.
http://www.violasystems.com 
[EMAIL PROTECTED] 
Mobile +358 50 343 5159


-
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

Re: Is it possible to export data from access to MySQL?

[Iikka Meriläinen]

Hi!

Yes, it's possible. Export your Access data to standard csv files, and then
use mysqlimport with appropriate parameters to import the csvs into MySQL.
The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA
INFILE statements (which can do the same as mysqlimport).

Iikka

On Tue, 26 Nov 2002, Steve Jackson wrote:

> Is it possible to export data from MS Access into MySQL?
> If so how?
> I have a huge amount of data that will take weeks to input and I've
> convinced my boss to use MySQL rather than any other DB because of it's
> compatibility with PHP. However I (probably hastily) *assumed* that
> there would be a way to export the data.
> Any ideas?
>
> Steve Jackson
> Web Developer
> Viola Systems Ltd.
> http://www.violasystems.com
> [EMAIL PROTECTED]
> Mobile +358 50 343 5159
>
>
> -
> 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
>


 Iikka Meriläinen
 Vaala, Finland
 E-mail: [EMAIL PROTECTED]


-
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