ubuntu 16 download mysql server from scratch

How to Download and Install MySQL ODBC Driver on Ubuntu 16

Installing the MySQL ODBC driver on Ubuntu Linux is a crucial step in setting up Tableau Server, which allows users to connect and query data from MySQL databases across various operating systems and devices. In this tutorial, we will provide a step-by-step guide on how to download and install the MySQL ODBC driver on Ubuntu 16.

Downloading the Binary Tarball Distribution

To begin with, you need to download the binary tarball distribution file of the MySQL ODBC driver from 'here'(https://dev.mysql.com/downloads/connector/odbc/). The file is available in a `.tar.gz` format, which needs to be extracted and installed manually.

Extracting the Tarball Distribution

Once downloaded, extract the tarball distribution file using the following commands:

```

gunzip mysql-connector-odbc-5.3.tar.gz

tar xvf mysql-connector-odbc-5.3.tar

```

This will create a new directory containing the extracted files.

Unzipping and Configuring

Next, change into the extracted directory using the following command:

```

cd mysql-connector-odbc-5.3

```

Then, configure the MySQL ODBC driver by running the following commands:

```

./configure --prefix=/usr/local/mysql-connector-odbc-5.3

make

make install

```

Installing UnixODBC

To use the MySQL ODBC driver, you also need to install UnixODBC on your Ubuntu system. You can do this by running the following command:

```

sudo apt-get install unixodbc

```

Configuring the MySQL ODBC Driver

After installing UnixODBC, configure the MySQL ODBC driver by creating a new file called `odbcinst.ini` in the `/etc/odbcinst.ini` directory. Add the following lines to the file:

```

'MySQL ODBC 5.3 ANSI (64-bit)'

Description = MySQL ODBC 5.3 ANSI Driver

Driver = /usr/local/mysql-connector-odbc-5.3/lib/libmyodbc5a.so

'MySQL ODBC 5.3 Unicode (64-bit)'

Description = MySQL ODBC 5.3 Unicode Driver

Driver = /usr/local/mysql-connector-odbc-5.3/lib/libmyodbc5w.so

```

Testing the MySQL ODBC Driver

To test the MySQL ODBC driver, use the following command:

```

isql -v mysql://username:password@localhost/your_database_name

```

Replace `username`, `password`, and `your_database_name` with your actual database credentials.

By following these steps, you should be able to successfully install and configure the MySQL ODBC driver on Ubuntu 16. This will enable Tableau Server to connect and query data from MySQL databases across various operating systems and devices.

Ubuntu 16 download mysql server from scratch