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

  • 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>';
主站蜘蛛池模板: 彰化市| 玉田县| 海原县| 荔波县| 清丰县| 石棉县| 泗洪县| 安化县| 博白县| 黄大仙区| 常山县| 尼木县| 安西县| 屏山县| 江安县| 滁州市| 磐安县| 孟连| 措美县| 隆昌县| 浦县| 广丰县| 清水河县| 都江堰市| 肇源县| 江川县| 响水县| 乳源| 古浪县| 汾西县| 原阳县| 阜阳市| 罗江县| 游戏| 宁波市| 永修县| 福贡县| 抚宁县| 黔东| 偃师市| 尼玛县|