Install Mysql and mysql-workbench [apt]

To install latest MySQL to Ubuntu perform the following steps:

1) Download and add the repositories

Download the repositories from the official download page manually. Install them.

2) Update the repository data:

sudo apt update

3) Install MySQL server via apt.

Install MySQL server with the command below. Also, take into consideration the following notes:

  1. During installation you will be asked for a password. Do not leave it blank. For a development computer an easy password like “root” is good enough.
  2. You will be asked to choose the default authentication plugin. For a development computer choose: Legacy authentication.
sudo apt install mysql-server

4) Install MySQL workbench:

Install MySQL workbench with the command below. After installation, open MySQL workbench and verify that you can connect to the server.

sudo apt install mysql-workbench-community

5) Run security installer (optional)

For improved security you should run the MySQL Security installer. You do not have to run the installer on a development computer:

sudo mysql_secure_installation

6) Create a user account (optional)

Create a user account for your application:

Connect to MySQL from terminal:

sudo mysql -u root -p

Create the user account:

CREATE USER 'bob'@'localhost' IDENTIFIED BY 'bobpasswd';

Grant privileges for that user:

GRANT ALL PRIVILEGES ON * . * TO 'bob'@'localhost';

You can generate a strong password with an online application like passwordsgenerator.net

Troubleshooting

If you have problems connecting to the server check the following articles:

References:

1 Comment

Leave a Reply