Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: ansentry on July 11, 2004, 03:26:29 AM

Title: mySQL and MSAccess
Post by: ansentry on July 11, 2004, 03:26:29 AM

I am using 6.01-01 custom

I have several MSAccess databases running on my sme, that is with the backends on the sme and the forms, queries, reports etc on the "Client", works fine.

What I would like  to do is start (or try) using mySQL as the backend. Could someone please point me in the right direction. I also read here that mySQL (in sme6) is turned off by default, is this correct, if so how do I  turn it on.

Any help would be appreciated.

Title: mySQL and MSAccess
Post by: ergozd on July 11, 2004, 01:24:50 PM

Hi there!

1 - You'll have to convert your MSAccess DBs into MySQl DBs... There are a few converters...

Check http://www.snapfiles.com/get/mdbmysql.html

2 - MySQL is not turned off... Access from other IP adresses are turned off... You can enable access by

Code: [Select]

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart


Best rgds, Ergin

Title: mySQL and MSAcess
Post by: ansentry on July 11, 2004, 02:27:31 PM

ergozd,

Thank you very much your code appreared to run fine,  mySqld started.

I will check out that site in your reply.

Is there anything that I can or need to set up on the sme.

Thank you again from the bottom of the world to the top.
 :lol:

Title: sme and msaccess
Post by: ansentry on July 12, 2004, 08:06:01 AM

I have installed mySQL ODBC 3.51 drivers on my XP pro and when I try and transfer the tables from my access database to mysql I have to enter my user name and password. Because my normal username and password will not work , I assume that I have to use mySQL's user name and password.

Question how to I "add user and password" to mysql.

Any help would be appreciated.

Title: mySQL and MSAccess
Post by: ergozd on July 12, 2004, 08:34:33 AM

Username = root
Password = you'll find it in /root/.my.cnf

Good luck, Ergin

Title: mySQL and MSAccess
Post by: ansentry on July 12, 2004, 09:03:51 AM

ergin,

Thanks for you reply, I had a look at /root/.my.cnf
the password is sooooooooo long.

Is there not a easier way?

Title: mySQL and MSAccess
Post by: ergozd on July 12, 2004, 03:28:00 PM

Quote

ergin,

Thanks for you reply, I had a look at /root/.my.cnf
the password is sooooooooo long.

Is there not a easier way?

Yes, the pwd is long..

Easiest to me would be installing nightspirits phpmyadmin contrib and creating a new MySQL user with granted priviledges.

Good luck, Ergin

Title: mySQL and MSAccess
Post by: ansentry on July 13, 2004, 12:27:15 PM

Ergin,

I did what you suggested and it sure makes things a little easier.

The only strange thing is that the users have been given the right access privlidges in mysql but XP (via ODBC) will not let me log in, the only "user" that XP will let login is a user I set up in phpmyadmin User Blank Password Blank.

Ergin, thanks again for you help,

 :pint:

Title: mySQL and MSAccess
Post by: ergozd on July 17, 2004, 12:13:54 PM

I saw this article the other day... Might worth reading it. ;-)

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

Best rgds, Ergin

Title: mySQL and MSAccess
Post by: Anonymous on July 18, 2004, 09:25:38 AM

Ergin,

Thank you, will have a look,