Tech-Today

How to install MySQL in Ubuntu 16.04

The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server.

# install mysql
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server
sudo mysql_secure_installation

mysql -u root -p

# \h - for help

# create a test database and login account
create database testdb;
create user 'kerri'@'localhost' identified by 'secret';
grant all on testdb.* to 'kerri';

exit

# login using the newly created user
mysql -u kerri -p

# create a table using the newly created database
use testdb;
create table movies (movie_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, movie_name TEXT, release_date DATE);

# reset the MySQL password
sudo service mysql stop
sudo dpkg-reconfigure mysql-server-5.5
sudo service mysql start

# login as root
mysql -u root -p

# tune MySQL
sudo apt-get install mysqltuner
mysqltuner

- Java Standalone Persistence Using Jpa
This application demonstrates the use of JPA in a standalone Java application. I. Getting StartedThis project is a standalone Java application that reads a server log file, parses and saves to a MySQL table access_log. It also executes a named query...

- Setup Mysql Database For Remote Access
Here are some useful guidelines in setting up a mysql server for remote access in Ubuntu. Install and configure mysql server. sudo apt-get update sudo apt-get install mysql-server mysql_secure_installation *Note in MySQL - it will ask to set the password...

- How To Install Apache2 Php5 And Mysql5 In Ubuntu 12.04
These are the set of scripts I executed in ubuntu to install the ff: 1.) apache2 2.) php5 3.) mysql5 >sudo apt-get install apache2 //installs in /etc/apache2 >sudo apt-get install php5 //installs in /etc/php5 >sudo apt-get install libapache2-mod-php5...

- How To Install Subversion And Websvn On Ubuntu 12.04
This write-up contains a set of instruction on how to install and configure svn as well as setup websvn on an ubuntu 12.04 machine. 1.) Install subversion and apache2 sudo apt-get install subversion sudo apt-get install apache2 sudo apt-get install libapache2-svn...

- Mysql Engine: Myisam Vs Innodb
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html) -to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script -supports table locking (this is an issue when you need to backup the whole database) -fast execution...

Tech-Today