Topic: mySQL and MSAccess

[ansentry]

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.

[ergozd]

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

[ansentry]

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.
 

[ansentry]

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.

[ergozd]

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

Good luck, Ergin

[ansentry]

ergin,

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

Is there not a easier way?

[ergozd]

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

[ansentry]

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,

 

[ergozd]

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

[Anonymous]

Ergin,

Thank you, will have a look,