![]() ![]() ![]() ![]() So before you start working, you need to create a new user and give them the right permissions. This is almost a universal unwritten rule. It is never advisable to use the root user for projects and applications. When finished, the installation will be safe. You can answer them any way you want, but it is recommended to answer all of them Yes. Next, the script will ask you a few configuration questions. Then, it will ask you if you want to change it. It will evaluate the root password and display it on the screen. Another option that will be shown is to use or not, the plugin “validate password”. To launch it, just run this command: :~$ sudo mysql_secure_installationįirst, it will ask you to type in your root password. ![]() The script is called mysql_secure_installation. However, you can use a script that will help to change this password and add new configurations to improve MySQL security. Configure MySQL on Ubuntuīy default, the installation of MySQL only makes small configurations, for example, the definition of the password for the root user. Once the installation is finished, you can verify the operation of the MySQL command by showing, for example, the installed version. You have two options, to use the most recent one that is encrypted and more secure, or to use the old version. Then, the installer will allow you to choose the default authentication plugin. So this root password has to be quite strong. The root user is the most important one because it has access to the whole program and is the one who creates the users, assigns the different permissions, etc. The first is to set a password for the root user. :~$ sudo apt updateįinally, you can install MySQL on Ubuntu with the following command: :~$ sudo apt install mysql-serverĪgain during the installation process, some settings will be made. When you finish the configuration of the repository, refresh the APT cache to apply the changes. In this case, the default configuration is enough, so use the keys on the keyboard to press the OK option. For example, the connectors for the different programming languages. In it, it is reported that the repository incorporates several extra features. In the package configuration you will see the following image: To do this, type the following command: :~$ sudo dpkg -i mysql-apt-config_0.8.14-1_all.deb Then you need to install it using the dpkg command. The package is quite small so the download will be fast. :~$ ssh you are logged into your terminal, download the MySQL DEB package that sets up the repository as shown below. Equally important is that the user has the sudo command enabled. If this installation will be done in a server, then connect through SSH using Putty. This means that the installation is simple and that through APT you can always have the application updated. The good news is that Oracle makes available a repository dedicated to Ubuntu. Especially if you are talking about a data server or a development team that requires new features to be explored. Install MySQL on Ubuntuīeing a major version that incorporates many changes, it becomes vital for any Ubuntu user to have MySQL on the computer. MySQL 8 is the latest stable release that incorporates many new features in performance, security and multi-model support. Even for custom web stack development, it is one of the most preferred databases. Most of the open-source software like WordPress, Drupal, Joomla, etc uses MySQL as a database. There are two licenses, a commercial one and another for the community version (GPLv2). MySQL is a relational, open-source database management system, founded by Michael Widenius and Axmark began and now owned by Oracle Corporation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |