Linux installation MySQL Database

Source: Internet
Author: User

MySQL website download rpm package, I choose the latest version of MySQL 8.0

Install RPM Package:rpm -uvh platform-and-version-specific-package-name. RPM

Download MySQL:yum install mysql-server (Note this is-server)

Start Services after installation: Servicemysqld start

To view the status of the database service: service mysqld status

After MySQL installation, there will be a default username root and a temporary password, to view this password can:

grep ' temporary password '/var/log/mysqld. Log

You can then log into the database with the user password that comes with it:

After that, if you are going to use the host's navicat to connect to this database, you will be prompted a series of errors, which is normal.

1.1130 error, this error is because the default user only allows the host to log into the database, to the default root user ' localhost ' to the '% '

create user ' root ' @ '% ' identified by ' xxxxxxxx ';

2.2059 error, this error is the version reason for MySQL.

One solution is to update the driver, this is not researched, and the other is to use the old encryption method to authenticate the user:

ALTER USER ' root ' @ '% ' identified with Mysql_native_password by ' xxxxxxxx ';

Reference: https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-installing

Linux installation MySQL Database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.