Steps to install MySQL on Ubuntu Server
After setting up the server, issue the below command to install mysql and its associated libraries
$ apt-get install mysql-server mysql-client libmysqlclient12-dev
Edit MySQL configuration file, to set the IP address that will be dedicated for MySQL.
$ vi /etc/mysql/my.cnf
Uncomment the line that states
#bind-address = 127.0.0.1
Now restart MySQL by typing the below command
$ /etc/init.d/mysql restart
Root password will be blank initially. To change it use:
$ /etc/init.d/mysql reset-password
Give the new password and verify the password again.
To test if the password has been set, you can try
$ mysql -uroot -p
and then wait for the prompt for password entry. This ensures that password has been sent for root account in MySQL.
