Top Left Text cha

Web & App Development

Code samples for installing MySQL on Ubuntu Server via SSH

Install MySQL
sudo apt-get install mysql-server

You'll be asked for a root password that you want to use for the MySQL system.

Secure the installation.
mysql_secure_installation

You'll need to enter the password you supplied for the MySQL system. Then you'll be asked if you want to VALIDATE PASSWORD PLUGIN.  This is optional, but if don't set it up, you should make sure to use secure passwords.  If you do set it up, be sure you don't have anything like software that tries to create DB credentials with non-secure/simple passwords or it will produce errors.  I personally don't set this up, but I make sure that future credentials use secure passwords.

Next you'll be asked if you want to remove anonymous users, the test database, and disable remote logins.  You can usually answer yes to these questions.  Then also enter 'yes' to enable these rules and MySQL will be setup.
  • No comments found

Leave your comments

Post comment as a guest

0
Your comments are subjected to administrator's moderation.
X