Connection Issue

[expired user #2747]'s profile image [expired user #2747] posted 17 years ago in Creating a connection Permalink
Hi,
Just installed this and trying to connect to the database, a couple of things, not sure if I am able to connect using this program. Is it possible within MYSQL to prevent this type of program connecting to it?

Also when I try to connect using my logon details to the ERP system it shows the username as admin@localhost when all it is looking for is Admin
I am presuming his as when I log in with the logon box I only type in Admin

The program I am using is called 2Clix (www.2clix.com.au) and I do not have access to the Database as admin as it is a ERP program (like SAP for example etc) and has been locked down as far as I know

Any assistance would be great, also has anyone connected in to a MYSQL database using XML in a web interface to extract and import data?

Thanks
Karl
[expired user #1821]'s profile image [expired user #1821] posted 17 years ago Permalink

Hi,
Is it possible within MYSQL to prevent this type of program connecting to it?



No.
It's possible to prevent connections from outside (so, not from the localhost), but that's where it ends.

Also when I try to connect using my logon details to the ERP system it shows the username as admin@localhost when all it is looking for is Admin
I am presuming his as when I log in with the logon box I only type in Admin


I'm not sure what you mean here.
MySQL distinguishes between the username and the host from which you connect. They are two different things (although when you set permissions, you would write admin@localhost to indiciate that the admin can only connect from the localhost .. but that's just syntax).
So, if HeidiSQL is running on the same computer as the database, you have to give 'admin' as the username and 'localhost' as the hostname / ip.
If Heidi is not running on the same computer then you have to check the priviliges in MySQL to make sure the user 'admin' can also connect from outside.
See also this topic

has anyone connected in to a MYSQL database using XML in a web interface to extract and import data?



XML is a markup language, so connecting to a database will be impossible.
You will need a proper programming language like Java, PHP, etc. to make the connection and then you can use that to output XML (or read XML and put it in the database).

Please login to leave a reply, or register at first.