官术网_书友最值得收藏!

  • MySQL 8 for Big Data
  • Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
  • 171字
  • 2021-08-20 10:06:07

MySQL 8 installation

Once you have the RPM packages, just install it using the following command. This will place the required files and folder under the system directories:

rpm -vih <package-name>.rpm

For the standard installation, it requires only mysql-community-common, mysql-community-libs, mysql-community-client, and mysql-community-server packages. Look at the following screenshot for the installation process:

After the successful installation, just check its version to validate if it's installed properly and can be accessible:

The next step is to reset the temporary password during post-installation. MySQL will restrict you to use the database before changing this temporary password. A temporary password will be generated by MySQL and available in its log file. To retrieve a temporary password, you need to open the /var/log/mysql/mysqld.log file and search for the temporary password keyword.

Copy this and try to connect to MySQL with the following command:

As shown in the preceding screenshot, you will land on a MySQL command prompt, where you can execute the following query to reset the password:

ALTER USER 'root'@'localhost' IDENTIFIED BY '<NEW_PASSWORD>';
主站蜘蛛池模板: 张北县| 白沙| 黄浦区| 靖江市| 玉田县| 剑阁县| 道真| 平果县| 清徐县| 桦川县| 浮梁县| 华蓥市| 宾川县| 宁陕县| 玛曲县| 德令哈市| 黎城县| 深水埗区| 休宁县| 紫金县| 宜兰县| 玉林市| 长岭县| 武隆县| 陆川县| 普兰店市| 聂荣县| 新兴县| 石首市| 文成县| 碌曲县| 栖霞市| 固镇县| 芜湖县| 会理县| 成安县| 西藏| 东兰县| 石柱| 陆川县| 香格里拉县|