Connect to MySQL across network using MS Access

17 Nov 2005

Connect to MySQL across network using MS Access

• comment out line in /etc/mysql/my.cnf that reads:

  bind-address = 127.0.0.1

  • grant root access across network (see MySQL Documentation)

    mysql> use mysql;
    mysql> select Host, User, Password from user;
    mysql> update user set host=‘%’ where user = ‘root’;
    mysql> q

  • restart

  $ /etc/init.d/mysql restart

  • install/configure odbc on server

    $ aptitude install libmyodbc

  • configure Access on client

    • download/install MyODBC
    • create a new database (not a project)
    • File, Get External Data, Link Tables, ODBC Databases
    • Create a MyODBC DSN