How to install mysql online on linux

How to install mysql online on linux: first install the wget software package in linux; then install mysql through the yum install command; finally restart the mysql service through "service mysqld restart".

Recommended: "mysql video tutorial"

##The general idea is as follows:

1.wget http://dev .mysql.com/get/mysql-community-release-el7-5.noarch.rpm

• Explanation: wget is a tool for downloading files , is the collective name of World, Wide.Web and get, which is used on the command line. It is an essential tool for Linux users, especially for network administrators, who often need to download some software or restore backups from remote servers to local servers. If we use a virtual host, to handle such a transaction, we can only download it from the remote server to our computer disk, and then use the xftp tool to upload it to the server. Wget can download directly to the server without uploading, which saves time.
• Usage conditions: wget can support HTTP, HTTPS, FTP download methods
• Usage method: wget [parameter] [URL address]
  
  • Parameters: Omit here
  • RUL address: It is the path you requested. It is downloaded to the /root root directory by default and the file is saved with the original file name. , you can also reset it yourself
• Possible problems: -bash: wget: command not found
  
  • Source of the problem: The wget software package is not installed in linux
  • Solution: Run the command:yum -y install wget, the The explanation of each statement will be discussed below
    

2.rpm -ivh mysql-community-release-el7-5. noarch.rpm

• Explanation: The rpm command is a management tool for RPM software packages, similar to the "Add/Remove Programs" in Windows
• Usage: rmp [options] [parameters]
  
  • Option: What is written here is -ivh, which means the installation progress will be displayed during installation
  • Parameter: It is the name of the rmp software package to be operated, in This is the mysql-community-release-el7-5.noarch.rpm file downloaded in the first step
    

yum install mysql-community-serverYou can also download to the specified directory:yum install mysql-community-server -y --downloaddir=/usr/local/src

Explanation: It is a package manager based on RPM package management. It can automatically
• download rmp packages from the specified server and install. It can automatically handle dependencies and install all dependencies at once. software package, no need to download and install it again and again. yum provides commands to find, install, and delete a certain, a group, or even all software packages.
Usage: yum[option][command][package name]
Command: I am using install download
Package name: This is mysql-community-server, which specifies the package to be downloaded
• 
  If this happens, complete! Indicates that the MySQL database has been installed successfully
  

service mysqld restart

Explanation: Restart the MySQL service
• 
  
##5.

• ##
  • If you want to set a password, you can then enter:mysql -u root -p;, you will be prompted to enter the password you want to set, then enter the password you want to set.

  • Another way to set password:

    • use mysql
    • update user set password= password('123456') where user='root';
    • flush privileges;

    • ##exit;

    • It seems that the first method did not work. I used the second method. When logging in with the password, I entered:
      mysql -u root -p;, you can try them all

  【Note】 Mysql in Linux is case-sensitive. If you want to be size-insensitive Write, you can modify the my.cnf configuration file (you can search through whereis my.cnf), add
  lower_case_table_names=1under the [mysqld node]
  Operations on MySQL databases and tables in Linux
  

The above is the detailed content of How to install mysql online on linux. For more information, please follow other related articles on the PHP Chinese website!