AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MySQL - Data connection

9 REPLIES 9
Reply
Message 1 of 10
gvanaco
443 Views, 9 Replies

MySQL - Data connection

Can you tell me what the 'service name' by an MySQL connection is?

Do you also have an example database structure for map3D in MySQL?
9 REPLIES 9
Message 2 of 10
gvanaco
in reply to: gvanaco

When I make a connection, I get always the error

RDBMS: Unknown MySQL server host 'localhost' (11001)


Somebody suggestions? null
Message 3 of 10
spatialnetbrek
in reply to: gvanaco

When I installed MySQL I kept the default service name "MySQL".

When I connect I use:

mysql@localhost

Hope this helps,

Brek
Message 4 of 10
Anonymous
in reply to: gvanaco

You have to use 'localhost' if MySQL is in the same machine where Autodesk
Map 3D 2007 is. If so and still fails check the file 'host' in this
directory

C:\WINDOWS\system32\drivers\etc

where you have to see inside a line like this one

127.0.0.1 localhost

Thanks

Richard Horrocks
Message 5 of 10
gvanaco
in reply to: gvanaco

I have checked the file and he says 'localhost'

I have used my mysql login and administrator password.

but no way to go inside.
RDBMS is the errormessage that I receive.


When I use mysql@localhost for the service name, I get the message: Access devied for user '???'@'%' to database 'mysql'

And when I use the root login name, I get only RDBMS

I don't get it.
Message 6 of 10
Anonymous
in reply to: gvanaco

I have put in service name my host and port, in my case i'm working with a local database for development so i used:
service name "127.0.0.1:3306"
In user name i used my root a pass
user "root"
pass "********"
and in data store i have entered a database created for this test
data store "prueba"
Message 7 of 10
Anonymous
in reply to: gvanaco

Excuse me, the user and pass are mysql user and pass
I think that you are not going to have problems if you create new user in mysql and use it's
I hope it help you.
Message 8 of 10
Shie-Li
in reply to: gvanaco

I have Map 3d and MySQL on the same Windows XP machine. I use default installation and ‘localhost’ as the service name. Do you have MySQL as a windows service? Just wonder if you can connect to MySQL outside of Map. Can test it with dos command:
>mysql –u root –p
(note: there is no space after –p)

If you can connect, see what is in the host column of the user table in mysql database:
mysql> use mysql
mysql> select host, user from user;

When creating a new data store, the following tables are created:

mysql> show tables;
+-------------------------+
| Tables_in_datastore3 |
+-------------------------+
| f_associationdefinition |
| f_attributedefinition |
| f_attributedependencies |
| f_classdefinition |
| f_classtype |
| f_dbopen |
| f_options |
| f_sad |
| f_schemainfo |
| f_schemaoptions |
| f_spatialcontext |
| f_spatialcontextgeom |
| f_spatialcontextgroup |
+-------------------------+
13 rows in set (0.00 sec)
Message 9 of 10
gvanaco
in reply to: gvanaco

Does someone have a blanc database example for mysql?
Message 10 of 10
gvanaco
in reply to: gvanaco

I have made a sceenshot.

That user hase access to everything.

The datastore pulldown stays blanc.

The @-symbol makes no difference

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost