To follow this tutorial,you will need: One ubuntu 14.04 Droplet with a sudo non-root user.
# Step1-Installing MySQL If you want to install MySQL 5.5 or 5.6 specifically,the process is still very straightforward.First,update the package index on you server.
Then,to install MySQL 5.5 ,install the mysql-server-5.5 package.
To install MySQL 5.6,install the mysql-server-5.6 package instead.
For both options,you’ll be prompted to create root password during the installation.Chosse a secure one and make sure you remmemeber it,because you’ll need it later.
Step2- Configuring MySQL
You can check your version of MySQL with the following command.
Step3- Connection MySQL
Then ,to enter your password.
Install MYSQL UI
- Error 1046 No database Selected,how to resolve? You need to tell MySQL which databe to use:
Before you crate a table . In case the database does not exist,you need to create it as:
- Show Mysql Port