473,396 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

access/migration problem

107 100+
Hi,

Im having some issues migrating a database using mysql tools.

I have a windows 2000 server running an older version of mysql hosting several databases. If I connect locally on that server using a standard user account I set up (not root) I can see all the schemata.

When I connect from another machine (winxp) I can only see (and therefore migrate) only one database. All I need to be able to do is connect using mysql tools on another machine and be able to see *all* the databases/schemata. I added the new host to the user and I cant see any difference between the "localhost" settings for that user and the ones for the new host.

I tried adding privileges to certain schema for the user on the other host, but now when i connect from it I cant see any schemata!!

Any idea's anyone please?


Thanks

Andy
Dec 10 '08 #1
1 1511
theS70RM
107 100+
if i dont enter a default schema locally it list all the databases, if i do it from the remote machine it doesnt list any, or it lists 1. It's the same user and I cant see any difference between the host settings for the user. =(

additionally, if I enter a schema that doesnt exist it creates it, if i chose one that does exist, it says it doesnt exist then gives me a "Could not connect to the specified instance" error number 1044. which i access denied.
Dec 10 '08 #2

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

Similar topics

2
by: g | last post by:
I have a php scripted that access a mysql database. I use the same access methods in other scripts and it access it the database fine: if (!($connection = @ mysql_pconnect($hostName, $username,...
4
by: Bernardo Robelo | last post by:
Hi, I am interested in migrating Microsoft Access database to Postgres database. But I do not have idea of like initiating. Maybe some tool exists for this problem. Thanks you. Bernardo
1
by: rob | last post by:
Dear All, I have a very small test project to convert asp to asp.net using the Microsoft/Artisan ASP to ASP.NET Migration Assistant...
1
by: Bonggoy Cruz | last post by:
We have a fairly big size ASP.NET web application that was written VB.NET. We are in the process converting the web project. We used the migration wizard included in VS 2005. I followed step by...
4
by: raibeart | last post by:
It is like comparing a VW bug with a Mercedes. JET has corruption problems. It is not meant for use over the internet. It is not meant for more that 3 or 4 users. No clear migration path to...
2
by: virgin | last post by:
Hi all. I am completely new to db2 (v8.2.2) and am trying to import an access db into it. I have read the documation but no success, Any ideas or help would be greatly apprectiated regards
2
by: Igor | last post by:
Can I convert .MDB file to SQL Server database or I need to develop SQL server database from begin, every table, every field?
15
by: Wes Groleau | last post by:
When I try to import from Access, the DTS wizard only allows me to import tables and queries. OK, I'm not surprised the "macros" and reports don't come over. But it executes each query, and...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
11
by: Chad | last post by:
Hi Is it possible to substitute an alternative data source (eg MySQL or SQL Server) into an existing MS-Access application?
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.